Google sheets is available to 99% of the world on internet β
π
Most people donβt know how to use it for "TRADING and INVESTING" purposes π
10 features everyone should know :
----------------------------------------------------
[big surprise in the end, DO.NOT.MISS] βππ
Most people donβt know how to use it for "TRADING and INVESTING" purposes π
10 features everyone should know :
----------------------------------------------------
[big surprise in the end, DO.NOT.MISS] βππ
How you can use some features of Google Sheet and Google Finance in your trading together?
5 things that a trader should know and implement:
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
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
![GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date|num_days], [interval])
Above function is...](https://pbs.twimg.com/media/GB9I7TsbwAA5Iyq.png)
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
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"
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"
1/ Fetching Stock Price Live
GOOGLEFINANCE("NSE:TCS","PRICE")
This function will help you in fetching stock price live.
Make sure you mention exchange and ticker code properly.
Attribute can be price or any of the above attribute.
GOOGLEFINANCE("NSE:TCS","PRICE")
This function will help you in fetching stock price live.
Make sure you mention exchange and ticker code properly.
Attribute can be price or any of the above attribute.
2/ Fetching Stock Price of any particular date:
=GOOGLEFINANCE("TCS","PRICE", "01/02/2022")
This function will fetch the TCS stock price as on 1st Feb 2022.
Output is shown in the image below image.
=GOOGLEFINANCE("TCS","PRICE", "01/02/2022")
This function will fetch the TCS stock price as on 1st Feb 2022.
Output is shown in the image below image.
3/ Fetching Stock Price for an interval:
=GOOGLEFINANCE("NSE:TCS","price","01/01/2022","15/01/2022")
This will fetch Trent Daily Stock Price from 1st June to 15th June 2022.
Output is shown in the image below image.
=GOOGLEFINANCE("NSE:TCS","price","01/01/2022","15/01/2022")
This will fetch Trent Daily Stock Price from 1st June to 15th June 2022.
Output is shown in the image below image.
4/ Fetching Stock Price for an interval on weekly basis:
=GOOGLEFINANCE("NSE:Tcs","price","01/10/2021","15/01/2022", "Weekly")
This will fetch Trent Weekly Stock Price from 1st Oct to 15th Jan 2022.
Output is shown in the image below image.
=GOOGLEFINANCE("NSE:Tcs","price","01/10/2021","15/01/2022", "Weekly")
This will fetch Trent Weekly Stock Price from 1st Oct to 15th Jan 2022.
Output is shown in the image below image.
5/ These were the Google Finance functions for stocks.
Some basic function which you can use are:
1. "Today()" = Fetch Current Date.
2. "Today()-30" = Fetch 30 days back date.
3. EDATE("01/02/2022",-3) = Fetch 3 months back date.
Some basic function which you can use are:
1. "Today()" = Fetch Current Date.
2. "Today()-30" = Fetch 30 days back date.
3. EDATE("01/02/2022",-3) = Fetch 3 months back date.
How you can use this Google Sheet in your trading?
β‘οΈTrack all your open and close position just like how we are doing this for years.
β‘οΈIf you monitor your closed position, then you can create a graph of your capital and NAV/Equity Curve easily.
β‘οΈTrack all your open and close position just like how we are doing this for years.
β‘οΈIf you monitor your closed position, then you can create a graph of your capital and NAV/Equity Curve easily.
β‘οΈPull out entire data of any stock or index for any particular duration automatically.
In the image, we are fetching the last 7 years' data of TCS stock price in just a few seconds, otherwise it would have taken hours.
Above data, you can use to do backtesting of any strategy.
In the image, we are fetching the last 7 years' data of TCS stock price in just a few seconds, otherwise it would have taken hours.
Above data, you can use to do backtesting of any strategy.
If you liked this then do like and retweet the initial tweet
x.com
The bigger surprise is below this tweet : ππ
x.com
The bigger surprise is below this tweet : ππ
If you have arrived till here, the surprise is this.
Everytime we see a stock breaking out on chart we share the trades & Here is an example of how we do it.
The best part ?
ITS FREE - click here : telegram.me
Everytime we see a stock breaking out on chart we share the trades & Here is an example of how we do it.
The best part ?
ITS FREE - click here : telegram.me
Loading suggestions...