BC HISTORICAL DATA CAPTURE METHODOLOGY
Saved by @kirankio1996

Most beginners when building a trading strategy simply use current info and test with it, they don't know How to Get Historical Stock Futures lot size, list of stocks that are part of index like Nifty 50, Nifty 500 historically, I will share all such info in this thread

 Please note that there is no way to get the historical lot size of stocks futures, NSE don't publish it directly, so we need to do some calculated steps to get that data. Download Market Activity report https://t.co/HKLkSVtXEI
The zip file contains multiple files, open the second file.
The file will contain stock symbol, expiry date, OHLC data, along with that you get traded quantity and No of contracts traded, using this data we can calculate the lot size of every stock symbol. Simply divide Traded QTY / NO of contracts gives you the lot size.
So to get the historical stock futures data, all you need to do is change the date in the below link

https://t.co/xIBXsPpIVt For an example, to get the historical stock futures lot size data for Sep 2016, use https://t.co/Criu7S3Fi5
If you want to download the FnO stocks and their lot size for current month, you can simply go to https://t.co/imuJA3Nmj7
When you are designing a stock trading system based on certain universe like Nifty 50, Nifty 500 etc, it is important to test the strategy with list of stocks that are part of these indices historically.
If you test the strategy with current Nifty 50 or Nifty 500 stocks, you will get extraordinary results due to survivorship bias. Don't do that mistake. Stocks like DLF, RCOM, UNITECH were part of Nifty 50 in 2008, not any more.
To get Historical constituents of Nifty Index data, go to https://t.co/qbCBz0w7P0 which will show you current month list of stocks that are part of different indices. Click on Archive
Select Indices - Market Capitalization from drop down and select historical month/year, click on submit. It will generate a zip file which will contain the required information.
Not only for Nifty 50, Nifty 500, you can get the list of stocks that are part of each index.
Once you open the PDF file, you can see the stock symbol, full name, which industry it belongs to and their weightage with respect to index.
So to get the historical stocks list for different indices, all you need to do is change the month/year in the below link

https://t.co/MVN1wrKt4z

For an example, to get the historical constituents of all index for Aug 2013, i will use https://t.co/k79hR372dW
The top 10 stocks of Nifty 50 determines the over all direction of the markets And this top 10 varies at frequent intervals. So to get the historical TOP 10 Nifty 50 stocks, all you need to do is change the date/month/year in the below link

https://t.co/bNMunOr74B
You can download end of the data from NSE for all equity cash segment stocks Go to https://t.co/Vo3DHGP1f0

enter the stock symbol and date criteria for which you want to download the data
To get the stock futures historical data, go to the below link select the symbol, year, expiry period and time period for which you wan to download the data

https://t.co/hjyUDNVwZ2
To get the Index spot data, go to below link and select the index from drop down and give the time period.

https://t.co/Ny8T1X8Xee
List of all ETFs:

To get the list of all Exchange Traded funds listed in NSE, just go this link https://t.co/XSqmXhmxJN
In last 25 years there were many stocks which was included in Nifty 50 and stocks that did not perform well were removed from Nifty 50. List of stocks that were added to different index and removed from different index data is available in this link

https://t.co/0Dn036xifc
The complete information has been drafted as a blog post and shared here, check it out. https://t.co/ccwXC11TnH

More from Kirubakaran Rajendran

Kirubakaran Rajendran
Kirubakaran Rajendran
@kirubaakaran
Analyzed last 12 years of historical data to check if there are any patterns we can observe to find the best time to invest in stocks for long term. #Nifty50 #investing #stocks 1/10


This is how Nifty moved in last 15 years with three major corrections, in the year 2008,then around 2016 and then year 2020 due to Coronavirus. Only when we look back with hindsight bias we could say those were the best time to invest. But is there really any quantitative method?


200 day moving average is something that is widely used by many investors to check for long term trend. Where investors consider if stocks trades above 200 DMA, its in bullish phase and if it trades below 200 DMA its in bearish phase.

We shall run an analysis to find out of Nifty 50 stocks, how many number of stocks trades above 200 day moving average, higher the number, stronger the market. we need correct data, we cannot test it with current Nifty 50 stocks,

we need list of Nifty 50 stocks that are part of index historically, so when we run for Jan 2008, stocks like RPL, RNRL, UNITECH were part of Nifty 50, so it is essential to test it with correct datasets.
TRADING
Kirubakaran Rajendran
Kirubakaran Rajendran
@kirubaakaran
Nifty 14500 CE trade which made day low price of 0.15 and day high price of 2139, due to erroneous order by a broker who lost 250 crores. Some ppl claim few others brokers made 50 to 75 crores profits. But what really happened? Here's the tick data analysis that shows true info🧵

Yesterday being a weekly expiry market was so calm, not making any major movements. Nifty was trading around 16500 but there was a freak trade happened with deep In the money option 14500 CE. It was trading around 2000 levels, usually the liquidity will be very shallow with ITM

it was hovering around 2000 to 2100 levels but suddenly around 2:30 pm, the price of the option went as low as 0.15 paise. Here's the tick data price chart of 14500 CE option strike


What's really interesting about this sudden move is, usually when a freak trade happens it last for few seconds and instantly get back to its average traded price levels. But in this case, there were many buy trades executed at a very low price.

Obviously this a fat finger error trade, where a broker based out of Kolkatta, erroneously placed sell order for 14500 CE instead of 16500 CE.
ALL
Advertisement
Kirubakaran Rajendran
Kirubakaran Rajendran
@kirubaakaran
Over the last couple of years, I did n number of research on systematic investment methods.
What happens if I do SIP only during market corrections ?
What happens if I pick stocks based on momentum rules? Here’s small thread on Why I moved to index fund investing? 🧵

When it comes to trading most of us are busy with backtesting multiple option trading strategies with no code platforms like Stockmock Algotest etc but when it comes to investing very few charting platforms available to test long term investing methods.

I wanted to do SIP but instead of investing in mutual funds, I wanted to develop systematic approach on choosing the stocks and invest in them and rebalance them based on certain criteria.

I have written multiple articles on this topic, like how to find which is the best sector to invest?

Should you invest in 52 week high stocks or 52 week low stocks ?
ALL
Kirubakaran Rajendran
Kirubakaran Rajendran
@kirubaakaran
A small thread on Mindset of a successful trader. What differentiates best traders from the bad ones? Why 95% of the traders don’t make money? Trading is an unpredictable game, how could one win in that? 1/n


Many people think some magical strategy or indicators is all they need to be successful at Trading. But what really goes in the minds of a successful trader? Professor Hichman Benjelloun did a research on this.

Successful traders have poker face. If you talk to successful traders or chat with them, you can’t figure out if they are happy or sad. Having good time or bad time.

For them making money or losing money is same thing, as they say a good trader feels great after a good trade, but a great trader feels NOTHING after a great trade. They control their emotions not only in trading but also outside their trading life. They are highly disciplined

Whether they are making money or losing money, they continue with their daily routine, going to gym, cycling etc they don’t skip it because of a losing trade. It doesn’t affect them. They have probability mind set. What does that mean?
ALL
Kirubakaran Rajendran
Kirubakaran Rajendran
@kirubaakaran
A small thread on various historical data analysis and trading strategies articles that I have shared so far. #TradingSystem #AlgoTrading 1/n
"Is long strangle strategy profitable?" https://t.co/luHnX1SGxx


"Is #Intraday trading profitable?"
Every long term investor was once a Intraday trader.

If you avoid the below three mistakes, intraday trading is definitely

"The best way to invest in #StockMarket, follow this simple rule"

Let’s consider two different scenarios,

Market crashes after your investment
Market rallies after your

Investment in #Gold is really good diversification. It helps well during bad economy period. However, instead of buying physical gold, you can invest in Gold ETF like Goldbees. Here’s the last 13 years historical analysis of Gold price

How about a trading system that gives you just two or three trades in a year, but ends up giving phenomenal returns. This is one such trading strategy with plain simple rules
GOOD READS

You May Also Like

Brian Cates
Brian Cates
@drawandstrike
Great article from @AsheSchow. I lived thru the 'Satanic Panic' of the 1980's/early 1990's asking myself "Has eveyrbody lost their GODDAMN MINDS?!"


The 3 big things that made the 1980's/early 1990's surreal for me.

1) Satanic Panic - satanism in the day cares ahhhh!

2) "Repressed memory" syndrome

3) Facilitated Communication [FC]

All 3 led to massive abuse.

"Therapists" -and I use the term to describe these quacks loosely - would hypnotize people & convince they they were 'reliving' past memories of Mom & Dad killing babies in Satanic rituals in the basement while they were growing up.

Other 'therapists' would badger kids until they invented stories about watching alligators eat babies dropped into a lake from a hot air balloon. Kids would deny anything happened for hours until the therapist 'broke through' and 'found' the 'truth'.

FC was a movement that started with the claim severely handicapped individuals were able to 'type' legible sentences & communicate if a 'helper' guided their hands over a keyboard.
CULTURE
XVIII Airborne Corps\U0001f409
XVIII Airborne Corps🐉...
@18airbornecorps
1 of 16: WE ARE ALL JEWS HERE: THE STORY OF RODDIE EDMONDS

One of the most moving and relevant stories of the Battle of the Bulge, or any American Soldier in any war, is that of Master Sergeant Roddie Edmonds, a Knoxville, Tennessee native, who served with the 106th Infantry.


2 of 16:

Roddie was captured early on in the Battle of the Bulge, on December 19th, when Panzer forces plowed through his unit.

He, along with almost his entire regiment, was forced to surrender.


3 of 16:

The men were transported to the Stalag IX-A POW camp in Ziegenhain, Germany.

Roddie was the senior enlisted American Soldier at the site. As such, he was the conduit between all American Soldiers and their German captors.


4 of 16:

In late January, the camp’s commandant, Major Siegmann [pictured here], ordered Roddie, a Christian, to identify all Jewish Soldiers and order them to stand in formation by themselves the next day.

[Jewish Soldiers were a minority within American units]


5 of 16:

Throughout WWII, captured Jewish Soldiers were often tortured and then killed by their German captors.

In fact, Jewish Soldiers had been told to bury their dog tags before capture. The dog tag identified Jews with the letter “H” for Hebrew.
SOCIETY
Advertisement
Greta Musk
Greta Musk
@GretaMusk
🚔 HUGE #Tesla SERVICE PROBLEMS THREAD🚔

You might remember my 3 prior threads on how
TESLA. TREATS. ITS. CUSTOMERS. LIKE. TRASH.

Here's the 4th installment.
@tomkeinan @jonsey_lisa @jwmooc @tchanpoker @bryanthediamond @EconomicManBlog
$TSLA $TSLAQ 1/22


Welcome to Greta's 4th edition of #Tesla customers getting used and abused. Because that's the Elon Musk way.
@coffeebreakls @KocgibiHarun @omaragha @JayGhahari
$TSLA $TSLAQ 2/22


"The best service is no service." - Elon Musk a.k.a. #SpaceKaren
@briansaziz @FarSha998899 @thinktankfour @Billoday1
#Tesla $TSLA $TSLAQ 3/22


These #Tesla customers represent just the very tip of the iceberg. They are ones who have Twitter, have decided to complain about their #TeslaServiceIssues publicly, and were found by yours truly.
@yanismydj @hajelatweets @AlanHeldman @francislongo5 $TSLA $TSLAQ 4/22


Dear #Tesla customers: In California, if your vehicle has been out of service for >30 days total, it's a lemon. You can get punitive damages and attorney's fees. Don't sit around and take Elon's abuse. @13arm13arm @cecimar12 @richardson_skip @shootinglee $TSLA $TSLAQ 5/22
TECH
WORLD OF SANATAN DHARMA
WORLD OF SANATAN DHARM...
@world_sanatan
THE LAST STAND OF PAVAN KHIND - THE 300 BATTLE OF INDIA

A long🧵that u must read

In desperate times, great men come forth. Those men who are ready to sacrifice all of their lives work for a single cause.

Baji Prabhu Deshpande is one such man.

1/25


Battle was between the Maratha Warrior Baji Prabhu Deshpande and Sidi Masoud of Adil Shahi Sultanate.

In 1660, the Maratha King Shri Chhatrapati Shivaji was trapped in the fort of Panhala, under siege and vastly outnumbered by an Adilshahis army led by Sidi Masoud.

2/25

And while everyone is thinking that finally the Maratha king will be subdued, Shivaji planned to escape to the fort of Vishalgadh. It was administered by a Maratha chieftain named Range Narayan Orpe under Shivaji.

3/25

For months the siege warfare continued as Shivaji made sure that the food source of the Besieging army drops down, due to which they will initiate a general assault on the castle.

4/25

Shivaji, Baji Prabhu, and around 600 of their best troops, hardened mountaineers of the Maval region, would dash through the Adilshahis force at night.

A man named Shiva Kashid, who resembled Shivaji in appearance, had volunteered to dress like the king and get captured.

5/25
ALL
Amit Schandillia
Amit Schandillia
@Schandillia
[THREAD: HISTORY OF THE HINDU TEMPLE]
1/102
Four hours south of Aswan in Lower Nubia, right by the Nile, is a region dotted with temple complexes built more than 3,000 years ago. Some like the temples of Amada, Derr, and Beit el-Wali go as far back as 1500 BC.


2/102
A little further south, not far from the border with Sudan, is another complex dedicated to Ramses II, Hathor, and Nefertari in the village of Ipsambul, better known locally as Abu Sunbul and internationally as Abu Simbel. These go back to the 13th century BC.


3/102
Djeser-Djeseru, also known as the mortuary temple of Hatshepsut in Upper Egypt also dates to 1400 BC. Over 500 years older is the nearby Mentuhotep II, also a mortuary temple. Both were dedicated to the cult of Amun Ra, besides their respective pharaohs.


4/102
Far older is the Ġgantija complex of Malta. Going as far back as 3600 BC, this one comprises of two temples entirely made of stone and enclosed in a stone wall. From the figures therein, it's understood to be a site of some kind of a fertility cult worship.


5/102
Dating from the same period are the limestone megaliths of Ħaġar Qim and Mnajdra, both said to have once hosted ritualistic sacrifices as part of the same fertility cult worship as found in the Ġgantija complex. Malta has some of the oldest temple complexes in Europe.
RELIGION