Google sheets is used by almost 99% people in the world π
Most people donβt know how to use it for TRADING and INVESTING purposes π
10 features everyone should know :
How you can use some secret features of Google Sheet and Google Finance in your trading together?
5 things that a trader should know and implement:
GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date|num_days], [interval])
Above function is a basic one.
Let's decode each parameter in this:
1. Ticker: This is the symbol of the stock.
"NSE: RELIANCE" is the ticker for Reliance Industries
2. Attribute:
The attribute to fetch about ticker from Google Finance and is required if a date is specified.
Following data can be fetched:
-Open
-Close
-High
-Low
-Volume
-Market Cap
-Price (Ltp)
-52-week high
-52-week low
-Change in price
3. Start_Date (Optional): The start date when fetching historical data.
4. End_Date|Num_Days (O): The end date when fetching historical data, or the number of days from start_date for which to return data.
5. Interval (O): The frequency of returned data; either "D" or "W"