=IFERROR(GOOGLEFINANCE($B$4,"MARKETCAP")) Marketcap – the market cap of the selected stock. Volume – find the number of shares traded of the selected stock for the current day. Low – to fetch current day’s lowest price of the stock. High – to fetch current day’s highest price of the stock. =IFERROR(GOOGLEFINANCE($B$4,"PRICEOPEN")) Priceopen – to find the current day’s opening stock price. Price – to find the real-time market price of the stock. Available Arguments in GoogleFinace to Fetch Real-Time Stock Data in Google Sheetsīelow I’m providing you the available all arguments that you can use to find BSE, NSE real-time stock prices in Google Doc Spreadsheet. Note: If you plan to copy the formulas below, first, enter the ticker in B4. Further, I’ve used Google Sheets IFERROR function because of real-time security information for some of the arguments like ‘datadelay’, ‘volumeavg’ and ‘change’ may not available all the time.Īgain I suggest you open my sheet to see the live examples. Here I am going to use the ticker in cell B4 as a reference.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |