Your Guide To The Stock Market
Stock market Excel templates, portfolio trackers, and spreadsheet-based trading and investing tools.
Understanding the world of stocks can be tough, especially for newcomers. To many, it may seem like navigating through uncharted territory! But here’s the good news – you don’t need a finance degree or years of Wall Street experience to become a successful investor. With the proper tools and knowledge at your disposal, you can … Read more
Introduction In my previous post on Quandl (now Nasdaq Data Link) linking with AmiBroker, I discussed how to download free end-of-day data for Amibroker. In this post, we will discuss how to download Quandl stock data and use it to create an Excel stock research system quickly. Download Quandl Excel Add-In The first step is … Read more
Introduction Nowadays, many major stockbrokers provide the facility to connect their trading terminals to Microsoft Excel. This is because you can create robust trading systems in Excel by writing your own formulas. If you can get live data for free in Microsoft Excel, your job becomes easier. Already we have seen how to get data … Read more
Zerodha’s Pi platform contains 120 days of continuous intraday data. This continuous intraday data is also called IEOD. IEOD is the short form of Intra-EOD. This means it’s Intraday (I) real-time quotes but you get access to it only end of the day (EOD). But this IEOD data is specifically helpful if you want to … Read more
A few days back, I wrote a post on getting market feeds from Sharekhan TradeTiger to Excel, which received a great response from my readers. Since then, I have received numerous requests from my Zerodha clients on how to create a similar Excel trading system by connecting Zerodha Pi to Excel. In this post, I … Read more
In this post, I will show you how you can create a highly accurate intraday trading Excel sheet from the Sharekhan TradeTiger terminal. TradeTiger is Sharekhan’s desktop trading app. We will first download live data in Excel from the Sharekhan Trade Tiger terminal and later we will apply a formula for the intraday trading system … Read more