Forum Discussion
Pulling Historical Stock Market data -- Function does not work
Resolved on my own
The key was to:1. Pull in the API data for any ticker symbol first
2. Create a Parameter for any symbol
3. Create a ticker list (all tickers I intend on gathering data for -- theres 300 of them) in Excel, load the Excel sheet as a separate table.
4. Create a function called "GetSymbolHistoric" (or any name you want)
5. Invoke function on table from Excel (Ticker List)
Now, as I add tickers I just need to add them to the Excel sheet and refresh report and everything is completed.
Next part of the project:
Incremental Refresh -- Storing the historical data, then only updating the most recent data on the report to save performance and time.
Resolved on my own
The key was to:
1. Pull in the API data for any ticker symbol first
2. Create a Parameter for any symbol
3. Create a ticker list (all tickers I intend on gathering data for -- theres 300 of them) in Excel, load the Excel sheet as a separate table.
4. Create a function called "GetSymbolHistoric" (or any name you want)
5. Invoke function on table from Excel (Ticker List)
Now, as I add tickers I just need to add them to the Excel sheet and refresh report and everything is completed.
Next part of the project:
Incremental Refresh -- Storing the historical data, then only updating the most recent data on the report to save performance and time.
hi, chrisB13
It's pleasant that your problem has been solved,
please close the topic and mark the relevant post as an answer.
Thank you. :smileyvery-happy:
Best Regards,
Lin
