Google Finance - Google Sheets @hibikidan333 - Assuming it was...

  1. 8 Posts.
    Google Finance - Google Sheets

    @hibikidan333 - Assuming it was you who was trying this - not able to find the post this was discussed

    People who were trying to build up their stock analysis on google sheets using google finance were facing issues in fetching the exact current market price. GOOGLEFINANCE(STOCKNAME) tends to round it up at 2 decimal places.

    Was hacking around with the html and I was able to get the exact stock price using the following method

    =IMPORTXML(CONCATENATE("https://www.google.com/finance?q=",C2),"//span[@class='pr']")

    where C2 would be the Cell with the stock quote "ASX:SRT" Etc.

    This gets the value until 4 decimals which should be useful when analysis penny stocks. Hope it helps & improves the stock analysis
    Last edited by asterixobelix: 08/04/16
 
arrow-down-2 Created with Sketch. arrow-down-2 Created with Sketch.