Rearview Download

Backtesting Sharadar Core US Equities on a Mac

Sharadar’s Core US Equities tables (sold by Sharadar and through Nasdaq Data Link) give systematic equity traders everything survivorship-free research requires: a permanent company id (permaticker), delisted companies with the reason each company delisted, splits, dividends and historical S&P 500 membership by date.

Because Sharadar downloads directly as CSV tables on macOS, pairing Sharadar with Rearview gives you a survivorship-free portfolio backtesting workflow entirely on macOS, with no Windows virtual machine and no custom Python simulation engine to maintain.

Step by step: importing Sharadar tables into Rearview

  1. Download your tables under your own subscription: TICKERS, SEP (stock prices, called stocks on sharadar.com) and ACTIONS, plus optionally SFP (fund and ETF prices, called funds on sharadar.com) and SP500. Unzip any zipped downloads and place the CSV files in one folder (rows can be in any order, and standard filenames such as SHARADAR_SEP_20261027.csv or stocks.csv are recognised automatically).
  2. Import in one step. In Rearview, choose Data Library ▸ Import ▸ Sharadar Files… and pick the folder. Rearview converts the tables, imports the store and displays the conversion and quality reports.
  3. Or convert from the command line and import the output folder:
rvw convert sharadar <folder> --out <import-folder>
rvw import <import-folder> --store <store>

Rearview never connects to Sharadar or stores your API keys: it reads only the local files you downloaded.

How Rearview reconstructs your data

  • Permanent ids (permaticker). Each company keeps its Sharadar permaticker as its internal security id, so a ticker symbol reused by another company later never merges two unrelated price histories.
  • As-traded prices rebuilt automatically. Sharadar’s close column is adjusted for splits while closeunadj isn’t. Rearview takes the as-traded close from closeunadj, scales open, high and low by their ratio to close, converts split-adjusted volume back into as-traded shares, and computes its own split-adjusted and total-return series using only past actions. That keeps price filters (close > $5), share counts and per-share commissions accurate on historical dates.
  • Delisting reasons from ACTIONS. Acquisitions and stock mergers close at the last traded price with no haircut (mergers are flagged on the trade); bankruptcies, liquidations and regulatory delistings are priced as performance delistings with your configured exchange haircut (default 30% NYSE, 55% Nasdaq); any other delisting is marked UNKNOWN and priced cautiously with a warning.
  • Point-in-time S&P 500 membership. When SP500 is included, scripts write members("SP500") to trade only stocks that were actually in the index on each historical close.
  • Built-in consistency check. The converter checks every step in Sharadar’s price adjustment between consecutive days against ACTIONS: every adjustment step must match a split in ACTIONS, and every split in ACTIONS must appear as a step in the prices. Any mismatch is reported with its ticker and date.

Running a survivorship-free script on Sharadar

Once imported, a Rearview strategy reads point-in-time index membership and as-traded price filters directly:

language 1
strategy "S&P 500 RSI(2) pullback" {
  universe   members("SP500")
  regime     close("SPY") > sma(close("SPY"), 200)
  rsi2       rsi(close, 2)
  enter long when regime and close > 5 and close > sma(close, 200) and rsi2 < rsi_entry
  rank by    -rsi2
  size       10% of equity, max 10 positions
  exit when  rsi2 > 70 or bars_held >= 10
  fill       next_open
  param      rsi_entry = 10 in 5..20 step 5
}

Because close > 5 evaluates on as-traded prices while sma(close, 200) evaluates on split-adjusted prices and rsi(close, 2) on total-return prices, a stock that later split 16-for-1 isn’t wrongly excluded in earlier years.

Updating without breaking reproducibility

When you download fresh Sharadar tables into the same folder and choose Update from Source, Rearview compares the new data against the old up to the previous last date. Because Rearview rebuilds as-traded prices from closeunadj, new splits that cause Sharadar to restate earlier adjusted closes don’t look like changed history: earlier saved runs still reproduce byte for byte.

What Sharadar’s tables can’t tell Rearview

  • Former tickers. Each security holds the single ticker listed in the tables. Index universes (members("SP500")) and sector filters aren’t affected; a script looking up a company by an older ticker name won’t find it.
  • Spinoffs and mergers. Spinoff and merger corporate actions aren’t applied to actions.csv (a spinoff’s price drop stays in the prices, and unhandled ACTIONS rows are counted in the conversion report).
  • Fundamentals. Rearview reads price, corporate action and membership tables; fundamental tables aren’t imported automatically (custom point-in-time numbers can still be supplied via series/ files in the import format).
  • Testing status. As noted on Your data and Importing your data, the Sharadar converter’s column names and file shapes have been checked against Sharadar’s published sample tables and round-trip tested on synthetic tables, not yet a complete full download. If a column in your download is missing or named differently, send the table’s header row and the conversion report to support and it gets fixed.

Try Rearview on your Mac

Rearview runs natively on Apple silicon (macOS 26 or later), verifies every release against a second engine and thousands of look-ahead cut-date runs, and checks every parameter search with Deflated Sharpe and PBO. One-time licence, no subscription, and a 30-day free trial with no card needed. Download Rearview or read Importing from Sharadar.

Sharadar licenses its data for personal use: never share your downloaded tables or imported stores. Product names belong to their owners. Rearview isn’t affiliated with or endorsed by them.