Navigation: Importing Bar Data >

Yahoo Import

 

 

 

Yahoo import works by downloading and parsing JSON data files from finance.yahoo.com. Several of the example scripts include Yahoo import sections, e.g.l

To import data from Yahoo, you must provide a symbol list using one or more IncludeList statements. This will be the list of symbols that are downloaded and imported.

To find out what symbols are available, visit https://finance.yahoo.com/ and use the search function, e.g.

 

Yahoo data includes both splits and dividends, so RealTest is able to provide accurate as-traded backtests using this data. Yahoo does not, however, offer delisted symbols or historical index constituency information. If these are important to you, Norgate Data is the recommended source to use.

Yahoo data also does not provide any symbol-level information such as company name or industry. (Some of that is on the website, but RealTest does not do any screen-scraping.) If you have such information in CSV format and want to apply it to a Yahoo import, you can do so by adding a SyminfoFile path to the import definition. An example SymInfo file for the S&P 500 components is included in the Examples folder and used in the script shown above.

In addition to the advantages mentioned above, the biggest advantage to using a paid data service like Norgate has to do with this kind of meta-data. Specifically, there is never a need for a SymInfo file when using Norgate. The company name, industry, exchange, country, currency, etc. are all obtained automatically during import.

More importantly, Norgate includes a dynamic WatchList facility that makes it easy to know that every day, you are importing "all the symbols in the market" (or in an index, or however you want to define your universe). If you use a free source like Yahoo, be prepared to do a lot of research every day just to keep track of symbol changes, additions, delistings, etc.

 

 

 

 

Copyright © 2020-2021 Systematic Solutions, LLC