BSE Stocks Historical Price Downloader

Use this Excel tool to download historical prices of all 22,047 scrips listed in the Bombay Stock Exchange (BSE).

This is a companion tool to the S&P BSE Indices Historical Data Downloader (values, PE, PE, Div. Yield) of 27 S&P BSE Indices.)

The scrips are categorised as follows

  • Equity -shares
  • Equity – Institutional Series
  • Debentures and Bonds
  • GOI securities
  • Preference Shares
  • MF – FMPs

You can download the historical price data (along with no of. shares, no. of trades, total turnover) by following 5 simple steps.

read more ...

Mutual Fund Investing: Risk vs. Reward vs. Volatility

Nearly two years ago, one of my personal finance influencers, Ramesh Mangal, cautioned me that there is no clear-cut relationship between risk and reward. Although he had pointed me towards proof of the same, I did not pay much heed to it at that time.

Now after being reasonably comfortable with commonly used risk-return metrics like alpha, beta, Sharpe ratio, Sortino ratio etc. I am beginning to understand what he meant.

read more ...

Young Earners: Do not invest Rs. 1.5 Lakh in PPF!

In the previous post in the ‘young earner’ series, I had listed down a set of personal finance essentials. Two points appear to have caught the eye of many readers.

  1. Do not open a PPF account
  2. Do not start a SIP in an ELSS fund

In this post I would like to expound on the first point. But first, a quick look at the second.

Do not start a SIP in an ELSS fund because each instalment will be lock-in for 3 years. Instead, open an account with an AMC, and invest every few months, on market dips, if possible.

read more ...

How Do Arbitrage Mutual Funds Work?

Arbitrage mutual funds have suddenly been thrust into the spotlight after the recommendations of Budget 2014, which adversely affected investors in debt mutual funds.

They would now have to wait 3 years to apply indexation benefits to their capital gains from debt funds. For durations below or equal to three years, gains will be added to income and taxed as per slab.

Arbitrage Mutual Funds

A hitherto unknown and not-so-well understood class of mutual funds is now in the spotlight for two reasons.

read more ...

Personal Finance Essentials For Young Earners

I am a ‘zero’ when it comes to personal finance! Where do I start? I would like to change my attitude towards money and my financial status. Please point me to a good blog or book.

If these statements reflects the state of your mind or if you know people who feel that way, here is a list of personal finance essentials for you or your contacts to work on.

Credits: This post is based on emails, comments on blog and in facebook group Asan Ideas for Wealth and encouragement from Ms. Charulatha Varadarajan.

read more ...

Related Posts Plugin for WordPress, Blogger...