Looking for a way to pull historical data from google finance on an annual basis. Looking to have a sheet similar to the image below I'm trying to use the function =GOOGLEFINANCE(A1, "Shares",date( ) ) for outstanding shares but keep getting #n/a any help would be appreciated!

Reputation: 1

Historical data for outstanding shares on google sheets

Looking for a way to pull historical data from google finance on an annual basis. Looking to have a sheet similar to the image below

enter image description here

I'm trying to use the function =GOOGLEFINANCE(A1, "Shares",date( ) ) for outstanding shares but keep getting #n/a

any help would be appreciated!

Upvotes: 0

Reputation: 1944

I use TIKR which has good 10+ year financial data. It has a useful feature Copy Table which can be pasted into Google Sheets.

I use a temp sheet for this, so I can extract the rows/cols I want using script.

Upvotes: 0

Reputation: 1

unfortunately, this is not supported in GOOGLEFINANCE. see:

Upvotes: 2