Is there a way I can import price from google finance into google spreadsheet with 4 decimal places?

Question

I have the formula to retrieve the data from google finance.

=googlefinance(D4; "price")

I am tracking some penny stocks and some of the prices have a price in 4 decimal places. When I import the price and it only imports the information with only 2 decimal places. How can I import the price with 4 decimal places?

score 1 · Answer 1 · edited Jul 02 '19 at 08:47

1

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

edited Jul 02 '19 at 08:47

adiga

34,372
9
61
83

answered Jul 02 '19 at 08:43

Charbzilla

71
1
2

1

Can you please add explanation what your code does? – Nilambar Sharma Jul 02 '19 at 08:46
Market cap is the total value of the company - where the total value is Shares times the current share price. Doing this calculation basically is getting the share price – Pretty Cool Mar 16 '21 at 03:04

score 0 · Answer 2 · edited Jul 02 '19 at 08:47

0

I know this post is old but for those searching for answers like me here is the solution:

=index(importhtml("http://www.nasdaq.com/aspx/infoquotes.aspx?symbol="&$A2,"table",8),1,2)

$A2 = being the cell that holds the ticker symbol.

edited Jul 02 '19 at 08:47

adiga

34,372
9
61
83

answered Aug 28 '17 at 08:56

Jax J

1

score -1 · Answer 3 · edited Jul 02 '19 at 08:47

-1

I actually figured it out. Here is the formula I used:

=index(GoogleFinance(D1, "close", today()-1, today(), "1"), 2, 2)

D1 = Name of stock entered to pull information from google finance. Works like a charm!

edited Jul 02 '19 at 08:47

adiga

34,372
9
61
83

answered Feb 22 '14 at 18:09

OliverTwist

43
2
8

the index formula you are using here is a non sense for me. The summary say: "Returns the content of a cell, specified by row and column offset." – Harold Feb 23 '14 at 11:03
That's strange it was working earlier... Do you have any other suggestions or formulas? – OliverTwist Feb 23 '14 at 19:41
maybe an idea here: http://stackoverflow.com/questions/21769645/how-to-get-taiwan-stock-exchange-index-in-google-spreadsheet/21775576#21775576 – Harold Feb 23 '14 at 19:48
Unfortunately that isn't what I am looking for. I appreciate it though – OliverTwist Feb 23 '14 at 20:04

Is there a way I can import price from google finance into google spreadsheet with 4 decimal places?

3 Answers3