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 ...
- 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.
Thanks for the download link!
ReplyDeleteThanks for the download link. could you render your kind advise how to amend data in the file as the same is locked(appears to)
ReplyDelete@Liam,
ReplyDeleteWelcome.
@dinesh,
OHLC sheet is not locked. You can change the data there. Let me know, if you still face issue.
Thank you for making this excellent charting tool available. It is very useful.
ReplyDeleteWhat do symbols R, P, M and S stand for?
Vinay
@Vinay,
ReplyDeleteThanks for the appreciation. Very few people follow P&F today, let me know if you trade using P&F. I can learn something from you also.
R - resistance
P - Pivot
M - Median
S - Support
I use them mostly from intraday point of view.
Regards,
Rajib
Thanks.
DeleteI just learnt to use PnF charts in the last 3-4 months. I usually trade using candle sticks and bollinger bands. I am trying to develop a system based on PnF, buying at the first reversal to X's and selling at the first reversal to O's for a Bullish Trending stock with strong fundamentals. I only trade on Weekly basis. I filter stocks that enter a bollinger squeeze (last 6 months) for trading.
What is your opinion on buying and selling on X and O reversals?
Vinay
@ Vinay,
ReplyDeleteNice to know your method. Interesting.
I genreally trade the way I show in the nifty charts. I'm always looking at the BlSL (Bullish Support Line) to buy with SL below the SL & sell when a sell signal generates. This helps me enter at 2-3 points SL, but the drawback is often the exit is late giving away a majority of the profit. But the ones that click, often run multi-bagger!
Regards,
Rajib
Is it possible to change the day timeframe to 30 min data?or how to edit?
ReplyDelete@Selvan Raj,
ReplyDeleteThis tool can fetch data only from yahoo server. However, in the datasheet you can put any time frame data the chart will draw it. So if you have 30 mins data somewhere, you can copy paste the same in the data & it will draw the chart.
Regards,
Rajib
i want to backtest in 30 min data.but the chart draw for certain limited period?how can i change it?can you send the passward to change it?advance thanks.
ReplyDeleteWell if the excel software is free and accurate too than I am gonna use this in my trading strategies.
ReplyDeleteDo I need to use the same using forex tips too or is it okey without this.
ReplyDeleteWith this simple software and also KLSE Stock Analysis, I am able to give sure shot calls.
ReplyDeleteHi, Raj, I try to use your free version PF chart, for example, I want to draw spy 1 reversal chart, how to define block size? what is scale multiple?
ReplyDeleteHi Yan,
DeleteOn Chart page, in Reversal, you can set it to 1. Block size are of two types Log or Normal. If log & you want 1% box size so you put 0.01; but if you want Normal you can put 5 / 10 / 100 whatever based on your price level. Log or Normal can be selected from cell C4.
Hope that helps. & Sorry for the delay in response.
Regards
i change block size to 1 on spy, it shows only a few blocks
ReplyDeleteHi Yan,
ReplyDeleteThanks for using the tool.
The scale needs to be changed from L(Logarithmic) to N(Normal). And this will work.
Let me know, if you could resolve it.
Regards,
Rajib
This comment has been removed by the author.
ReplyDeleteWere you able to get the password? If so can you share it with me?
DeleteThanks for giving important information to training seekers,Keep posting useful information,Click below to find
ReplyDeleteNSE ACCOUNT
Can anyone tell me what the R S & M letters mean?
ReplyDeleteR = Resistance
DeleteP = Pivot
S = Support
hello sir,
ReplyDeleteplease give me brief content and knowledge about point and figure chart and
how can I read your chart, please
Axis Bank Q1 profit down 21% as provisions up 89%; NPA worsens
ReplyDeleteCapitalStars
Hello sir, where can I find the link to your excel-file?
ReplyDeletethe fiile conatins a trojan
ReplyDeleteVery good article,Thank you
ReplyDeleteFor sofa repair service contact thesofastore they gives Sofa Refurbishing in Yelahanka
Such a great post, thanks for posting this kind of useful information.
ReplyDeleteVisit Vashikaran Specialist in Jayanagar
How can I contact you?
ReplyDeleteI hope you come back again
ReplyDeleteI tried to reach you, but your friends gave negative feedback.
ReplyDeleteI have some useful advice.
I need to tell you some important points about the chart structure and this way your success rate will be very high in percentage terms.
I know that as it stands now, there's a chance you'll get false buy signals.
ReplyDeleteI want to tell you about this because this beautiful software needs to work much more smoothly.
The traditional method should not be used anyway.
The logarithmic system needs to be used and this is where the problem begins.
I'm sure you got the wrong buy signals.
There's a reason I specifically mention buy signals.