Click here to Login

How to Download and Use Fundamental Data

Updated on 2011-01-04

If you search for fundamental-related trading objects in the QuantShare sharing server, you will find many items. The majority of them are data downloader; they download fundamental ratios and items from specific websites, parse the data, create a custom database and one or several fields (Each field corresponds to a fundamental item) and then insert the parsed data into the database. The whole process is performed automatically and in few seconds.

As an example, the Fundamental Valuation Ratios for US Stocks item was shared by one of our members and it downloads valuation ratios for U.S. Stocks. These ratios are stored in a database named "fund_valuation" and in fields that correspond to the following valuation ratios: Price/Cash, Price/Free Cash Flow, EPS this Year, EPS next Year, EPS Past 5 Years...

Fundamental Items for U.S. Stocks

For the U.S. Stock Market, you can use the following items to get more than 30 fundamental items:
Fundamental Valuation Ratios for US Stocks
Ownership data for US companies
Financial fundamental data for US companies
Recent Insider Buying and Selling for US Stocks

Collecting Fundamental Data

In the Download Manager, click on the "Plus" button (next to the "Items" column) of each fundamental downloader to instruct QuantShare to download data automatically on regular basis (Once a week for example). This allows you to build an historical database of fundamental data and use this database to see changes in the data over time, create simulations and perform backtests.


The first time you start a downloader that creates a custom database/fields, you will be prompted to allow the creation of the database.
You will also be prompted for each field to select a descriptive name and whether to create a snapshot of the field data or not. If you decide to create a snapshot, the QS Trading Software will store in a fast in-memory database the last field value of each stock. You can then select symbols, from the Symbols Filter, based on these fundamental items.

Note that the snapshot option and descriptive name can be updated, for each field, directly in the Database Editor. For this, select "Data" then "Edit Database". Select a custom database, a symbol, and then select a field in the "Field Info" group box.

Access to the fundamental data

Besides filtering symbols using fundamental criteria (in the Symbols Filter), you can access the fundamental data using several QuantShare functions.
The "GetData" function for example gets a time-series given a database and a field name.
a = GetData("fund_ownership","mktcap",LastData);

Once you have collected enough fundamental data, you can use this function to create simple or advanced trading rules for you simulations, watchlists or screens.

no comments (Log in)

QuantShare Blog
Search Posts

Recent Posts

Create Graphs using the Grid Tool
Posted 1270 days ago

Profile Graphs
Posted 1375 days ago

Previous Posts

QS Trading Software: Global Script
Posted 4961 days ago

Stock Market Prediction
Posted 4989 days ago

More Posts


Create an account
Affiliate Program
Contact Us
Trading Forum
How-to Lessons
About Us
Terms of Use

Copyright 2024
Social Media
Follow us on Facebook
Twitter Follow us on Twitter
Follow us on Google+
RSS Trading Items

Trading financial instruments, including foreign exchange on margin, carries a high level of risk and is not suitable for all investors. The high degree of leverage can work against you as well as for you. Before deciding to invest in financial instruments or foreign exchange you should carefully consider your investment objectives, level of experience, and risk appetite. The possibility exists that you could sustain a loss of some or all of your initial investment and therefore you should not invest money that you cannot afford to lose. You should be aware of all the risks associated with trading and seek advice from an independent financial advisor if you have any doubts.