-1

I am trying to make a stock portfolio in Google Sheets to track my stonks. However, I have some penny stocks that are less than 1 penny, and GoogleFinance rounds them down to 0, making it impossible to calculate % of the portfolio. The code I use is:

=GOOGLEFINANCE(B2)

and neither adding the ROUND function or changing how numbers are displayed in excel are working. Is there a fix or do I have to scrape from elsewhere?

Aerials
  • 4,231
  • 1
  • 16
  • 20
DanielZou0809
  • 1

2 Answers2

0

try:

=TEXT(GOOGLEFINANCE(B2); "#.00")*1
player0
  • 124,011
  • 12
  • 67
  • 124
  • This isn't working for me, it still rounds 0.0018 to 0.00, even when I change it to #.0000. However, I did just change it so it scrapes off the Google Finance Website. Thank you for your quick response. -Daniel – DanielZou0809 Feb 01 '21 at 20:05
0

I found the answer in this reddit thread: https://www.reddit.com/r/pennystocks/comments/lc4fg1/using_importxml_to_input_live_penny_stock_quotes/

You have to use importxml function and make sure the google sheets cell is set to show at least 4 decimal places.

LTG
  • 1