How to retrieve stock price from Google Finance with 4 decimal places into google spreadsheet?

Question

On google spreadsheet, the price of a stock can be retrieved onto google spreadsheet using the formula GOOGLEFINANCE("stock_symbol", "price"). However, price retrieved is only in 2 decimal places. For international stocks, this is not good enough because many of them are penny stocks. 4 decimal places will be much better.

How can one retrieve stock price from Google Finance with 4 decimal places into google spreadsheet? Are there programming tricks to work around this limitation from Google Finance? Will google apps-script be a good choice?

score 6 · Answer 1 · edited Jul 02 '19 at 10:31

6

=round((googlefinance("asx:"&B12,"marketcap")/googlefinance("asx:"&B12,"shares")),4)

Where asx is the market outside of NASDAQ and B12 is the ticker.

edited Jul 02 '19 at 10:31

ross

2,684
2
13
22

answered Jul 02 '19 at 08:47

Charbzilla

71
1
2

score 1 · Accepted Answer · edited May 23 '17 at 12:26

1

It appears as though this function has been depreciated in GAS. You might want to look into a way to do it using Yahoo.

edited May 23 '17 at 12:26

Community

1
1

answered Apr 03 '14 at 13:39

Michael Blaustein

901
6
24

How to retrieve stock price from Google Finance with 4 decimal places into google spreadsheet?

2 Answers2