Data Source's Explained
The automated update of prices and dividends is one of the key time saving features Share Trade Tracker offers. It creates a list of securities from your portfolios and then extracts the last traded price or dividend details for each security and returns it the workbook for analysis and display in the worksheet's.
Share Trade Tracker was originally designed to provide FREE data sources where possible for price and dividend information. For many years we extracted Price and Dividend details from the Yahoo Finance website. In recent times changes to the Yahoo Finance website impacted the reliability of the data source. From December, 2024 Yahoo has been removed as a data source from Share Trade Tracker.
A new FREE data source is now included called MyPrices, this uses the built-in Stocks Data Type function and some manual configuration by the user to establish a file of Prices that can be used in Share Trade Tracker. This FREE data source does NOT provide any Historical Prices or Dividend Details.
For users that need a reliable and complete Data Source we have integrated with Norgate Data and EOD Historical. These sites provide reliable and accurate data for update into Share Trade Tracker
Prices
On entry to Share Trade Tracker you will be directed to setup your Data Source via the Welcome form. You can review you Data Source setup anytime via Configuration and then Data Source. For the configuration there are two (2) Data Sources that need to be setup, one for Prices and one for Dividends. We will start with the setup of Prices.
Once you select the option for 'Set Price Data Source', you will see two (2) different configurations one for End of Day prices which will be used to list the latest price for your open trades and one for Historical prices which is used to populate the price for reports.
End of Day & Historical Prices
The options for prices are:
EOD Historical - reliable data source, PAID option. This data source provides an alternative to World Trading Data via an integrated API. It requires the setup of an API Key before the data source can be used. At the time of writing this article plans from $20/month were available. Click here EOD Historical for setup details.
Norgate Data - this option is a paid data service that provides direct and local access to the prices and security information available in your Norgate service. There is no API required, once you select this option Share Trade Tracker will detect if you have a valid Norgate Data subscription and then use that to update your prices. Click here Norgate Data for setup details.
MyPrices (default) - this option is now the default FREE option for prices and security information. It is uses the built-in Stocks Data Type. Click here MyPrices for setup details.
After selecting the preferred option for each of the price configurations you simply select 'Update' to store the configuration into the settings for Share Trade Tracker. That data source will then be used for 'Update Prices' and 'Security Check' options in the ribbon and as part of the historical Reports generated.
Some of my Securities are missing price data (#Not Found) ?
For the data sources directly integrated with Share Trade Tracker (EOD Historical) if you find that some of your securities are not returning data. We suggest that you contact those data source providers and request that they add the missing security to their database. In most cases they are able to do this with 24 hours of notification
Dividends
On entry to Share Trade Tracker you will be directed to setup your Data Source via the Welcome form. You can review you Data Source setup anytime via Configuration and then Data Source. For the configuration there are two (2) Data Sources that need to be setup, one for Prices and one for Dividends. We will now step through the options for Dividends.
Once you select the option for 'Set Dividend Data Source', you will see two (2) different configurations one for Australian Dividends (ASX) and one for Other Dividends (eg US).Â
Australian Dividends
The options for Australian Dividends are:
EOD Historical - reliable data source, PAID option. This data source provides an alternative to Share Dividends via an integrated API. It requires the setup of an API Key before the data source can be used. At the time of writing this article plans from $20/month were available. Click here EOD Historical for setup details.
Norgate Data - this option is a paid data service that provides direct and local access to the dividend data available in your Norgate service. There is no API required, once you select this option Share Trade Tracker will detect if you have a valid Norgate Data subscription and then use that to update your dividends. Click here Norgate Data for setup details.
Other Dividends
The options for Other Dividends are:
EOD Historical - reliable data source, PAID option. This data source provides an alternative to Share Dividends via an integrated API. It requires the setup of an API Key before the data source can be used. At the time of writing this article plans from $20/month were available. Click here EOD Historical for setup details..
Norgate Data - this option is a paid data service that provides direct and local access to the dividend data available in your Norgate service. There is no API required, once you select this option Share Trade Tracker will detect if you have a valid Norgate Data subscription and then use that to update your dividends. Click here Norgate Data for setup details.
Some of my Securities are missing dividend data (#Not Found) ?
For the data sources directly integrated with Share Trade Tracker (EOD Historical) if you find that some of your securities are not returning data. We suggest that you contact those data source providers and request that they add the missing security to their database. In most cases they are able to do this with 24 hours of notification