Point and Figure Chart Excel Sheet

#54
thank you sir for this useful tool. but i never get a connection with yahoo. what can i do.Someone suggest me the pnf chart is very useful if it is drawn using closing price. Kindly reply.
with regards
 

findvikas

Well-Known Member
#56
Thanks findvikas i did it and got perfect chart. now i have to luarn how to drow treand line and analysis. if u can help me. thankes again
Go to stockcharts.com and learn more about PnF Charts and how to use them. AW brother had given a small tutorial kindof post which I linked to the first post so refer to that as well.
 
#59
Hi find vikas,
Brilliant work was looking for something like these since ages.:clap: I would like to suggest the following:
1)The data to be used should be rounded of to rs.1 (bcoz in the current sheets the chart for larsen which is trading around Rs.1650 also shows paise in it)
2)I would also like to ask how does the chart decide about the first columns (whether it is x or o)
3)The box size for traditional p and f charts goes as follows:
• 0 – 5 0.25
• 5 – 20 0.50
• 20 – 100 1
• 100 – 200 2
• 200 – 500 5
• 500 – 1000 10
• 1000 – 2000 20
• 2000 – 5000 50
• 5000 – 10000 100
• 10000 – 20000 200.
 

Similar threads