Data that works with Rearview
Rearview tests on market data you bring, and it doesn’t resell any. Each source below says how it comes in, what it can’t tell the engine, and how far it has been tested so far. The import guide has the detail. Most data vendors license their data for personal use only, so check your vendor’s terms before you import, and never share an imported store.
The import format
A folder of CSV files that hold prices as they traded, corporate actions, delistings and index membership by date. It’s the format to aim for: only with it can a backtest be free of survivorship bias and look-ahead in its universe. Any source can be written to it.
- In the app: Data Library ▸ Import ▸ CSV Folder in the Rearview Format…
- Reference: The import format
Per-symbol files
One CSV or text file per ticker, as most tools and data vendors export them: Yahoo Finance, Stooq, AmiBroker and others, daily or down to the minute. Rearview converts the folder into the import format, and coins, forex pairs and stocks of other exchanges come in the same way.
- In the app: Data Library ▸ Import ▸ Per-Symbol Files…, or
rvw convert ohlcv - What it can’t tell the engine: whether the prices are already adjusted, which companies have since been delisted, and which stocks were in an index on a past date. The converter’s report says so, and the data library shows it with the data.
- Tested: the calendars of exchanges outside the US, so far on vendors’ samples and on files made to their published layouts, not yet on full downloads.
- Reference: Converting per-symbol files
Norgate Data
Norgate Data’s updater runs only on Windows, so Rearview comes with a script that exports your Norgate data in the import format, on the Windows computer or virtual machine where the updater runs: delisted stocks, bars as traded, dividends and splits, and with a subscription that includes past constituents, index membership by date.
- In the app: Data Library ▸ Import ▸ Norgate Export Script… saves the script, or download it
- What it can’t tell the engine: why a stock delisted, so every delisting is priced as a performance delisting, with the exchange’s haircut and a warning; and past tickers.
- Tested: so far on vendors’ samples and on files made to their published layouts, not yet on a full download.
- Reference: From Norgate
Sharadar
Sharadar’s Core US Equities tables hold what survivorship-free research needs: a permanent id for every company, delisted companies with the reason they delisted, splits, dividends and S&P 500 membership by date. You download the tables yourself, under your own subscription, and Rearview converts the files. It never connects to Sharadar.
- In the app: Data Library ▸ Import ▸ Sharadar Files…, or
rvw convert sharadar - What it can’t tell the engine: former tickers, and spinoffs and mergers, whose rows aren’t applied.
- Tested: against Sharadar’s sample tables, not yet a whole download.
- Reference: From Sharadar
Futures contracts
One file per futures contract, with a list of the chains and the contracts you’d trade. Rearview builds each chain and its rolls from one contract to the next.
- In the app: Data Library ▸ Import ▸ Futures Contracts…, or
rvw convert futures - Tested: so far on vendors’ samples and on files made to their published layouts, not yet on full downloads.
- Reference: Converting futures contracts
Your broker’s file
A live account reads your broker’s record of what you traded to replay your account beside the backtest: an Interactive Brokers Flex Query, or Rearview’s own fills and statement CSVs, which any other broker’s export can be converted to.
- Tested: the Interactive Brokers files have so far been tested on files made to Interactive Brokers’ published layouts, not yet on a real account’s.
- Reference: Your broker’s file
When one doesn’t import
The import report lists each error with its file and line. If a file from one of these sources doesn’t import, write to support and it gets fixed.