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 has been designed to provide FREE data sources where possible for price and dividend information. This is typically sufficient for most Share Trade Tracker users, but issues in reliability and accuracy can be found with the FREE data sources. As a result Share Trade Tracker now includes a number of paid data source options that are directly integrated, these include EOD Historical and Norgate Data.

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:
  • World Trading Data - this option is FREE for 250 requests per day. It requires the setup of an API Key before the data source can be used. The API Key is free and takes only few minutes to create one at the World Trading Data website. Click here World Trading Data for setup details. (Note: World Trading Data is limited to 2 decimal places)
  • 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.
  • Yahoo (default) - this option is now the default FREE option for prices and security information. It is sourced from the Yahoo Finance site using the historical prices.
You need to make a selection for both the End of Day and Historical prices for all the features of Share Trade Tracker to function. We strongly recommend for new users that don't have an existing subscription to EOD Historical or Norgate Data to leave the default setting to Yahoo as this will ensure an automated data source. 

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 (World Trading Data & 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). The data source for Australian Dividends provides franking credit information which is not available from any other source PAID or FREE.



Australian Dividends
The options for Australian Dividends are:
  • ShareDividends.Com.Au (default) - recommended data source, this option is FREE for Share Trade Tracker users and provides franking credit details in addition to dividend data for each security. The data source is integrated via an API and does NOT require you to setup an API Key.
  • 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.
  • Yahoo - this option is another FREE option for dividends and security information. It is sourced from the Yahoo Finance site using the historical dividends. 
Other Dividends
The options for Other Dividends are:
  • Yahoo (default) - this option will not be supported past December, 2019. FREE data source not reliable following recent changes to the Yahoo Finance website. 
    • 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.
    You need to make a selection for both the Australian and Other dividends for all the features of Share Trade Tracker to function. We strongly recommend for new users to leave the default setting to Share Dividends for Australian securities and Yahoo for Overseas securities.

    Some of my Securities are missing dividend data (#Not Found) ?
    For the data sources directly integrated with Share Trade Tracker (Share Dividends & 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