I, Mahesh Chander Kaushik, am a NISM Certified SEBI Registered Research Analyst (Reg. No. INH 100000908). I provide free stock market education through my blog, YouTube channel, and books. I do not give stock tips or offer any paid courses. Therefore, please do not make any payments to anyone in my name.
Stocks Historical Data Download in Excel किसी स्टाॅक के हिस्टोरीकल डाटा को ऐक्सेल फाईल के रूप में कैसे डाउनलोड करें।
साथियो नमस्कार,
Namaskar Friends
किसी स्टाॅक के डाटा पर रिसर्च करने के लिये हमें उस स्टाॅक के डाटा को ऐक्सेल में डाउनलोड करने की आवश्यकता होती है।
To research a stock's data, we need to download that stock's data into Excel.
हालांकि एनएसई की वेबसाईट के नये डिजाईन में अभी भी स्टाॅक के हिस्टोरीकल डाटा को डाउनलोड करने का लिंक दिया है जिसको यह लिंक नहीं मिल रहा है वो निम्न वीडियो से देखकर सीख सकते हैं कि किसी स्टाॅक के हिस्टोरीकल डाटा को डाउनलोड करने के लिये लिंक एनएसई की साईट पर कहां मिलता है-
However, the new design of the NSE website still provides the link to download the historical data of a stock. Those who are unable to find this link can watch the following video to learn where the link to download a stock's historical data is located on the NSE site.:-
इसमें एनएसई से डाटा डाउनलोड करने में बहुत सी समस्याएं सामने आती है जैसे एनएसई 1 साल से ज्यादा के डाटा को ऐक्सेल में डाउनलोड नहीं करने देती। इसमें हमें यदि 7 साल के डाटा चाहिए तो 7 अलग अलग ऐक्सेल फाईलें डाउनलोड करके फिर एक फाईल में डाटा काॅपी पेस्ट करना पड़ता है इस पूरी प्रक्रिया में लगभग 2 घंटें लग जाते है जो बहुत ही श्रमसाध्य कार्य है।
In this process, several issues arise when downloading data from the NSE; for instance, the NSE does not allow downloading more than one year of data into Excel at once. If we need seven years of data, we have to download seven separate Excel files and then copy-paste the data into a single file. This entire process takes about two hours and is a very laborious task.
इसके विकल्प के रूप में याहू फायनेंस से एक साथ हिस्टोरीकल डाटा ऐक्सेल फाईल में मैक्रो फार्मूला लगाकर कर सकते हैं। इसके लिये मैने ऐक्सेल की मैक्रो वाली फाईल बनायी है ऐसा दावा मैं नहीं करूंगा क्यो कि ईमानदारी सबसे अच्छी पाॅलिसी है मैं झूठा क्रेडिट नहीं लूगा मैने जो ऐक्सेल फाईल उक्त वीडियो में प्रयोग की है वो मैने इस वेबसाईट से डाउनलोड की हैः-
As an alternative, historical data can be pulled from Yahoo Finance all at once by using a Macro formula in an Excel file. I will not claim that I created this Excel Macro file myself, because honesty is the best policy and I won't take false credit. The Excel file I used in the aforementioned video was downloaded from this website:-
ध्यान रहे उक्त वेबसाईट से मेरा कोई काॅलोबरेशन नहीं है। मैं इन्टरनेट से सर्च करके ही इस वेबसाईट तक पहुंचा हूं अतः कोई भी फाईल अपनी रिस्क पर उक्त वेबसाईट से डाउनलोड करें मुझे तो कोई समस्या नहीं आयी है।
Please note that I have no collaboration with the said website. I reached this site simply by searching the internet; therefore, download any file from there at your own risk. I personally did not encounter any issues.
ज्यादा जानकारी के लिये निफ्टी की दुकान के वीडियो पहले भाग से देखें इसके पूरे कोर्स की प्लेलिस्ट का लिंक निम्न हैः-
Nice article, very informative and clearly explained. The way you described the topic makes it easy for readers to understand. Online games are becoming popular day by day because of easy access and entertainment value. You can also check Gamo.
I recently read this Book - How Chandu Earned and Chinki Lost in the Stock Market.
Very simple to read and understand. I picked the initial Version, where the English & Grammar could've been better. I hope it's corrected in the later Versions.
Loved the 200 SMA System to take Buy / Sell decisions. I've a couple questions for you, Mahesh Sir -
1. Is this System applicable only for Stocks, or is it equally applicable for REITs & InvITs, and ETFs - Any ETF that either Index-based, or Commodity-based, etc.? 2. If it works, then even for these should we consider the multiples of 5, or any other number?
disclaimer:-Trading in stock market is very risky. This website is not perfect. This is not an advisory service to buy or sell. The contents of “maheshkaushik.com” are only for educational purposes. No liability is accepted for any content in “www.maheshkaushik.com”. Subject to pindwara(india) jurisdiction only.The author is neither a registered stockbroker nor a registered advisor and does not give investment advice.. While he believes his statements to be true, they always depend on the reliability of his own credible sources. The author recommends that you consult with a qualified investment advisor, one licensed by appropriate regulatory agencies in your legal jurisdiction, author of this website is not a trend technical analyst.
great efforts sir, good day
ReplyDeleteThanks for your efforts
ReplyDeleteThank you sir
ReplyDeleteThanks
ReplyDeleteThank you
ReplyDeleteThank you sir
ReplyDeleteNice article, very informative and clearly explained. The way you described the topic makes it easy for readers to understand. Online games are becoming popular day by day because of easy access and entertainment value. You can also check Gamo.
ReplyDeleteHi Sir,
ReplyDeleteI recently read this Book - How Chandu Earned and Chinki Lost in the Stock Market.
Very simple to read and understand. I picked the initial Version, where the English & Grammar could've been better. I hope it's corrected in the later Versions.
Loved the 200 SMA System to take Buy / Sell decisions. I've a couple questions for you, Mahesh Sir -
1. Is this System applicable only for Stocks, or is it equally applicable for REITs & InvITs, and ETFs - Any ETF that either Index-based, or Commodity-based, etc.?
2. If it works, then even for these should we consider the multiples of 5, or any other number?
I hope you clarify these questions, Mahesh Sir.
Regards,
Ram Kumar Rama Krishnan