Point and Figure Chart Excel Sheet

Discussion in 'Technical Analysis' started by findvikas, Oct 12, 2009.

  1. subodh9

    subodh9 Member

    Joined:
    Aug 29, 2008
    Messages:
    83
    Likes Received:
    88
    Trophy Points:
    18
    Location:
    Vadodara
    Dear Vikas,

    I am getteing compilation error on this line please suggest.

    oChartWS.Cells(nChartRowIdx, ColCtr).Font.Color = rgbGreen

    Regards,
    Subodh Apegaonkar
     
    findvikas likes this.
  2. findvikas

    findvikas Well-Known Member

    Joined:
    Jan 31, 2008
    Messages:
    3,347
    Likes Received:
    3,343
    Trophy Points:
    113
    What is the error and Excel's version? anyone else facing similar issue ?

    also what is the Excel Sheet's version that you using?
     
  3. Sunny1

    Sunny1 Well-Known Member

    Joined:
    Mar 21, 2008
    Messages:
    1,284
    Likes Received:
    1,180
    Trophy Points:
    113
    I dont have MS office
    using open office and not able to get data and plot
     
  4. findvikas

    findvikas Well-Known Member

    Joined:
    Jan 31, 2008
    Messages:
    3,347
    Likes Received:
    3,343
    Trophy Points:
    113
    It is not Open Office compatible and I doubt that it will work there as I use VBScript for macro language, I dont think OO support VB Scripting
     
    Sunny1 likes this.
  5. VJAY

    VJAY Well-Known Member

    Joined:
    Jun 16, 2008
    Messages:
    6,239
    Likes Received:
    12,806
    Trophy Points:
    113
    Dear friends,
    for me it working on office 2007......
     
    findvikas likes this.
  6. findvikas

    findvikas Well-Known Member

    Joined:
    Jan 31, 2008
    Messages:
    3,347
    Likes Received:
    3,343
    Trophy Points:
    113
    I havent tested it on 2003 so I am not really sure it works or not... let me try and get back with a fix if it does not work on 2003
     

  7. 4076699

    4076699 Member

    Joined:
    Jan 2, 2008
    Messages:
    75
    Likes Received:
    27
    Trophy Points:
    18
    :thumb:Hi FINDVIKAS, I also wana to learn the system. Any online sourse available? If auto buy/sell signal could be generated with the system, it will be UREKA. Pls share.
     
  8. Sgpal

    Sgpal Member

    Joined:
    Aug 22, 2008
    Messages:
    62
    Likes Received:
    14
    Trophy Points:
    8
    Hi Findvikas,

    Thanks for this tool. I am having excel 2003 and when I click draw button I get
    the same compilation error as subodh9.

    Regards.
     
    findvikas likes this.
  9. findvikas

    findvikas Well-Known Member

    Joined:
    Jan 31, 2008
    Messages:
    3,347
    Likes Received:
    3,343
    Trophy Points:
    113
    Thanks for reporting this issue to me

    I have made changes to the sheet to fix the bug which was not allowing Excel 2003 users to use the sheet... to my wonder either we all are UP TO DATE or people just avoided using the sheet and not reported it to me ... :)

    I have also updated sheet to automatically calculate 1% as box size and 3% as reversal size, if you want to change this default value you can go to code and change the values of constants in the TOP of macro.

    Const BoxSizePercentage = 1
    Const ReversalPercentage = 3

    I calculate the average price of the scrip in the given time frame and calculate the box & reversal in % of the average price

    Please do let me know if that helps.

     
  10. itzarvind

    itzarvind Well-Known Member

    Joined:
    May 16, 2008
    Messages:
    201
    Likes Received:
    561
    Trophy Points:
    93
    Location:
    Chennai
    Findvikas,

    First of all i would like to appreciate the Sincere effort.

    Works fine for me with Excel 2003.

    But i find it little difficult with the chart pattern link.

    It would be better, if some realtime examples are taken and dealt with.

    For example consider TATASTEEL (Attached its image)

    LTP is 571 and the chart has the maximum value at 549.

    Why is it so.. how to intrpret it with the actual price movements.

    Regards,
    Arvind


    [​IMG]
     
    findvikas likes this.
Loading...

Share This Page