This is a trading object shared by a member. You can use this object as well as hundreds of others with QuantShare - Trading Software.
Click on the Like button or on one of the share buttons to share this object and spread the word about QuantShare.
QuantShare is an advanced trading software for stock, forex, futures, ETF and options markets. It is the best and the most complete EOD trading software software and it is FREE (beta version).
ETF traders can now access some historical fundamental data using this downloader. The item downloads fees, assets, nav, yield... data from the (etfzone.com) website.
Fees: The fund fees.
Nav: Net asset value. It is the value of each share of a fund as determined by the value of its underlying holdings, including any cash in the portfolio.
Yield: Change in price of the fund plus the dividends received per share.
PE: The average ratio of price to annualized earnings of stocks in an ETF, weighted by their representation.
3 Years beta: Beta is a measure of volatility.
The first time you use the downloader, a database 'etf_data' will be created and it will store all the downloaded data. After you start the downloader, select the start & end date and then click on 'Save'. This will load all the dates that will be used by the downloader. Click on 'Start' to begin the downloading process.
The 'Automatically add new symbols' option is activated and thus unknown ETF tickers will be added.
You can get a ready to use list of ETF symbols (The list contains the ETF full names and the ETF fund types) here: ETF Symbols.
The (etfzone.com) website requires a registration in order to download the fundamental data. I have created this item so that it automatically registers using the email and password you provide.
So, in order to use this downloader:
Visit etfzone and create a new account.
- Select the current download item (in the download manager) and then click on update.
- In the first row, you will find a URL: http://www.etfzone.com/includes/ajax/session.ajax.php?form_action=login&template=etfdetail
- Update this URL, by adding two fields: &email=[Insert your email]&password=[Insert your password].
- The final URL should look like this: http://www.etfzone.com/includes/ajax/session.ajax.php?form_action=login&template=etfdetail&email=[Insert your email]&password=[Insert your password].
- Close the 'Update Download Item' form
