RBR Tick Import
- Utilities
- Version: 1.0
A custom symbol built from imported ticks is only as good as its clock. MetaTrader 5 does not convert the time zone when ticks are imported, and the time offset and daylight saving rule of a downloaded file usually have to be set by hand. RBR Tick Import finds them itself: week by week it matches the hourly price changes of your file to the H1 candles of the chart symbol. Then it cleans the data, writes the ticks into a custom symbol and saves a report. It never sends orders.
What it does
- Reads tick files you downloaded yourself (CSV or TXT, UTF-8 or UTF-16) from Common\Files\RBR_IMPORT. A file mask joins several files, for example monthly ones, into one stream.
- Recognises the format from the first lines: separator (tab, semicolon, | or comma), header, date and time in one or two columns (YYYYMMDD HHMMSSmmm, YYYY.MM.DD HH:MM:SS.mmm, DD.MM.YYYY, MM/DD/YYYY, Unix time in ms or s). Bid and ask are taken from the header names or from which price is higher, so the order ask, bid also works. Empty price fields of a MetaTrader export are filled with the last price. If the day/month order cannot be told from the file, it stops and asks for the "Date order" input instead of guessing.
- Cleans the data: time going back by more than 60 s is a repeated stretch (for example an hour repeated at a clock change) and is removed; going back by up to 60 s is aligned. Ticks with ask below bid are removed; unreadable lines are skipped and shown with examples in the report.
- Matches the file clock automatically: server = file + B h, + a h in US summer time, + b h in EU summer time (a and b are -1, 0 or +1). For each week the shift comes from the correlation of hourly price changes with the chart's H1 candles - changes, not price levels, so it also works when the source quotes a slightly different price than your broker. The model that fits the most weeks wins; weeks that do not fit are listed (a file glued from different sources or shifted by hand shows up there). A manual clock is available too.
- Creates a custom symbol with properties copied from the chart symbol and writes the ticks in server time. MetaTrader builds the M1 candles from the same ticks, so candles and ticks agree.
- Saves an HTML and a text report: format, cleaning, clock with the weeks that do not fit, month by month (ticks, minutes with ticks, M1 candles, spread of the file next to the broker's spread from ticks), gaps of 4 hours or more on working days and a check of the written symbol. "Check only" does the same without creating a symbol.
How to use it
- Copy your tick file(s) to Common\Files\RBR_IMPORT (File > Open Data Folder, one level up, then Common\Files).
- Attach RBR Tick Import to a chart of the same instrument at your broker (any timeframe). Its H1 candles are the reference for the clock.
- Set the file mask and the name of the new symbol (empty = chart symbol + _IMP), or turn on "Check only" to check the file first.
- Progress is shown in the corner of the chart. At the end the result appears on the chart and the report is saved in Common\Files\RBR_IMPORT.
Inputs: File(s) (mask), New custom symbol, Check only, Replace an existing custom symbol, File clock (automatic or manual), Manual clock: hours, US summer, EU summer (-1, 0, +1), Date order (auto, DD/MM, MM/DD), Report language (auto, English, Polish, German).
Notes
- The automatic clock needs H1 candles of the chart symbol in the period of the file, and the file must be the same instrument. Otherwise set the clock manually.
- If the common period covers only one season, or has no weeks between the US and the EU clock change, the report says that the daylight saving rule cannot be determined instead of guessing.
- M1 candles are checked only within the terminal's "Max bars in chart" limit; the Strategy Tester uses the full history.
- Candle files (open, high, low, close) are refused: it needs ticks with bid and ask.
- It does not download data - you bring your own file, and it must be in Common\Files\RBR_IMPORT (MetaTrader programs can read files only from the terminal's own data folders).
- To see gaps, missing candles and the clock of the new symbol afterwards, run RBR Tick Check on it.
- It works on a chart. In the Strategy Tester it only prints a message.
- No DLL, no internet connection, no trading functions.
