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
Year 2022 has been disastrous for many asset classes, the world economy is at 40 year high inflation. Are we headed for another stock market crash? Here's a detailed analysis. 🧵


Emerging markets like SriLanka is in middle of collapse, which is facing severe depression. World Bank has predicted 70 more countries might default in coming years. With so many negative news, from equity to bitcoin every asset class facing severe sell off across the globe.

Everyone is currently talking about Inflation, rise in oil prices, Russian-Ukraine war and frequent lockdowns in China which is disrupting the supply chain. These are some of the major threats which could slowdown the world economy. But will these cause a stock market crash? No!


author of The Psychology of Money was once said

"The biggest economy risk is what no one is talking about. When no one is talking about it, no one is prepared for it. When no one is prepared for it, damage is too much."

COVID-19 no one in the world expected such a pandemic in the modern world, no one thought we would get locked down, entire world would get shut. This is mother of all surprises, no one was prepared for it.
ALL
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
Advertisement
Kirubakaran Rajendran
Kirubakaran Rajendran
@kirubaakaran
I have shared multiple information related to trading and investing through my historical data analysis by writing various articles, here's the master thread that contains all my work in one place.🧵

https://t.co/pc1jr1xBlI


https://t.co/KZJ1FKCXSp


https://t.co/pTnbkjVpr0


https://t.co/3QXmND1x6Y
THREAD
Kirubakaran Rajendran
Kirubakaran Rajendran
@kirubaakaran
If you are someone who spends more time on analyzing markets during trading, then this for you. Certain traders will create their own bullish or bearish view in their mind but seek confirmation for their trades which is called as confirmation bias. #tradingpsychology 1/15


We do not like people or information that contradicts our thoughts. We like them when they confirm what we think. Hence, we tend to place more weight on information that confirms our trade position. Example- You think market is bullish & wanted to go on a long position,

Next a new bullish bar prints on the chart. You would think "Yes, my bullish proposition is still valid" (even though this bullish bar is smaller range)

A bearish bar prints. But you think "this bar lacks momentum" (because you already have firm belief that market is bullish)

One more bearish bar follows, pushing against a support level. But you would think "the support level is holding" Bullishness confirmed. Buy more! (even though this bar closed below the support level with clear momentum.)
TRADING
Kirubakaran Rajendran
Kirubakaran Rajendran
@kirubaakaran
Earlier many traders were trading based on discretionary without any rules based approach. Now a lot of traders are ready to move to algo trading but confused with a lot of options. When you are bombarded with tons of different trading systems, how do you choose the best one?

Many traders still think winning accuracy is the most important parameter in a trading system. But is it really true? Let's check this example. Consider, we have three different trading systems.
System A,
System B and
System C.


System A has 90% winning accuracy,
System B has 10% winning accuracy and
System C has 50% accuracy.
When given a choice, most traders will opt for System A as it has the highest winning accuracy of all with 90%.

But System A is not the right choice. The average profit in a winning trade is Rs.1000, that is 90% of the time System A is capable of making Rs.1000 profit. But remaining 10% of the time when the system is making a loss, it loses a lot. So after 100 trades, net result is -10,000

System B, The average profit in a winning trade is Rs.10,000, that is 10% of the time System B is capable of making Rs.10K profit, which is ten times higher than its losing trade. The average loss in a losing trade is Rs.1,000 but 90% of the time the system will continue to lose.
ALL

You May Also Like

Billy Bostickson \U0001f3f4\U0001f441&\U0001f441 \U0001f193
Billy Bostickson 🏴👁&👁 ...
@BillyBostickson
Keep dwelling on this:
Further Examination of the Motif near PRRA Reveals Close Structural Similarity to the SEB Superantigen as well as Sequence Similarities to Neurotoxins and a Viral SAg.

The insertion PRRA together with 7 sequentially preceding residues & succeeding R685 (conserved in β-CoVs) form a motif, Y674QTQTNSPRRAR685, homologous to those of neurotoxins from Ophiophagus (cobra) and Bungarus genera, as well as neurotoxin-like regions from three RABV strains

(20) (Fig. 2D). We further noticed that the same segment bears close similarity to the HIV-1 glycoprotein gp120 SAg motif F164 to V174.
https://t.co/EwwJOSa8RK


In (B), the segment S680PPRAR685 including the PRRA insert and highly conserved cleavage site *R685* is shown in van der Waals representation (black labels) and nearby CDR residues of the TCRVβ domain are labeled in blue/white
https://t.co/BsY8BAIzDa


Sequence Identity %
https://t.co/BsY8BAIzDa
Y674 - QTQTNSPRRA - R685
Similar to neurotoxins from Ophiophagus (cobra) & Bungarus genera & neurotoxin-like regions from three RABV strains
T678 - NSPRRA- R685
Superantigenic core, consistently aligned against bacterial or viral SAgs
ALL
Bartosz Ziembinski
Bartosz Ziembinski
@zmbnski
Still wondering about this 🤔


save as q
Q
Advertisement
Shaun Russell
Shaun Russell
@_ShaunRussell
"I really want to break into Product Management"

make products.

"If only someone would tell me how I can get a startup to notice me."

Make Products.

"I guess it's impossible and I'll never break into the industry."

MAKE PRODUCTS.

Courtesy of @edbrisson's wonderful thread on breaking into comics – https://t.co/TgNblNSCBj – here is why the same applies to Product Management, too.


There is no better way of learning the craft of product, or proving your potential to employers, than just doing it.

You do not need anybody's permission. We don't have diplomas, nor doctorates. We can barely agree on a single standard of what a Product Manager is supposed to do.

But – there is at least one blindingly obvious industry consensus – a Product Manager makes Products.

And they don't need to be kept at the exact right temperature, given endless resource, or carefully protected in order to do this.

They find their own way.
TECH
Vibhu Vashisth \U0001f1ee\U0001f1f3
Vibhu Vashisth 🇮🇳...
@VIBHU_Tweet
MAHARAJA CHHATRASAL BUNDELA was the great Bundela King who revolted against the Mughal ruler Aurangzeb.
Chhatrasal Bundela was born in year 1649 CE in Maur Hill of Bundela region to Champat Rai and Lal Kunwar. He was the descendent of Rudra Pratap of Orchha.


His ancesters were the vassals of Mughal Emperor. He drew inspiration from his father and revolted against the alien rule of Mughals. He was just 12 yrs old when his parents died in fight against the Mughal Army of Aurangzeb in 1661.

When his beloved father attained martyrdom in the year 166, the young Chatrasal was present in the last battle of his father against the Mughal and from these valiant campaigns,..

..he gathered the courage to free Bundelkhand from Aurangzeb’s rule.
He joined the Mughals initially, and was recommended by the Rajput King Mirza Jai Singh to be recruited in the Mughal Army in order to support their Deccan Campaigns.


But serving the alien rule of Mughals which brought chaos and misery to Bundelkhand was unacceptable for Chatrasal Bundela and his father’s incessant struggle against the Mughals kept the fire of independent Bundelkhand alive in his heart.
ALL
Jim O'Shaughnessy
Jim O'Shaughnessy
@jposhaughnessy
I’m torn on how to approach the idea of luck. I’m the first to admit that I am one of the luckiest people on the planet. To be born into a prosperous American family in 1960 with smart parents is to start life on third base. The odds against my very existence are astronomical.


I’ve always felt that the luckiest people I know had a talent for recognizing circumstances, not of their own making, that were conducive to a favorable outcome and their ability to quickly take advantage of them.

In other words, dumb luck was just that, it required no awareness on the person’s part, whereas “smart” luck involved awareness followed by action before the circumstances changed.

So, was I “lucky” to be born when I was—nothing I had any control over—and that I came of age just as huge databases and computers were advancing to the point where I could use those tools to write “What Works on Wall Street?” Absolutely.

Was I lucky to start my stock market investments near the peak of interest rates which allowed me to spend the majority of my adult life in a falling rate environment? Yup.
ALL