BC ALL
Saved by @raffijashua_08

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"
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.
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.
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.
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.
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.
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.
➡️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.
If you liked this then do like and retweet the initial tweet :

https://t.co/xEg2LWQ7hC
More about our free lifetime group: https://t.co/bMyEe5HXjr

More from The Chartians

The Chartians
The Chartians
@chartians
Trading on chart patterns is difficult, Until you see this:

Free Technical Analysis course (1/10) 🧵

Rounding Bottom or U Pattern or Saucer all are one and the same with different names and it is a bullish pattern.

Technically, it can be used for both continuation trades in an existing uptrend and reversal trade as well in the case of the downtrend.


Now how we trade rounding bottom pattern?

We try to find out stock that has the pattern but has not given a breakout above the neckline.

Generally, we have observed that majority move happens on breakout itself hence; we keep this stock in the watchlist just before breakout.

What does this mean?

Basically, we look out for the charts where price is consolidating just below the neckline or resistance.

As seen from the below chart where price was consolidation just below the resistance before the breakout and massive upmove.


Also, you would lot of Rounding Bottom Patterns when a stock is in uptrend. That's why this pattern is also called a bullish continuation pattern.

In below chart you can see 4 Rounding Top pattern in an uptrend for a stock.
ALL
The Chartians
The Chartians
@chartians
IN TRADING, THE TREND IS YOUR FRIEND!

Buying a weak stock and Selling a strong stock is a crime in trading.

Sharing 3 SIMPLE methods that a buyer can use to identify strong stocks in an uptrend and increase the probability of success.

Sharing screeners link to help you out!

1/ Near All-Time High Screener:

Stocks that are bullish have the characteristics that they continue to make new highs. One of the best ways to identify such stocks is to look out for the stocks that are in the 25% range of all-time high levels.

Screener link to identify near all time high

2/ Using 200 EMA for Investing:

Investors can use 200 EMA on the weekly time frame and any stock that is above it can be considered as a strong stock in investment.

Pidilite is above 200 EMA since 2010 and it has created enormous wealth for investors.


This screener can be used to identify a list of stocks that are above 200 EMA on the weekly time frame and are strong stocks to
CATAGORY TRADING
Advertisement
The Chartians
The Chartians
@chartians
🩸FIBONACCI retracement and GOLDEN RATIO - PART 2

Before we move forward, kindly like and retweet if you find our content is adding something to your knowledge.


We have described how interesting Fibonacci numbers and ratios are and how it's been formed in PART 1 of this series. In PART 2, Lets see how we take trade based on fibo.

🎯How to draw Fibonacci levels?
Drawing Fibonacci retracemnts are fairly simple. The main point we look into is, If the direction of retracment is up or down side.
✅ If the trend is up, choose lower point and a higher point. Connect lower point with higher point using Fibo tool.

✅ If the trend is down, choose higher point and a lower point. Connect higher point with lower point using Fibo retracement tool.

🎯How to choose lower and higher points to connect?
✅Take lower point as point from where the trend has started, which means one should not take points where consolidation was going on.
FIBONACCI
The Chartians
The Chartians
@chartians
I’ve went from knowing nothing about Trading to currently mentoring 400+ people!

30,000+ hours of experience summed up in 30 lessons.

A thread🧵

1/
The amount of time you spend in the market trading/investing will always give you more insights than reading 100s of books

2/
If you treat markets as a sole income generator, your chances of underperformance due to compulsion of income generation will always be higher !

3/
4-5% a month is always better than chasing unlimited downside risk strategies that promise you 40-50%

4/
Your chances of making money in a stock sitting near 52wk high will always be more than a stock sitting at 52wk low
ALL
The Chartians
The Chartians
@chartians
Trading on chart patterns is difficult until you read this !⚡️

Everything about Ascending Triangle Pattern

Free Technical Analysis course (3/10) 🧵

Ascending triangle is created by price moves that allow for a horizontal line to be drawn along the swing highs and a rising trendline to be drawn along the swing lows.

Horizontal line is the resistance, trendline indicates higher lows, i.e. uptrend.

It is a bullish pattern.


How we trade Ascending Triangle pattern?

We try to find out stock that has this pattern but has not given a breakout above the resistance. That means it is forming higher lows and consolidating near resistance.

We track it before the breakout to capture a big move on breakout.

What does this mean?

Basically, we look out for the charts where price is forming higher lows and consolidating near the resistance.

As seen from the below, chart where price was in consolidation just below the resistance before the breakout and upmove.


Now the most important question is how we trade this pattern?

1. First identify stocks that are forming Ascending Triangle pattern and are about to give a breakout.
2. Stoploss would be the nearest swing low below the current price.
ALL

More from All

Billy Bostickson \U0001f3f4\U0001f441&\U0001f441 \U0001f193
Billy Bostickson 🏴👁&👁 ...
@BillyBostickson
Tip from the Monkey
Pangolins, September 2019 and PLA are the key to this mystery
Stay Tuned!


1. Yang


2. A jacobin capuchin dangling a flagellin pangolin on a javelin while playing a mandolin and strangling a mannequin on a paladin's palanquin, said Saladin
More to come tomorrow!


3. Yigang Tong
https://t.co/CYtqYorhzH
Archived: https://t.co/ncz5ruwE2W


4. YT Interview
Some bats & pangolins carry viruses related with SARS-CoV-2, found in SE Asia and in Yunnan, & the pangolins carrying SARS-CoV-2 related viruses were smuggled from SE Asia, so there is a possibility that SARS-CoV-2 were coming from
ALL
Steve
Steve
@braidedmanga
Ivor Cummins has been wrong (or lying) almost entirely throughout this pandemic and got paid handsomly for it.

He has been wrong (or lying) so often that it will be nearly impossible for me to track every grift, lie, deceit, manipulation he has pulled. I will use...


... other sources who have been trying to shine on light on this grifter (as I have tried to do, time and again:


Example #1: "Still not seeing Sweden signal versus Denmark really"... There it was (Images attached).
19 to 80 is an over 300% difference.

Tweet: https://t.co/36FnYnsRT9


Example #2 - "Yes, I'm comparing the Noridcs / No, you cannot compare the Nordics."

I wonder why...

Tweets: https://t.co/XLfoX4rpck / https://t.co/vjE1ctLU5x


Example #3 - "I'm only looking at what makes the data fit in my favour" a.k.a moving the goalposts.

Tweets: https://t.co/vcDpTu3qyj / https://t.co/CA3N6hC2Lq
FINANCE , ALL
Advertisement
WORLD OF SANATAN DHARMA
WORLD OF SANATAN DHARM...
@world_sanatan
EVOLUTION OF CROWNS

The ancient Indian kings called a head crown as a Mukut and it would mostly constitute of a golden ornamental headgear like an oval cap with gems.

Sometimes it would also include a halo circle to show the divinity of the king

1/7


As it was considered that kings were appointment by the gods themselves. Example the kings of mewar considered themselves to be the ‘Diwan of eklingji')

But in most cases very few Mukut with halo effect have been found.

2/7

Samudragupta in the gupta era coin. You can see the helmet like headwear on him.

Till gupta era the solid golden head wear was used in most days of the monarch.

But since the onset of 8th century it reduced in usage and was now used only as a ceremonial headwear.

3/7


Whereas earlier the Maharaja had to wear the mukut whenever his court was in session.

Still mukut was being used prominently for ceremonial activities till recent times.

Maharaj Dahir of Sindh👇

4/7


But as times past the style of headwear also changed.

The kings mostly wore turbans ordained with pearls and gems while rarely anyone wore a true Mukut after 16th century.

Portrait of Sri Krishna Dev Raya👇

5/7
ALL
The Secret CFO
The Secret CFO
@SecretCFO
If you are the CEO or CFO at a business who banks with SVB; here are some things you CAN do over the weekend

1. Build a 4 week rolling daily receipts and payments style cashflow forecast.

2. Gear up finance team to actualize & reforecast every AM by 10am

3. Schedule a Daily Cash Management Crisis call for 10am every day. CEO to chair

4. Redirect any future cash receipts / revenue into non SVB accounts. Don’t throw fresh money on the fire.

5. If SVB is your only current bank. Open accounts with 2 other AA or A rated banks.

6. Go supplier by supplier and grade them a, b or c
a - showstoppers
b - pay if you can
c - don’t pay

You want as few a’s as possible, ideally none.

7. Find out how to get your $250k FDIC cash.

8. If you are able to pull any deposits or bonds back into a non SVB account. Do it. Put hands on any liquid you can.

9. Communicate a salary deferral plan with your top team. CEO takes the most pain $ and %. Important signal.

10. Elevate sign off of all new POs to CEO and CFO jointly. Don’t sign any off.

11. Make a list of ‘survival headcount’. The bare minimum on which the business can operate.

You may need this to prioritize payroll later.
ALL
Buzz Chronicles
Buzz Chronicles
@buzz_chronicles
@SaveToBookmarks Ciao! Of course! Original tweet by @AnJamison: "@LakotaMan1 @buzz\_chronicles @buzz\\\_chronicles @buzz_chronicles save as categ...". Enjoy ✌

Hello! You can find it here. Original tweet by @SaveToBookmarks: "@AnJamison @LakotaMan1 @buzz @buzz_chronicles @pdfmakerapp @Readwiseio @threader...". Thanks! ✌
ALL

You May Also Like

Kitze @ \U0001f1e9\U0001f1ea\ufe0f
Kitze @ 🇩🇪️...
@thekitze
To people who are under the impression that you can get rich quickly by working on an app, here are the stats for https://t.co/az8F12pf02

📈 ~12000 vistis
☑️ 109 transactions
💰 353€ profit (285 after tax)

I have spent 1.5 months on this app. You can make more $ in 2 days.

🤷‍♂️


I'm still happy that I launched a paid app bcs it involved extra work:

- backend for processing payments (+ permissions, webhooks, etc)
- integration with payment processor
- UI for license activation in Electron
- machine activation limit
- autoupdates
- mailgun emails

etc.

These things seemed super scary at first. I always thought it was way too much work and something would break. But I'm glad I persisted. So far the only problem I have is that mailgun is not delivering the license keys to certain domains like https://t.co/6Bqn0FUYXo etc. 👌

omg I just realized that me . com is an Apple domain, of course something wouldn't work with these dicks
MAKERS
Jeannette Ng \u5433\u5fd7\u9e97
Jeannette Ng 吳志麗...
@jeannette_ng
So, you’re a writer and you’re worried about writing outside your immediate experiences and identities.

Here is the thread of practical advice for you.

EXAMINE YOUR MOTIVES. Why do you want to write this?

Are you trying to solve racism/sexism/colonialism with your work?

As writers we love stories about heroic writers whose work has changed the world. And as such we like to look to our own writing to solve societal problems.

And I understand this completely, not the least because I’ve felt the pull.

But if you’re looking to play saviour with your words, it is unlikely that you will do the marginalised people you are trying to save justice.

And I understand this very often comes from place of good intentions, but there is a reason that most of the moralising plays written by white abolitionists are deeply uncomfortable to read.

It is incredibly easy for works looking to play saviour to become patronising or traffic in simplistic stereotypes that ultimately hurt the people they are looking to rescue.
WRITING
Advertisement
Anu Satheesh \U0001f1ee\U0001f1f3
Anu Satheesh 🇮🇳...
@AnuSatheesh5
Velimalai Kumaraswamy Kshetram
Kumarakovil, #Kanyakumari
#Tamilnadutemples 🚩

Velimalai Kumaraswamy Temple is a Murugan temple located in Kanyakumari District of Tamilnadu.

Muruga faces east and is said to be facing Sthanumalayan (Paramashiva) of Suchindram. Muruga is of


eight feet vigraham and Valli thayar is six feet tall. Eventhough Thiruthani is believed to be the place where Subrahmanya married Valli, it is also believed that Valli’s thayar's marriage took place with Murugan here.

There is a Kalyana Vinayakar sannidhi
who helped Muruga's


marriage with Valli. Kumarakovil is also known as Kumara Kshetram and Subrahmanya Sthala. The Tamil epic Chilapathikaram refers to the temple as Chera Nattu Aeragam

Wedding of Valli and Murugan is celebrated here in the Tamil month of Panguni (March-April).

Om Muruga
🙏🕉🙏
ALL
Pieter Levels \u2728
Pieter Levels ✨
@levelsio
Joe Rogan's podcast is now is listened to 1.5+ billion times per year at around $50-100M/year revenue.

Independent and 100% owned by Joe, no networks, no middle men and a 100M+ people audience.

👏

https://t.co/RywAiBxA3s

Joe is the #1 / #2 podcast (depends per week) of all podcasts

120 million plays per month source https://t.co/k7L1LfDdcM


https://t.co/aGcYnVDpMu
MAKERS
Ranvijay Singh\U0001f1ee\U0001f1f3
Ranvijay Singh🇮🇳...
@ranvijayT90
#Thread Two divine forms of Khatu Shyam ji...


On the day of Amavasya, devotees get the darshan of Shyam Baba in Shyam varan (black color). In ordinary days, the form of Baba is saffron. The reason for this is a custom. The real head of Shyam Baba which had appeared from Shyam Kund is of Shyam varan.


Every day Shyam Baba's grand Shringar is done by Pujaris. The main part of Shyam Baba's shringar is Tilak. This Shringar is done by the members of Nij Mandir sevaks. The sevaks of the Nij Mandir do sandalwood tilak to Baba everyday in the auspicious time.


This Divine Tilak is applied from the forehead to the nose. When Baba is given a bath by sevaks, this tilak comes off. Then in the auspicious time, the sevaks again apply tilak to Baba.


There is no auspicious time on the Amavasya. Because of this, tilak is not done on that day. That's why devotees have darshan of Shyam Baba on the Amavasya only in the actual real form (Shyam Swaroop). Baba's tilak is done on Amavasya only on the day of Deepawali.
ALL