New features for Stock Quote Add-In for Excel 2016
January 7, 2018
Today I implemented a couple of new features to the Stock Quote Add-In for Excel. You now can use an item reference notation to access all available JSON values. The screenshot below shows how to use the item reference notation to access all available data. Starting from the root object you are now able to access for instance the first figure data with financials/0/f_figures/0/annual. This notation returns the value as string. To return the value as number, prefix the path with !. The notation is case-sensitive.
- Added JSON.NET parser to parse stock data more flexible
- Added Ticker Data dialog to see JSON raw data
- Added item reference notation to address all available data
Check out GitHub for more details!
German Edition of Excel 2016