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"
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.
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...
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...
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: