Excel free tool for Point & Figure (P&F) charting

Reposting as the link has been updated through dropbox link.

This is a little contribution from my side. Over the years, I have developed this point and figure software. Standard softwares in the market are costing around $25 - $150, but this excel-based software is free of cost.

Features of this software:

• Simple excel-based software; does not require any installation
• Can draw on both High-Low price method & Close price method
• Can follow a wyckoff method of plotting for 1-point reversal
• Scales can be altered, rounded off as per trader's preference
• Automatic data retrieval from http://finance.yahoo.com/
• Manual data can also be used
• Any box-reversal is possible
• Charts can be used for any time-frame data
• Change in month is identified in the chart itself
• Suggests suitable block-size for the available data-set
• And many more for you to explore ...

Acknowledgement:

• Some person in some forum had shared a base-level code. But it was quite faulty both fundamentally & technically. I don't remember that person's name. But I sincerely thank that person for having made this work possible.
• Also I thank my e-Guru, iLango, for inspiring me to do the act of sharing to the trading community.

The link to download the file can be accessed from this link here.

Free P&F Tool Update - with % price based logarithmic scaling

It gives me immense pleasure to share with you that I've upgraded my tool to incorporate % based logarithmic scaling. This was perhaps one of the important features that was not available in the tool.

Benefits:

• Flexibility to plot long-range data.
• No need to maintain a table of price-box mapping
• Can play short, medium & long-term easily from the chart.

Link for Download

Available in the Download Link on the blog.

Direct Link:
http://www.4shared.com/office/66YAQxZ8/p_fchart_free.html

Instructions:

• Go to chart sheet
• In the cell C4 (left side of "Scale Multiple"), there are two values in the drill down - L (Logarithmic) & N (Natural)
• For L
• The "Block Size" (cell E2) should be mentioned in decimal (i.e. 10% = 0.1, 1% = 0.01, 0.5% = 0.005 etc.)
• The ScaleM will not work here. So leave it at 1. Don't try to alter it to get surprises.
• For N
• As earlier, the "Block Size" (cell E2) should be mentioned in the box amount (e.g. 2, 10, 100 etc.)
• The ScaleM will work here, so if you want in the multiple of 5 or 10, put them likely.

I hope with this you become more rich in your trading & finance.

For further reading on P&F setting (including scaling), you can refer here:
http://stockcharts.com/school/doku.php?id=chart_school:chart_analysis:pnf_charts:pnf_scale_time

Note:

I expect the users of this tool to be necessarily savy with basic Microsoft Excel skills. So don't expect any manual on this tool from me. If you have any specific query on the usage of the tool, you can always ask me on this blog (preferably in the latest post, as I rarely visit my old posts).

Credit:

This development was possible because a gentleman called Mr. Praveen Pentakota brought this requirement to my notice. Thanks a lot Praveen.

Nifty P&F (Wk 1811-2211) - Short-term resistance ahead, long term looks good! A New release of the tool coming soon!

Recap:

Was grossly wrong in gauging the market. It was 6000 & not 6100!

Summary:

Weekly chart is still quite strong! Daily is down with a pullback & some immediate resistance lined up till 6186.

Weekly chart is showing significant accumulation with repeated attempts of new highs. I'm somehow of the opinion that the current stage is simple pullback.

Note:

Please see this post does not have any chart because I'm working on my excel tool to incorporate a % based scaling (semi-log) & expect to share with you all very soon.

Thanks to Praveen Pentakota, who brought this requirement to me. I also got a copy of Heinrich Weber & Kermiet Zieg, suggested by Praveen, and after completing the book, I realize that it's a necessity to have this scaling facility in a P&F tool.

So expect this tool to be available very soon!

Nifty P&F (Wk 3001-0302) - Expecting a top here and a pullback to 4980!

Recap:

Weekly target 5180 reached, the channel target (refer the chart below).

Weekly Analysis:

Daily Analysis:

Summary:

Weekly UP. Daily UP. However, a channel top, 78% retracement, 4.23% price extension - suggesting an immediate top. This pullback from the top should be resisted near 4980 level.

Note: The new p_fchart_free.xls is available in the DOWNLOAD LINK section with much more flexibility of creating P&F charts (refer previsous post for details).

P&F Software Excel based - free

This is a little contribution from my side. Over the years, I have developed this point and figure software. Standard softwares in the market are costing around $25 - $150, but this excel-based software is free of cost.

Features of this software:

• Simple excel-based software; does not require any installation
• Can draw on both High-Low price method & Close price method
• Can follow a wyckoff method of plotting for 1-point reversal
• Scales can be altered, rounded off as per trader's preference
• Automatic data retrieval from http://finance.yahoo.com/
• Manual data can also be used
• Any box-reversal is possible
• Charts can be used for any time-frame data
• Change in month is identified in the chart itself
• Suggests suitable block-size for the available data-set
• And many more for you to explore ...

Acknowledgement:

• Some person in some forum had shared a base-level code. But it was quite faulty both fundamentally & technically. I don't remember that person's name. But I sincerely thank that person for having made this work possible.
• Also I thank my e-Guru, iLango, for inspiring me to do the act of sharing to the trading community.

The link to download the file can be accessed from this link here.