Point and Figure Chart Excel Sheet

findvikas

Well-Known Member
#1
I have recently started learning Point and Figure chart and found them very much addictive and more powerful than any other form of TA analysis tool.

I found them useful in Swing Trading or Positional Trading, haven't really applied it on Intraday Trading.

I have learned all about PnF chart from various websites and sharing couple of links for your reference to learn more about it.

Links:

PnF Chart Explained by AW10

1) Basics of PnF & How to draw PnF chart by hand

2) PnF Chart Patterns

Now here is an excel sheet that I created to sort of draw PnF chart, basically started this to learn more about PnF and automate the process if I could.

Last Updated: Date: 15/10/2009 , Version: 0.7


Download the file from HERE
http://rapidshare.com/files/321470572/pnf.xls



Usage

1) Go to "Data" sheet
2) Feed in the details, like SYMBOL, START, END, & DATA TYPE
3) Click "Get Data" to download the historical data from Yahoo Servers
4) See the RED BOX for further instructions on symbols
5) Hit "Draw"

IF AUTO DOWNLOADED DOES NOT WORK FOR SOME REASON
1) Open the Excel Sheet and go to Raw Data sheet
2) Navigate to http://www.nseindia.com/content/equities/eq_scriphistdata.htm
3) Fill in the NSE Symbol and Start Date, End Date to get the desired data
4) Copy the table and come to raw table data sheet in excel, right click and paste special, choose "Text"
5) Once inserted... Select only the High & Low of the data (PnF works on High & Low data only)
6) Paste it on the "Data" sheet starting from second row and make sure that first column is High and second is Low
7) Select the box size & reversal value and hit Draw..
8) It will draw the chart and take you to Chart sheet and chart should look some thing like this...
Here is the screen shot of how BHARTIARTL chart is looking since 1st Sep to 10 Oct. 09



Bugs / Known Issues

>>> No OPEN bug at this time


Box size and Reversal size is calculated automatically from now on as you click get data, for sure you can change the value later. I am calculating 1% of average price as box size, while 3% as reversal size. You can change these constant values 1% & 3% from code as they are declared on top

I will keep on updating the Excel sheel on the same link and update this thread whenever I fix something or add something.

Feel free to evaluate and suggest what I might be missing or what you want to see in this.


Change Log:
12/10/2009 - Initial Version uploaded
12/10/2009 - Feature added to automatically download the Historical data from Yahoo Servers
12/10/2009 - Automatically Check for updates of Excel Sheet on startup, prompt to download the latest version
12/10/2009 - Bug fixed which was preventing the correct drawing of chart
13/10/2009 - Data was coming in descending date format, starting from latest date to oldest where as it should have come from oldest date first to latest date as last
13/10/2009 - BUG FIX: Price was not considering the decimal part of it, and was not able to generate charts for less value scrips/penny stocks
15/10/2009 - BUG FIX: It was giving error while running it on Excel 2003 or earlier version
15/10/2009 - LOGIC CHANGE: Now it will automatically calculate the box size & reversal size by 1% & 3% respectively of the average price of scrip in that time frame

Troubleshooting

You need to enable Macros to use this Excel Sheet, by default they are set to High Security and unsigned macros are disabled. To Enable this you need to follow these steps

1) Go to Tools->Macro->Security...



2) Choose Medium or Low (not recommended)



3) Open the sheet and select "Enable Macros" every time you open the sheet.

 
Last edited:

AW10

Well-Known Member
#3
Thanks Vikas for creating this thread and sharing this sheet. You can't imagin how much my analysis time u have reduced with this simple excel sheet.

I used to draw P&F chart by hand at once upon a time.. but gave up later as it was consuming too much time.. But now I am looking forward to update my EOD/ EOWk analysis routine and bring it back.

P&F charts, once we know it, then it is another very simple method to get the Support /Resistence from chart and knock-off all the noise from chart.

Another great book on P&F is "The Definitive Guide to Point and Figure by Jeremy Du Plessis".

Looking forward for more on this topic.

Happy Trading
 

rocky01

Active Member
#4
hey friends you guys need afl for point and figure chart? as in excel sheet it causes much more non qualitative work rather than main work, y to do non quality work more than qualitative work??? if you are interested than tell me.....;)
 

VJAY

Well-Known Member
#5
hey friends you guys need afl for point and figure chart? as in excel sheet it causes much more non qualitative work rather than main work, y to do non quality work more than qualitative work??? if you are interested than tell me.....;)
Dear rocky,
If you have afl and dont mind to share it with others then do it here my friend.....here no one think of qualiative or nonqualiative.....all are helping each other sharing everything in trading......some are qualiative for some one ,some are nonqualiative for some one.....:)
 

AW10

Well-Known Member
#6
you argument will fall on weaker ground if scope of analysis is beyond indian market. If I want to track price of natural gas etf, or BRIC market performance or oil etf which is traded in US/ UK.. USD/INR, USD-GBP, USD-EUR trend, want it from free source.. then you will find the use of this tool.

Tools come with their own limitation and custom build stuff comes with more flexibility.
Depending on individual's requirement, both have their own importance.

Quality or Non-Quality depends on individual.

thats my view.

Happy Trading
 

Similar threads