Norgate Fundamental Data
- Thread starter Indoril
- Start date
Richard Dale
Norgate Data
- Joined
- 22 February 2005
- Posts
- 269
- Reactions
- 197
Before the end of the year at this stage, initially in AmiBroker and RightEdge.
Wysiwyg
Everyone wants money
- Joined
- 8 August 2006
- Posts
- 8,428
- Reactions
- 284
Using GetFnData("field") in tests will be interesting.
- Joined
- 13 January 2013
- Posts
- 258
- Reactions
- 50
Richard, will the data in excess of what is available to your current beta testers now? Are we likely to see historical changes in the metrics or will the data be 'most recent available'. What i mean is will the metrics be a single number over the entire price series? I would like to test some mechanical systems using say a P/S ratio or market cap that changes over time for example.
Richard Dale
Norgate Data
- Joined
- 22 February 2005
- Posts
- 269
- Reactions
- 197
Hi RB,
We only plan to provide current fundamentals. Historical fundamentals are actually very difficult to get right.
Here's are some factors off the top of my head that really mess with historical fundamental data:
Stock splits
Stock dividends (bonus share offers)
Capital raising/Rights issues (i.e. dilutive events)
Conversion of hybrid debt/equity instruments
Exercise of warrants/company options
Employee share issues
Share buybacks
Spinoffs/Demergers
Mergers/Reverse Mergers between companies that have different fiscal year boundaries
Reconciling differences between multiple sources of data that have different surviving entity interpretations for mergers/demergers
Multiple classes of stocks that have different ownership/voting rights - how many total shares actually exist for this company?
Companies that have large tranches of unlisted shares
Corporate re-orgs (e.g. creation of different classes of securities, with different ownership regulations)
Changes in fiscal year reporting dates
Changes in fiscal interim reporting frequency (some countries only require half-yearly accounts)
Changes in domicile/reporting currency
What currency value do you use for foreign currency-reporting companies? The value as at the report date? An average for the period?
Re-statement of most recent or previous periods (e.g. irregularities/mistakes)
Staggered reporting of financials (e.g. some companies just report the headline earnings figures and some weeks later provide the rest of the detailed balance sheet/earnings figures, so you have some fundamentals that are "current" and some that related to the previous period).
Tracking stocks that track only a portion of the company
To do this on an accurate and consistent basis historically is difficult and unlikely to be a sound business move on our behalf based upon the limited demand expressed so far.
We only plan to provide current fundamentals. Historical fundamentals are actually very difficult to get right.
Here's are some factors off the top of my head that really mess with historical fundamental data:
Stock splits
Stock dividends (bonus share offers)
Capital raising/Rights issues (i.e. dilutive events)
Conversion of hybrid debt/equity instruments
Exercise of warrants/company options
Employee share issues
Share buybacks
Spinoffs/Demergers
Mergers/Reverse Mergers between companies that have different fiscal year boundaries
Reconciling differences between multiple sources of data that have different surviving entity interpretations for mergers/demergers
Multiple classes of stocks that have different ownership/voting rights - how many total shares actually exist for this company?
Companies that have large tranches of unlisted shares
Corporate re-orgs (e.g. creation of different classes of securities, with different ownership regulations)
Changes in fiscal year reporting dates
Changes in fiscal interim reporting frequency (some countries only require half-yearly accounts)
Changes in domicile/reporting currency
What currency value do you use for foreign currency-reporting companies? The value as at the report date? An average for the period?
Re-statement of most recent or previous periods (e.g. irregularities/mistakes)
Staggered reporting of financials (e.g. some companies just report the headline earnings figures and some weeks later provide the rest of the detailed balance sheet/earnings figures, so you have some fundamentals that are "current" and some that related to the previous period).
Tracking stocks that track only a portion of the company
To do this on an accurate and consistent basis historically is difficult and unlikely to be a sound business move on our behalf based upon the limited demand expressed so far.
Hi Richard Dale,
This is interesting. Which countries' stock markets will be offered?
Richard Dale
Norgate Data
- Joined
- 22 February 2005
- Posts
- 269
- Reactions
- 197
Australia and US. Canada some time in 2018 at this stage.
- Joined
- 13 September 2013
- Posts
- 988
- Reactions
- 530
are you looking at introducing regular historical data for Canada or any other markets Richard?
Richard Dale
Norgate Data
- Joined
- 22 February 2005
- Posts
- 269
- Reactions
- 197
I assume by "regular historical data" you mean price data. Yes - that is our core business. We have no other short-medium term plans to cover any other stock markets at this stage.
- Joined
- 13 September 2013
- Posts
- 988
- Reactions
- 530
Yes sorry, Price data. So only US and Aus at this stage..
Thanks
Thanks
Hi Richard,
I'm surprised that you have no plans to add other stock markets in the future, like say the London Stock Exchange. The London exchange is the 3rd largest in the world, after NYSE and NASDAQ. It’s a far larger market than Australia, yet you provide data for Australia, but not Lonon??
I'm surprised that you have no plans to add other stock markets in the future, like say the London Stock Exchange. The London exchange is the 3rd largest in the world, after NYSE and NASDAQ. It’s a far larger market than Australia, yet you provide data for Australia, but not Lonon??
Wysiwyg
Everyone wants money
- Joined
- 8 August 2006
- Posts
- 8,428
- Reactions
- 284
Is there a list of fundamental data fields that will be available on the subscription?
Richard Dale
Norgate Data
- Joined
- 22 February 2005
- Posts
- 269
- Reactions
- 197
Regarding coverage of other exchanges - you'd be surprised how little demand there is for LSE. In order to cover an exchange correctly there's usually a few man-years of time to get it right prior to release. We actually spent some time a few years back looking at it and decided it wasn't commercially viable.
In regards to fundamental fields, we will be populating the AmiBroker fields (accessible via GetFnData where there is an exact match with AmiBroker's definition). These are described here:
https://norgatedata.com/beta-testing-program/amibroker-database-layout-content.php
However, there are more fundamental fields than just the ones inbuilt to AmiBroker, and we provide a list of them here:
https://norgatedata.com/beta-testing-program/data-content-tables.php#fundamentals-current-price
There's also some broker consensus data too.
In regards to fundamental fields, we will be populating the AmiBroker fields (accessible via GetFnData where there is an exact match with AmiBroker's definition). These are described here:
https://norgatedata.com/beta-testing-program/amibroker-database-layout-content.php
However, there are more fundamental fields than just the ones inbuilt to AmiBroker, and we provide a list of them here:
https://norgatedata.com/beta-testing-program/data-content-tables.php#fundamentals-current-price
There's also some broker consensus data too.
Richard Dale
Norgate Data
- Joined
- 22 February 2005
- Posts
- 269
- Reactions
- 197
Yes - release is imminent (basically the product is complete, just working on ordering/subscription systems now)
Richard Dale
Norgate Data
- Joined
- 22 February 2005
- Posts
- 269
- Reactions
- 197
Norgate Data is now released. Thanks to the ASF members that have helped in the alpha and beta testing too.
Richard Dale
Norgate Data
- Joined
- 22 February 2005
- Posts
- 269
- Reactions
- 197
How time flies! Canadian data released today...
Similar threads
