Norgate Data on a Mac
Norgate Data is widely used by systematic traders because it provides survivorship-free equity histories: delisted companies, corporate actions and (on subscriptions that include past index constituents) historical index membership. Because Norgate Data Updater “will only work under Windows”, Mac traders usually end up running their backtester inside Windows as well.
You don’t have to run your backtesting inside Windows. Norgate’s own FAQ states that during an active subscription “you may export or extract data and process it on any other computer, operating system, server”, provided the use stays personal. Rearview ships with an open Python export script (norgate_export.py) that extracts your Norgate databases on Windows into Rearview’s documented import format so you can run all your research, scans, parameter searches and live tracking natively on Apple silicon.
Step by step: exporting Norgate Data to Rearview
- Save the export script. In Rearview, choose Data Library ▸ Import ▸ Norgate Export Script… and save
norgate_export.pyto a folder your Windows machine or virtual machine can read (or download norgate_export.py). - Install Norgate’s Python package once on Windows. With Norgate Data Updater running on Windows, install
norgatedatawithpip install norgatedata. - Run the export into a folder shared with your Mac (example command below).
- Check the export report. Open
norgate-export-report.txtinside the output folder. Before writing, the script rebuilds each security’s total-return prices from the bars, splits and dividends it’s about to export and compares them against Norgate’s own total-return series, listing any security that differs by more than 0.2% with the day of the largest gap. - Import on your Mac. In Rearview, choose Data Library ▸ Import ▸ CSV Folder in the Rearview Format… (or run
rvw import <import-folder> --store <store>on the command line) and select the exported folder.
For example, to export US Equities and US Equities Delisted from 2005 with historical S&P 500 membership into a shared Mac folder mapped as Z::
python norgate_export.py --out Z:\Rearview\Norgate --index "S&P 500=SP500" --from 2005-01-01What the export includes
- Active and delisted stocks and ETFs from Norgate’s
US EquitiesandUS Equities Delisteddatabases by default, starting from--from(2000-01-01unless you pass a date). You can also pass--database,--watchlistand--symbol(such as--symbol $SPX, or'$SPX'in PowerShell). - As-traded bars, dividends and splits derived from Norgate’s capital adjustments, so Rearview computes split-adjusted and total-return series itself using only past actions while keeping fills and price filters on as-traded prices.
- Point-in-time index membership for every
--index "NAME=LABEL"you pass, available in scripts asmembers("SP500"). Historical membership needs a Norgate subscription that includes past index constituents. - GICS sector, industry and exchange, so Rearview can attribute P&L by sector and apply exchange-specific delisting haircuts.
Keeping your data up to date
To bring new trading days into Rearview, run norgate_export.py again into a fresh folder, select your data in Rearview’s Data Library, and choose Update ▸ Update from Folder…. Rearview checks whether anything changed on or before the previous last date: when only new days were added, every earlier saved run continues to reproduce byte for byte.
What Norgate’s interface can’t tell Rearview
- Why a stock delisted. Norgate’s Python interface doesn’t distinguish acquisitions from performance delistings, so every delisted stock is exported with reason
UNKNOWN. Rearview prices it cautiously as a performance delisting with your exchange haircut setting and logs aDELIST_ASSUMEDwarning. You can inspect or adjust haircuts in Run settings. - Former tickers. Each security keeps the single symbol Norgate assigns it today (delisted stocks keep Norgate’s dated suffix, such as
ABC-201503). Universes selected by index membership or sector aren’t affected; scripts referencing a historical ticker by name won’t match it. - Spinoffs and reorganisations. Because they appear in Norgate’s capital adjustments like splits, the script exports each as an equivalent-ratio split (preserving holding value as Norgate’s adjusted series does) and lists every such event in
norgate-export-report.txt. - Testing status. As noted on Your data, the Norgate export script has so far been tested on vendors’ samples and files made to Norgate’s published layouts, not yet on a full Norgate download. If anything in your export fails to import, send
norgate-export-report.txtand the import report to support and it gets fixed.
Moving your scripts across too
If your existing strategies live in RealTest or AmiBroker alongside Norgate Data, see our side-by-side translation tables in RealTest on a Mac and AmiBroker on a Mac, and Why your results differ from another backtester.
Ready to try Rearview on your own Norgate export? Download the 30-day free trial (no card needed).
Sources
Read on 23 October 2026: Norgate Data Updater FAQ. Full import details live in Importing your data.
Product names belong to their owners. Rearview isn’t affiliated with or endorsed by them.