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?
It appears as though this function has been depreciated in GAS. You might want to look into a way to do it using Yahoo.