A thread on getting intraday (any timeframe) data to excel without any coding. Limited to only last 60 days. Fetches from zerodha chart.

👇

So..had a great conversation last night with older investment types, old friends whom I traded with/against and managed money against or for. Age diff from me is > 10+ years so the takes were interesting but the common theme was a little disturbing (depends on your view)

Was looking at the landscape of the world & quite concerned where we are (I do not share your optimism for a shinny happy future). I am a Bond guy + Cycles & my view approach is ALWAYS what is the worst that can happen (that is how I was taught to trade & manage money) As a Bond

Money manager you never every want to apologize for a negative year, most people don't understand bonds can lose lots and lots and lots of money. So my view on life is always negative & fuck you approach.

The others are similar but have more equity exposure and FX, one other is really good via commodities so the conversation was from a top down look with some bottom up approaches. So.....after looking at the notes of the great conversation this is how it looked:

basically the world changed 2007/2008 especially North America. The GFC set in motion financial engineering games and here we are. The issues pre this (2000 to 2007) set ALL this up so lots of blame to go around but to pin point certain things the real problems started with QE &

While watching the GameStop stuff has been mildly hilarious (I mean who doesn't like watching the financial elite squirm?) it's pretty clear that a whole bunch of folk have convinced themselves this is ACTUALLY some kind of revolutionary activity. It isn't. 1/

Sure, it's highlighted yet another way in which the bastards profiteer but that's about it, stick it on the pile with the fifty other pro tips to keep the poor, well poor... It's todays banter and tho a few folks might have egg on their faces, literally nothing will happen. 2/

GameStop's three largest shareholders have earned £1.5bn+ during this. They sit at the top of some 200 institutions which are rolling. Meanwhile the ersatz rebels are now watching the bubble, realising there is profit to be made and having a wibble. 3/

No doubt some TRULY believe they are taking part in some kind of revolution but frankly it's utterly absurd and the vast majority are in it for the lulz and to cash in quick.

I'm sorry to tell you this, but you don't own GameStop.

4/

The reality is, the scale of the economic disparity and corruption is simply vast. Billionaires loosing a few millions means nothing. They buy one less yacht and you continue to live meal to meal.

The "Free Market" changes a few systems and the abuse continues. 5/

1/

Get a cup of coffee.

In this thread, I'll help you understand Geometric Expectations.

2/

Imagine we have an investment opportunity.

If the investment goes well, we get to double our money.

But if it goes badly, we'll end up losing three fourths of it.

There's a 50/50 chance of either outcome.

The question: is this a good bet or not?

3/

A simple way to approach this question is to calculate the bet's "expectation".

For every $1 we bet, there are 2 possibilities:

1. The lucky case, where we double our money and end up with $2, and

2. The unlucky case, where we lose (3/4)'th to end up with just $0.25.

4/

Each of these outcomes is equally likely.

So, on *average*, every $1 we put in turns into ($2 + $0.25)/2 = $1.125.

This is a *positive* 12.5% return.

Such bets are called *positive expectation* bets. On average, we expect to *make* (rather than *lose*) money on them.

5/

Suppose we could take many turns betting at these odds.

In any one turn, we could of course lose money.

But because our bet has positive expectation, *over time* we expect to make money.

Over the last 18 months, I have scaled my income to around ₹10,00,000 or 10 lakhs per week with drawdowns below 10%.

How?

@niki_poojary taught me how to form a weekly trading plan.

I'm going to share what I've learned in this thread.

Here's the simple 10 step process: 🧵

1. Check on the daily chart if Bank Nifty is in a higher high or lower low:

A higher-high (HH) is a bullish pattern, it signifies that it is difficult for the market to go down.

If that has formed on the daily chart, the market will give all the surprises on the upside.

If the market is in a higher high mode, look for good opportunities to sell puts.

Usually, at a higher high, traders buy on breakouts and also buy the dips.

If you want a good Risk-Reward, you can sell puts on a dip. (Only if it's showing some reversal)

2. Take High Probability Trades

Simply knowing a higher high or lower low does not make money. It gives you a bias for the week.

Still, you should try to take higher probability trades that align with your view of the market.

This will get you consistency and a good mindset.

3. Support & Resistance

I would say Support Resistance is the most important and favorite thing for @niki_poojary.

She keeps updating these levels with charts on her Twitter handle during live markets daily.

Attaching some examples will do a detailed thread on this later.

Learn about the STEEL SECTOR in this thread

The demand for steel is generally only 1.2 times the GDP & there is no significant growth in our GDP but still the sector has rallied relentlessly, lets try & understand

Do ‘re-tweet’ & help us educate more investors (1/22)
#Investing

The metal sector is broadly divided into 2,
-Ferrous is a category of metal that has Iron in it, Steel as an example
-Non-Ferrous is a metal, which does not have Iron content, Aluminum, copper, lead, nickel, Zinc etc.
This thread focuses on Ferrous & hence Steel (2/22)

To start, lets understand with how steel is made (its important).
Iron ore is mined, it is then first converted to Iron & Iron is then converted to Steel. There are 3 processes of making steel
-Blast Furnace
-Scrap Metal
-DRIP/Sponge
We will discuss all three (3/22)