Wednesday, January 7, 2015

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.

24 comments:

  1. Thanks 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
  2. @Liam,
    Welcome.

    @dinesh,
    OHLC sheet is not locked. You can change the data there. Let me know, if you still face issue.

    ReplyDelete
  3. Thank you for making this excellent charting tool available. It is very useful.

    What do symbols R, P, M and S stand for?

    Vinay

    ReplyDelete
  4. @Vinay,

    Thanks 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

    ReplyDelete
    Replies
    1. Thanks.

      I 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

      Delete
  5. @ Vinay,

    Nice 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

    ReplyDelete
  6. Is it possible to change the day timeframe to 30 min data?or how to edit?

    ReplyDelete
  7. @Selvan Raj,

    This 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

    ReplyDelete
  8. 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.

    ReplyDelete
  9. Well if the excel software is free and accurate too than I am gonna use this in my trading strategies.

    ReplyDelete
  10. Do I need to use the same using forex tips too or is it okey without this.

    ReplyDelete
  11. With this simple software and also KLSE Stock Analysis, I am able to give sure shot calls.

    ReplyDelete
  12. Hi, 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?

    ReplyDelete
    Replies
    1. Hi Yan,

      On 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

      Delete
  13. i change block size to 1 on spy, it shows only a few blocks

    ReplyDelete
  14. Hi Yan,

    Thanks 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

    ReplyDelete
  15. This comment has been removed by the author.

    ReplyDelete
    Replies
    1. Were you able to get the password? If so can you share it with me?

      Delete
  16. Thanks for giving important information to training seekers,Keep posting useful information,Click below to find

    NSE ACCOUNT

    ReplyDelete
  17. Can anyone tell me what the R S & M letters mean?

    ReplyDelete
    Replies
    1. R = Resistance
      P = Pivot
      S = Support

      Delete
  18. hello sir,
    please give me brief content and knowledge about point and figure chart and
    how can I read your chart, please

    ReplyDelete
  19. Axis Bank Q1 profit down 21% as provisions up 89%; NPA worsens
    CapitalStars

    ReplyDelete