Stop rounding when importing Google finance currency

Question

I am importing currency from Google finance to Google spreadsheets (latest version). The number that is imported is rounded both in terms of what is displayed and the underlying number. Is there a way to get the actual underlying currency number to all necessary decimal places?

shinjw · Answer 1 · 2014-09-21T15:09:39.663

0

Look at your menu bar and select:

Format > Number > More Formats > Custom Number Format

edited Sep 21 '14 at 15:09

answered Sep 21 '14 at 07:43

shinjw

3,329
3
21
42

David Howlett · Answer 2 · 2014-11-16T15:31:23.603

0

I used the external lookup - =ImportHTML("http://www.xe.com","table", 1)

in a unused part of the spreadsheet and then sourced the appropriate rate from the table contents. Will probably work with other currencies too - look at xe.com Updates every minute which is fine for my purposes.

edited Nov 16 '14 at 15:31

answered Nov 16 '14 at 12:40

David Howlett

1
1

score 0 · Answer 3 · edited Jul 02 '19 at 11:05

0

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

Where:

ASX (Australian Stock eXchange) can be replaced for TSE, etc or removed for NASDAQ
B12 is the Ticker.

edited Jul 02 '19 at 11:05

ross

2,684
2
13
22

answered Jul 02 '19 at 08:57

Charbzilla

71
1
2

please add the appropriate code formatting so other people can more easily read it – Tarick Welling Jul 02 '19 at 09:46

Stop rounding when importing Google finance currency

3 Answers3