Get data, Web , Web Path

[vrossouw]

Good day, I am trying to link to the Google Finance Data for GOOGLE:

(Get Data, Web)

https://www.google.com/finance?q=NASDAQ:GOOG&fstype=ii

However, this link is taking me to the quarterly data  and income statement information

How can I change the path to link to the Annual Data of the Balance Sheet?

Thank you in advance

[Anonymous · Accepted solution]

Hi @vrossouw,

The url which you used only shows the analysed and formatted data, current power query not support to operate the pages script(javascript functions in page) to switch the displayed data.

Logic:
1. Get data from google finance api with the inputted keywords.
2. Receive and analysis by javascript functions.
3. Cache these data to browser.

In my opinion, you should get data from google finance api to instead of the current url. Perhaps you can get more support at the forums which related to google finance api.

Regards,

Xiaoxin Sheng

[vrossouw]

okay thank you