Analysis on Nifty with Gann technique

VN:F [1.8.7_1070]
Rating: 5.0/5 (1 vote cast)

The objective of any kind of analysis is to present better understanding of underlying trend of stock or index. There are plenty of techniques available to study the trends of stocks or other related markets.  Every kind of technical analysis presents unique way of understanding things, but each comes up with different annoying tags like “un-certainty”, “hard to implement”, ”not always reliable”, “false signals” or “too broad”.

Well, we don’t have a technique or indicator that directly points you to holy-grail of stock markets. But there must be something, which is better than rest.  Yes, there are such techniques.

Today, we are going to look at one of such technique. We will practically implement one of Gann technique, on National Stock Exchange S&P CNX Nifty index and check how it works.

Gann Techniques

In stock markets, few people know Gann techniques and very few implemented it. But till date, Gann’s techniques remain most accurate, stunning and reliable for “some people”. Let’s check whether it is same for us or not. But, before we jump on to chart, we need to understand few things, here are they.

By the way, if you want to know more about Gann or his analysis, check wikipedia article

Gann line

In Gann’s world, trend lines are not mere static lines. What does it mean?
You can’t have a concrete line drawn either from top or low of market turns, and wait for markets to seriously react to those lines. Why? The reason is simple, normal trend line considers price level only, not time factor.

Gann lines changes its price level as the time progress, step by step. This step is nothing but frequency of that stock. Yes, some call it “Raise”.

Frequency of stock

According to Gann, each stock (even index) vibrates at certain frequency, and reacts in multiple units of its frequency.
Well, it is hard to identify such frequency basing on such an abstract statement. Don’t worry, our studies showing that S&P CNX Nifty is reasonably responding to “frequency 1”, at least on long term charts.

How to draw lines

Gann lines must be drawn from extreme highs or lows of market.  More extreme, more the significant result.

What can be an extreme low?  Simple, nothing is lower than all time low. So, let’s consider Nifty all time low 775.43 on 04 December 1996. From this point, we need to draw a line, which rises at certain frequency. In our case, it is 1 point per day.

Yes, read the line once again, there is logic. Our line raises its price value one per day (trading day). So on 05 December 1996, our line must be at 776.43 (775.43 + 1). On 06 December 1996, it should be on 777.43.

We know, famous technical analysis software titles won’t work here as you have expected. But you can rely on excel sheet or any spreadsheet.

More lines

The line we have drawn just now is called 1×1, in other words one 1 unit of frequency at 1 Unit of time.
We also want to draw two more lines.

  • 2×1 line, 2 units of frequency X 1 unit of time (one trading day).
  • 1×2 line, 1 unit of frequency X 2 units of time.

Confused? Here is much better explanation.

  • 1×1 line, grows at 1 point per day
  • 2×1 line, grows at 2 points per day
  • 1×2 line grows at 1 point per 2 days, or 0.5 point per day.

Observations

Gann lines on NSE Nifty

Gann lines on NSE Nifty

Gann lines on NSE Nifty -zoomed in

Gann lines on NSE Nifty -zoomed in

Look at charts, after long bull market rally (on 8 January 2008, approximately 2777 trading days), our 2×1 line stands at 6327.43. Nifty slightly penetrated and reacted and hit resistance at 6357.10. (All time high, so far)
Confused? Here is simple math.

Start value + (Days count * 2 units of frequency per day)
775.43 + (2777 * 2)

Again, look at charts, after bear market rally (on 27 October 2008, approximately 2974 trading days), our 1×2 line stands at 2262.43. Nifty slightly penetrated and reacted and took support at 2252.75 (2008 bear market low)

775.43 + (2974 * 0.5)

Again, look at chart, after 2009 general election rally and reaction (on 13 July 2009, approximately 3142 trading days), our 1×1 line stands at 3917.43. Nifty took support just one point above it, 3918.75

775.43 + (3142 * 1)

Conclusion

Wow, results are stunning and significant. However, we are not just limited to those few lines, we can always draw more lines, experiment with different frequecies. Also, you can draw lines from top instead of bottom. If lines are from top, rather than going up, lines should go down (decrease in points, per time unit).

We will try to understand more stock market analysis techniques, as we move on. Meanwhile, experiment with data and let us know what you find. :)

VN:F [1.8.7_1070]
Rating: 5.0/5 (1 vote cast)
Posted in Analysis, Featured | Tagged , , , , | 5 Comments

A look at Highest NAV guarantee plans

VN:F [1.8.7_1070]
Rating: 5.0/5 (1 vote cast)

Highest NAV guarantee plans

Have the recent ads about Highest NAV on TVs and hoardings captured your attention?  Highest Net Asset Value guaranteed Plans are the flavor of the season. Many insurance companies are offering these products.

Is it possible to get best returns with the Highest Net  Asset Value guaranteed plans?  Just check out.

Birla Sunlife Platinum Plus III, SBI Life Smart ULIP, Tata AIG Invest Assure Apex, Bajaj Allianz Max Gain, Reliance Highest Net Asset Value Guarantee Plan, LIC Wealth plus are some of the products that are available under this segment in the market. More or less all these plans have similar features and costs.

What they offer?

These are basically Unit Linked Insurance Plans akin to the regular ULIPs with an additional feature that guarantees Highest Net Asset Value during the term of the policy.

They all have limited premium paying term of 3 years with insurance protection up to 10 years and LIC Wealth Plus is of 8 years only. Minimum sum assured is five times the annual premium.

All these plans promise to pay the Highest NAV reached in the first 7 years of their term 10 years or the NAV at the end of the maturity date whichever is higher. The Net asset value calculation will be based on daily basis.
Highest Net Asset Value guaranteed Plans are capital guarantee products hence there is no worry of losing capital.

How they invest?

Highest NAV guaranteed Plans invest in debt and equity in the range of 0-100 percent. These products use Constant Protection Portfolio Insurance, CPPI kind of strategies to protect the capital. The portfolio will be managed dynamically between equity and debt such that the highest NAV achieved is locked by shifting a portion of equity into debt. Thus final or maturity value is equal to the highest net asset value achieved so far.

Will they deliver?

The insurance companies that offer the funds claim that investors stand to benefit with these plans as they get the upside of equities and the surety of capital protection. So the retail investor may think of his returns will be on par with the Sensex and Nifty.

Let us see an example, a fund has recorded a highest NAV of Rs 40 in the sixth year after the scheme has commenced. From then onwards the fund must have to maintain the minimum NAV at Rs 40.

Assume that a correction has occurred in the markets and the NAV falls down to Rs 20.

As this is a Highest Net Asset Value guaranteed Plan, the company must have to pay the balance value of Rs 20 (the highest NAV achieved so far less the NAV by the end of maturity which is Rs 40-Rs 20) from its own kitty as it promised.  No company will dare to take the risk of such a heavy loss.

To prevent such adverse conditions, the fund manager starts giving more exposure to debt than equity.
In fact the fund manager doesn’t wait till the sixth year, as mentioned in the above example. He starts converting whatever the returns that he got from the equity into debt from the first year itself.

As said above, equity assets will be converted into debt. The reciprocal may not be possible when equity markets fall to move debt funds into equity as the assets locked to assure highest NAV achieved till then.

There is no mention in any of these products about the fund allocation. So nothing can stop the fund manager to have a substantial debt component even in earlier years. Thus an investor may lose the opportunity of growth an equity fund can deliver in such a long period especially in a growing economy like India.

Are they best returns?

Returns should be calculated after deducting the costs. How much the costs involved in the highest Net Asset Value Guaranteed plans constitute to? With fund management fee, policy administration charges, guarantee charges etc. the costs escalate to 3%.

Average returns on long term equity plans are around 12-15%. Net returns after the costs will be 9-12%. As these funds will have most allocation to debt, it would minimize the returns to somewhere around 7-10%.

Debt funds average return is 6-7%, with fewer costs. More or less the returns on these highest Net Asset Value Guaranteed plans would be on par with debt plans.

Where is the point of waiting for such a long period while investing in equity funds for meager returns?
If you take into account the inflation rate of 6% (2004-2009 average inflation rate, also the days ahead are high inflation prone), the returns are almost zero.

These are the figures calculated assuming the policy holder will stick to the complete term till the maturity. If not the highest NAV guarantee is not his cake. He will be paid the prevailing NAV if he exits after 5 years, if it is before 5 years he should have to bear surrender charges also.

So the solution should be to go for a term insurance, as it is very cheap and ELSS to attain tax saving and reasonable returns.

VN:F [1.8.7_1070]
Rating: 5.0/5 (1 vote cast)
Posted in Featured, Mutual funds | Tagged , , , | Leave a comment

NSE Bhavcopy to Metastock converter – Free

VN:F [1.8.7_1070]
Rating: 4.3/5 (3 votes cast)

Holla! the wait is over. Finally we have a Bhavcopy downloader cum Metastock conversion utility, for free.

What is it

It is a simple utility (exe file), that downloads NSE bhavcopy and converts downloaded data to Metastock format. Whats more, it maintains previously downaloded data and merges new data to that. So your data is always upto date, and you don’t loose historical data.

What’s more

  • You will have your own data collection utility for Metastock or technical analysis application that is compatable with Metastock.
  • You don’t have visit any website or request anybody. Its in your system.
  • You don’t have to pay money to anybody. Its free.

What’s the catch

There is no catch. Its absolutely free. Use it and just let us know if you like it. :)

How to use it

  1. Download Kakup utility (Note: you have to create account. Its free)
  2. Copy it anywhare ( Keep it simple, copy it to C:\ )
  3. Goto command prompt and execute it by typing kakup.exe. (you will get help)
  4. Thats all.

Configuration

If you are using this utility for the first time, you need to create a certain folder structure in your drive C:\

Here are they:

Create folder called kakup in C:\
Create folder called eod in C:\kakup
Create folder called nse in C:\kakup\eod

So, you will have a folder structure like this: C:\kakup\eod\nse. This is where the utility create Metastock files.

How to download data

  1. Go to command prompt (Goto Start > Run and type “CMD”)
  2. Change directory to locate utilty
  3. type kakup.exe ( to see help)
  4. type kakup.exe 20100310 (to download the data for 2010 MAR 10)
  5. Thats all.

What data it downloads

It downloads entire NSE stocks data for a given day, along with Nifty Index data. We are planning to add more indexes to the list, but that’s all for now.

VN:F [1.8.7_1070]
Rating: 4.3/5 (3 votes cast)
Posted in End of Day, Featured, Metastock format, NSE Data | 8 Comments

Who benefits from Tax Slabs 2010

VN:F [1.8.7_1070]
Rating: 0.0/5 (0 votes cast)

 

From the new tax slabs, everyone who earns an income of above Rs. 8 lakh would pay a lower tax of Rs. 50,000.  Those who have net taxable income of above Rs 5 lakh paying income tax at the rate of 30% now have to pay 20%. And those in the Rs 3 lakh – Rs 5 lakh bracket have to pay 10% against the 20% from the financial year 2010-11.

What about the lower income group?

Those who earn a taxable income of up to Rs. 3 lakh have been totally ignored. They stand to gain nothing. Earlier they paid a tax of 10% on income above Rs. 1.60 lakh and with the revised slabs too, they continue to do so.

Who stands to gain and how much?

Men

Taxable
Income     FY 2009-10     FY 2010-11          Savings

1,60,000          Nil            Nil              Nil
2,00,000        4,000          4,000              Nil
3,00,000       14,000         14,000              Nil
4,00,000       34,000         24,000           10,000
5,00,000       54,000         34,000           20,000
6,00,000       84,000         54,000           30,000
7,00,000     1,14,000         74,000           40,000
8,00,000     1,44,000         94,000           50,000

Women

Taxable
Income     FY 2009-10      FY 2010-11         Savings

1,90,000          Nil             Nil             Nil
2,00,000        1,000           1,000             Nil
3,00,000       11,000          11,000             Nil
4,00,000       31,000          21,000          10,000
5,00,000       51,000          31,000          20,000
6,00,000       81,000          51,000          30,000
7,00,000     1,11,000          71,000          40,000
8,00,000     1,41,000          91,000          50,000

Senior Citizens

Taxable
Income     FY 2009-10      FY 2010-11          Savings

2,40,000          Nil             Nil              Nil
3,00,000        6,000           6,000              Nil
4,00,000       26,780          16,480           10,300
5,00,000       46,000          26,000           20,000
6,00,000       76,000          46,000           30,000
7,00,000     1,06,000          66,000           40,000
8,00,000     1,36,000          86,000           50,000

To know about the income tax exemption limits, check New Tax Slabs 2010 

Road to DTC

Budget 2010 has created some basic groundwork for the introduction of the Direct Tax Code. The Government appears to be making gradual attempts towards the recommendations made in the DTC. The DTC draft recommended that people with annual income not exceeding 1.6 lakh will not have to pay any tax. For those with an annual income from Rs 1.6 lakh to Rs 10 lakh (Rs 1 million) shall pay tax at 10%; for incomes from Rs 10 lakh to Rs 25 lakh, the tax is 20%, and it is 30% for income exceeding Rs 25 lakh.

There are proposals such as increasing the tax exemption limits to Rs 3 lakh from Rs 1 lakh (additional Rs 20,000 exemption was given for investments in long term infrastructure bonds for the year 201-11), taxing long term and short term capital gains, scrapping of Sec. 54EC bonds, withdrawing the home loan benefits, applying EET on existing investments including EPF, PPF, National Savings Certificate, Senior Citizens Savings Scheme etc.

Finance minister Pranab Mukherjee announced in his budget speech for the FY 2010-11, the wide ranging discussions with stakeholders on Direct Tax Code have been concluded. And the Government is confident that it can implement the DTC from April, 2011.

To know about the income tax exemption limits, check New Tax Slabs 2010

VN:F [1.8.7_1070]
Rating: 0.0/5 (0 votes cast)
Posted in Featured, Tax | Leave a comment

NSE tick data for MAR 2010

VN:F [1.8.7_1070]
Rating: 0.0/5 (0 votes cast)

NSE tick data for the month of March 2010, now available for download. Downloads includes various formats and tick frequcencies. Visit download page, if you need additional instructions on how to download and what to download

 

Following links contain data for month of March 2010.

VN:F [1.8.7_1070]
Rating: 0.0/5 (0 votes cast)
Posted in End of Day, Metastock format, NSE Data | Leave a comment

Get Exemption and Deduction

VN:F [1.8.7_1070]
Rating: 0.0/5 (0 votes cast)

While availing loan benefits, you still entitled to get the HRA exemption.
Many people get confused whether they will get the HRA benefit or not if they already receiving deduction on the repayment of housing loan.

It should be understood that the deduction on home loan and HRA benefits are two different issues under the Income Tax Act, 1961. The tax benefits on home loan and House Rent Allowance can be claimed together by an individual if he fulfills the eligibility criteria on deductions relating to home loan and HRA.
If you are not staying in your own house and residing in a rented one, then you are eligible to get these benefits.

  • HRA benefit
  • Home loan Interest payment under Section 24
  • Home loan Principal repayment under Section 80C

For tax planning, first you need to make sure that you are claiming the HRA exemption to the extent allowed by the IT Act. To calculate HRA exemption
With these benefits you will have another liability that comes along with. Let’s see what that is.
Now, you know you are entitled to get all the benefits even you have your own house. Right?

If you stay at your own house and enjoying the benefits of home loan deduction, then there is no chance for you to get HRA exemption as the house is your own and you cannot rent yourself.
However, you can rent out your own house and claim HRA exemption. This is very much possible and legal. But while you are getting income (in the form of rent) from your own house, you must have to show it in the IT returns, which will increase your tax liability.

In general, the HRA you will get is smaller than the rent you will get for your own house. And also you have to pay rent for another accommodation.

So unless the situation demands it’s safe to live in your own house just by availing the home loan repayment rebates and gives up to claim HRA exemption.

VN:F [1.8.7_1070]
Rating: 0.0/5 (0 votes cast)
Posted in Featured, Tax | Leave a comment

How to calculate HRA excemption

VN:F [1.8.7_1070]
Rating: 0.0/5 (0 votes cast)

HRA, Exemption for the living

HRA is an allowance provided by an employer to his employee. Most of the employees whether government or private have HRA as part of their salary package. In order to get income tax deduction for HRA, you must be paying rent for your accommodation even if you have an own house.

Many have the opinion that whatever rent they pay will be exempted from tax. It’s not true.

 

Remember, if you do not pay any rent or live in your own house, no exemption is available.
House Rent Allowance which comes under Section10 (13A) would be calculated from the least of the following:

  • The actual amount of HRA received, as part of the salary*.
  • 50 percent of salary* for individuals residing in Metros (Delhi, Kolkata, Mumbai or Chennai); 40 percent of salary*, where residential house is situated at any other place.
  • Rent paid minus 10% of salary*.

Here salary means Basic and dearness allowance if any, not the net or gross.

How to determine the exemption

Let’s see an example. Raveendra is working with an MNC and his salary (monthly) details are given below. He is staying in Delhi.

  • HRA received – Rs17,000
  • Basic – Rs36,000
  • Monthly rent – Rs16,000

Now, his exemption will be

  • Actual HRA = Rs 17,000
  • 50% of salary = 50% 36,000 = Rs 18,000
  • Actual rent paid – 10% of salary = Rs 16,000 – (10% of 36,000)
    = 16,000 – 3,600
    = Rs 12,400

Least of the above three, Rs12,400 will be exempted under HRA. The remaining of the HRA (Rs17000-Rs12400=Rs4600) is taxable.

Work place or residence area

For the purpose of HRA calculation, place of residence will be taken into account not place of working. Suppose that you’re working in a plant located in the outskirts of Delhi while residing in New Delhi. So, for the purpose of HRA, your maximum entitlement for tax purpose will be 50% of the basic instead of 40%.

How to claim

  • TDS by your employer
  • Claim tax refund while filing tax return, if you are not able to claim it or your employer not allow.

Rent receipt is important

You will need to keep all your rent receipts since it is the only proof that you are paying rent. HRA exemptions are only available on submission of rent receipts or the rent agreement.
Rent receipt is not necessary, if the HRA is below Rs 3000 per month. If the HRA is below Rs 3000, you don’t need to show the receipt whether you pay more rent than it or less.
Suppose

  • Your HRA is Rs 4000 and the rent you pay is Rs 3000, then the rent receipts are compulsory.
  • If the HRA is Rs 3000 and rent is Rs 4000, then rent receipts are not needed.

You need to submit proof of rent paid through rent receipts, for which only two need to be submitted, one for the beginning of the financial year and one towards the end. It should have a one rupee revenue stamp affixed with the signature of the landlord.

While taking an accommodation on rent/lease, make sure that your owner agrees to provide you with a rent receipt. From tax point of view, you may or may not enter into a written lease agreement but the rent receipts are a must. And also note that you need not provide your owner’s PAN no. in the rent receipt.

While claiming HRA exemption, you will have the option of availing home loan benefits also. For more, check Get Exemption and Deduction

VN:F [1.8.7_1070]
Rating: 0.0/5 (0 votes cast)
Posted in Featured, Tax | 1 Comment

New Tax Slabs 2010

VN:F [1.8.7_1070]
Rating: 0.0/5 (0 votes cast)

Finance minister Pranab Mukherjee has given a big relief to the tax payers by widening the personal income tax slabs. From the year 2010-11, new Income tax rates will be applied for the individual tax payers. For a taxable income of Rs 5,00,000 and Rs 8,00,000, the tax incidence will now come down to 20% from the earlier rate of 30%. That means tax liability will be reduced by 10% for those with incomes between Rs 5,00,000 and Rs 8,00,000. However, the basic slab has remained unchanged for individuals, women and senior citizens.

The new slabs

Men
Upto Rs. 1,60,000/- Nil
Rs. 1,60,001/- to Rs. 5,00,000/- 10 per cent
Rs. 5,00,001/- to Rs. 8,00,000 20 per cent
Above Rs. 8,00,000/- 30 per cent

Women
Upto Rs. 1,90,000/- Nil
Rs. 1,90,001/- to Rs. 5,00,000/- 10 per cent
Rs. 5,00,001/- to Rs. 8,00,000 20 per cent
Above Rs.8,00,000/- 30 per cent

Senior Citizens
Upto Rs. 2,40,000/- Nil
Rs. 2,40,001/- to Rs. 5,00,000/- 10 per cent
Rs. 5,00,001/- to Rs. 8,00,000 20 per cent
Above Rs. 8,00,000/- 30 per cent

In addition to this a 3% educational cess will be levied on the taxable income.

Taxable income is the income that would be subject to tax after an individual claims various exemptions and deductions allowed under the Income Tax Act.

Senior Citizen means a person of age above 65 years.

Tax filing becomes Saral

Life becomes Saral for the salaried class as they not only have more money to spend but can also file returns easily. To ease tax filing pains, the finance ministry is introducing a two page Saral – II forms. This will be beneficial for those who have income only from their employment and property. In case, there is any income from other source, they need to file different forms.

Section 80CCF

A separate Section 80CCF has been introduced for investments. By investing Rs 20,000 in long term infrastructure bonds, one can avail tax deduction. This is in addition to the limit of Rs 1 lakh under Section 80C.

With the changes in the new tax slabs, there is nothing in store for the common man. Then, who benefits ? how much? To know more read Who benefits from Tax Slabs 2010

VN:F [1.8.7_1070]
Rating: 0.0/5 (0 votes cast)
Posted in Featured, Tax | Comments closed

Paying rent to wife

VN:F [1.8.7_1070]
Rating: 0.0/5 (0 votes cast)

Under Income Tax Act, every individual is a different person. Most of the sections in I T act differentiate husband’s income from wife’s income. If that is so, why a husband cannot pay rent to wife?

Wife and husband relationship is not a commercial one. They have to stay together only. In such a case, where is the question of paying rent to one another.

Because of the particular nature of relationship, the onus of proving that the rent has indeed been paid and it has not flown back to the payer from the payee, remains with the claimant. More over the asset (House property) should not be one covered by the provisions of section 64.

Opinions are divided among the tax experts regarding rent paid to the spouse. Some say, it’s acceptable and some it’s not. However, Husband and wife are meant to stay together without a commercial relationship between them.
If you pay her rent and claim the same as HRA deduction, the IT department might treat it as a tax evasion transaction. Taxmen consider this a swindle.

Spouse is working

When husband and wife both are working and get HRA, Only one of them can claim HRA exemption – not both, else both can share the rent paid to the landlord. Thus they can avail only a part of their HRA exemption.
On the other hand, rent paid to the parents is eligible for exemption. If you stay with your parents and pay rent to them then you can claim for tax deductions.

Pay rent to parents

A better option is to pay rent while staying in parents’ house. It is not necessary for you to pay rent to a landlord. It is possible that you live in your parents’ house, in which case, you may pay rent to your parents and consequently be eligible for the HRA deduction.
However, the parent who is issuing the receipts should show this rent income as ‘income from house property’ in his or her income tax filing; otherwise it would become ‘black money’ and may entail litigation with the tax department in future.

It’s not an issue even if they are dependants. In this case, the rent received will be taxable for your parents. however, if their total income is below the taxable limit, the entire transaction would be rendered tax-free.
Similar is the case with Government employees.

Government employees

A government employee, residing in a government accommodation allotted to his/her spouse, is not entitled to get House Rent Allowance (HRA) from the government. i.e., forget about the rebate, the person who is staying in his spouse’s quarters is not eligible to get HRA from the government.

VN:F [1.8.7_1070]
Rating: 0.0/5 (0 votes cast)
Posted in Featured, Tax | Leave a comment

What is your data frequency for technical analysis?

What is your primary data frequency for technical analysis ?

View Results

Loading ... Loading ...
Posted in Miscellaneous | Tagged | Leave a comment

NSE tick data for FEB 2010

VN:F [1.8.7_1070]
Rating: 0.0/5 (0 votes cast)

NSE tick data for the month of February 2010, now available for download. Downloads includes various formats and tick frequcencies. Visit download page, if you need additional instructions on how to download and what to download

 

Following links contain data for month of February 2010.

VN:F [1.8.7_1070]
Rating: 0.0/5 (0 votes cast)
Posted in End of Day, Metastock format, NSE Data | Leave a comment
  • Sponsers

  • Polls

    What is your primary data frequency for technical analysis ?

    View Results

    Loading ... Loading ...