5 things that a trader should know and implement:
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 :
5 things that a trader should know and implement:
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
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
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"
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("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("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/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.
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.
➡️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.
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.
https://t.co/xEg2LWQ7hC
Google sheets is used by almost 99% people in the world \U0001f30e
— The Chartians (@chartians) August 9, 2022
Most people don\u2019t know how to use it for TRADING and INVESTING purposes \U0001f4d6
10 features everyone should know :
CHARTIANS LIFETIME FREE GROUP ANNOUNCEMENT!
— The Chartians (@chartians) August 8, 2022
\u26a1\ufe0f Positional option strategies [ Stock + Index ].
\u26a1\ufe0f Hero zero calls.
\u26a1\ufe0f Our High Probable Cash and Positional picks \U0001f60e
\u26a1\ufe0f Short & long term Swing bets.
\u26a1\ufe0fIndex Option Spreads for Safe players
How to Join |https://t.co/pUjh0jw1Kk pic.twitter.com/5koT8A2lEi
More from The Chartians
Kindly RETWEET and LIKE if you feel our efforts adding to your knowledge.
🩸Types of
There are 4\u20e3 type of #BREAKOUTS
— The Chartians (@chartians) January 22, 2021
1\u20e3 Breakout with no retest
2\u20e3 Breakout with a re-test
3\u20e3 Breakout with a hard re-test
4\u20e3 Failed breakout.
We Will Explain it one by one with examples. Kindly Retweet it if you find it useful. #Nifty
🩸 Detailed guide on TX, a free trading tool by
A detailed guide on #TX3 by @EdelweissFin
— The Chartians (@chartians) August 8, 2021
Software worth 50,000/- for F R E E \U0001f3c6
Scroll down \U0001f447 for detailed analysis
(Using for 2+years)
User guide PDF \U0001f4d9 https://t.co/Ke7Bn2jRO8 #chartians #momentum #StockMarketindia #trading #tx3 #edelweiss pic.twitter.com/6M7TCYpPLc
🩸 Fibonacci retracement and golder ratio - Part
\U0001fa78FIBONACCI retracement and GOLDEN RATIO - PART 2
— The Chartians (@chartians) August 8, 2021
Before we move forward, kindly like and retweet if you find our content is adding something to your knowledge. pic.twitter.com/HDlcOa5ZPP
🩸 Fibonacci retracement and golden ratio - Part
\U0001fa78FIBONACCI retracement and GOLDEN RATIO
— The Chartians (@chartians) August 7, 2021
Before we move forward, kindly like and retweet if you find our content is adding something to your knowledge. pic.twitter.com/iVC6W3pqks
More from All
You May Also Like
One of the oddest features of the Labour tax row is how raising allowances, which the media allowed the LDs to describe as progressive (in spite of evidence to contrary) through the coalition years, is now seen by everyone as very right wing
— Tom Clark (@prospect_clark) November 2, 2018
Corbyn opposes the exploitation of foreign sweatshop-workers - Labour MPs complain he's like Nigel
He speaks up in defence of migrants - Labour MPs whinge that he's not listening to the public's very real concerns about immigration:
He's wrong to prioritise Labour Party members over the public:
He's wrong to prioritise the public over Labour Party