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
I have watched lot of movies but only few movies would change your perspective towards life, here’s the 10 movies that really changed my mindset

1.The Theory of Everything

Brilliant acting , truly mesmerising portrayal on life of Stephen Hawking, never felt bored even for a sec


2. Rush - it’s a film about F1 racer James Hunt & Nikki Lauda, excellent narration and incredible acting. The dialogues were truly masterpiece and it’s still stays in mind even after 9 years


3. The Founder - This movie released at the right time in my life, when I was about to quit my job and focus full time on my startup. This movie is all about single man Ray Kroc who built a billion dollar empire McDonalds. This is the best entrepreneurship movie ever made.


4. The Imitation Game - I watched this movie when I started my rule based trading journey in 2014, struggled a lot during my initial phase with code, unable to get any breakthrough, this film gave my that ray of hope. It’s about a mathematician who broke the code n won the war


5. The Pursuit of Happyness - any favourite Movie list would be incomplete without this movie. Will Smith, damn what an actor he is. I watched this movie when I was in college days, still remember the day, I was crying non stop during the interview scene. Brilliant film.
MOVIES BUCKET
Kirubakaran Rajendran
Kirubakaran Rajendran
@kirubaakaran
Whenever #Nifty & #BankNifty closes less than -1% on Fridays, what happens on Monday and what happens on next 30 days. Interesting analysis, will be sharing the details shortly.

Only 7 times in last 11 years, #IndiaVix moved more than 15% on Fridays and only 2 times Vix dropped on following Monday, rest all the time Vix increased on Monday as well.


After Friday’s Vix big move, What happens after 30 days, all 7 times the Vix went up much higher in next 30 days. So this Friday’s fall could be start of the next big volatile sessions in the coming weeks


With 25 years of data, 251 times Nifty dropped < -1% on Fridays, 58% of the time following Monday witnessed further fall, average move on such Mondays are -1.8%


This how Nifty moved in next 30 days, after the Friday fall. Market continued to slide in next 30 days as well. 58% of the time next 30 days returns turned negative.
ANALYSIS
Advertisement
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
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 thread on Position Sizing #Trading is the only profession where you can see Doctors, Engineers, and many other successful professionals try their luck with stock market, these people excel in their own respective field but struggle a lot when it comes to trading.1/n

Unfortunately, everybody believes that a successful trader always has a secret Technical Skill. But the truth is Technical skill is the least important factor to be a superstar trader.

Then what separates a great trader from the group of average traders? Its their emotion.


This is how most traders think: They first think about the Entry point, at which price should I buy? At which level should I enter? At which point should I get into a trade?


But this is how you must think to be a profitable trader. You have to adapt to trading strategy that suits your psychology, assign trade management rules, keep position sizing and money management rules.


One of the main reason people lose money in stock market is because of their position size. Example: Vicky starts trading with a capital of Rs. 1,00,000 and he finds a trading opportunity and buys Spice Jet share for Rs. 100. At the max, he can buy 1000 shares of Spice Jet stock.
ALL

You May Also Like

Erik Torenberg
Erik Torenberg
@eriktorenberg
1/ Here’s a list of conversational frameworks I’ve picked up that have been helpful.

Please add your own.

2/ The Magic Question: "What would need to be true for you


3/ On evaluating where someone’s head is at regarding a topic they are being wishy-washy about or delaying.

“Gun to the head—what would you decide now?”

“Fast forward 6 months after your sabbatical--how would you decide: what criteria is most important to you?”

4/ Other Q’s re: decisions:

“Putting aside a list of pros/cons, what’s the *one* reason you’re doing this?” “Why is that the most important reason?”

“What’s end-game here?”

“What does success look like in a world where you pick that path?”

5/ When listening, after empathizing, and wanting to help them make their own decisions without imposing your world view:

“What would the best version of yourself do”?
LIFE
SK
SK
@sk_diary1
Margatha Natarajar murthi - Uthirakosamangai temple near Ramanathapuram,TN
#ArudraDarisanam
Unique Natarajar made of emerlad is abt 6 feet tall.
It is always covered with sandal paste.Only on Thriuvadhirai Star in month Margazhi-Nataraja can be worshipped without sandal paste.


After removing the sandal paste,day long rituals & various abhishekam will be https://t.co/e1Ye8DrNWb day Maragatha Nataraja sannandhi will be closed after anointing the murthi with fresh sandal paste.Maragatha Natarajar is covered with sandal paste throughout the year


as Emerald has scientific property of its molecules getting disturbed when exposed to light/water/sound.This is an ancient Shiva temple considered to be 3000 years old -believed to be where Bhagwan Shiva gave Veda gyaana to Parvati Devi.This temple has some stunning sculptures.
ALL
Advertisement
\u0936\u094d\u0930\u0940\u092e\u093e\u0932\u0940 \u0939\u093f\u0924\u0947\u0936 \u0905\u0935\u0938\u094d\u0925\u0940
श्रीमाली हितेश अवस्थी...
@HiteshAwasthi89
#Thread
Lessor known facts of Sudarshan Chakra or Neela Chakra of Puri Jagannath Temple.

The metal wheel at the top of Bhagwan Jagannath temple is also known as Neela Chakra (Blue Wheel). The wheel is made of eight metals comprising of.. 1/n


iron, copper, zinc, mercury, lead, brass, silver & gold. It's circumferance is about 36 feet & it is so designed that there is a wheel within the wheel. The circumferance of the inner wheel is about 26 feet. Eight hubs join together the inner and the outer wheels. 2/n


There are decorative designs on the outer wheel. The thickness of the Neela Chakra is 2 inches.The wheel is said to be Bhagwan Vishnu's most powerful weapon, Sudarshana Chakra. Inside Jagannath temple, Lord Vishnu's wheel is also worshipped in the name of 'Sudarshana'. 3/n


But inside the temple Sudarshana is not in the shape of a wheel, but in the shape of a small wood pillar placed to the left of image of bhagwan Jagannath. It is believed that the same Sudarshana is also at the top of the temple and is known by the name of Neela Chakra. 4/n


There is a specific category of people among the temple sevaks to serve the Neela Chakra and they are known as Garuda Sevaka or Chunara Nejoga. The pilgrims hold these sevaks in high esteem because everyday at Sunset. 5/n
ALL
Delilah S. Dawson
Delilah S. Dawson
@DelilahSDawson
So here is a secret: Not everything I write goes anywhere. I have at least 4 books completely written and edited that never went on submission. I have books that stalled out at 20k. I have docs on my computer with opening paragraphs I don't remember writing. But! 1/

Every now and then an idea sticks with me like that corner of tortilla chip that just won't go down your throat. It happened with SPARROWHAWK, which began as 40k of a YA story, died, and was reborn as a comic, thanks to @christopher_j_r and @boomstudios. And now... 2/

It's happening with THE WILLOWS, a short story that you'll see in @UncannyMagazine next year. This Southern Gothic horror story began as an attempt to sell my next Romance to @AbZurdity after the Blud books in 2014 or so. And she didn't buy it. Guess why? 3/

Turns out, it wasn't a Romance! It was Southern Gothic Horror. Even the bones of it screamed strangeness, not sexiness. I loved the taste of the world, but I hadn't found the right story yet. Tried to write it 2 more times and failed. Until I finally understood what it was. 4/

So I took the 50 pages I'd written and cut half of them, twisting the story around from a gothy Romance inspired by the band the Civil Wars and turned it into a spooky descent into madness. And it looked back at me from the abyss as if to say, DUH. Sometimes... 5/
WRITING
Khatvaanga
Khatvaanga
@khatvaanga
Sri Gurubhyo Namaha.


After the phenomenon called Sri Chandrasekhara Bharati came another one - Sri Abhinava Vidya Teertha [1954-1989] the 35th Jagadguru. Srinivasa was born on Nov 13, 1917. He was initiated into Sanyasa by Sri Chandrasekhara Bharati in 1931. He was Jagadguru for 35 years.

He was chosen and specifically trained to take over Peetadhipatyam from Sri Mahaswami. He is majorly responsible for the way Sringeri currently is. He built various buildings for devotees, Gajashala, Gooshala etc.

Acharya on conversions:
Once a person approached Sri Acharya that some other religions are trying to convert Hindus and requested Sri AVT to do prevent these conversions.

AVT replied - what do u mean by religion? Religion i.e. mata is related to 'mati' or intellect.
Caste is called 'jAti' which is related to janana or birth.
Ex- breed of a cow. we cannot change its qualities to resemble another breed by changing its name.
ALL