Point and Figure Chart Excel Sheet

[subodh9]

Dear Vikas,

I am getteing compilation error on this line please suggest.

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

Regards,
Subodh Apegaonkar

 

[findvikas]

What is the error and Excel's version? anyone else facing similar issue ?

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

 

[Sunny1]

I dont have MS office
using open office and not able to get data and plot

 

[findvikas]

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

 

[VJAY]

Dear friends,
for me it working on office 2007......

 

[findvikas]

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

 

[4076699]

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

 

[Sgpal]

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]

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.

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.

Dear Vikas,

I am getteing compilation error on this line please suggest.

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

Regards,
Subodh Apegaonkar

 

[itzarvind]

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