![]() People invest money in the stock market through NSE or BSE. We can easily track NSE & BSE live data in Google Sheets using inbuilt functions. They deal with the stock transactions of the entire country. ![]() The National Stock Exchange (NSE) and Bombay Stock Exchange (BSE) are two stock exchanges active in India. What is NSE & BSE Live Data in Google Sheets? Retrieves the weekly high price between the dates specified for the ticker in cell B2. This fetches the weekly stock price of Nvidia for the period specified. Interval can alternatively be specified as 1 or 7. Interval – – The frequency of returned data either “DAILY” or “WEEKLY”. Start_date – – The start date when fetching historical data.Įnd_date|num_days – – The end date when fetching historical data or the number of days from start_date for which to return data. If you set the parameter as “high”, it will return the day high price of that particular stock. By default, the function returns the “price” parameter. For Eg, if you want to find the stock price of Infosys (NSE: INFY), use NSE(exchange symbol) and INFY(ticker symbol).Īttribute – This specifies the type of data to fetch about the ticker from Google Finance.Ĭompulsory to mention if the date is specified. Keep in mind to use both the exchange symbol and ticker symbol. ![]() Ticker – The ticker symbol for the company/index to consider. GOOGLEFINANCE function can be used to track stock prices, including tracking NSE & BSE live data in Google Sheets. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |