Traderji.com - Discussion forum for Stocks Commodities & Forex


Point and Figure Chart Excel Sheet

Discuss Point and Figure Chart Excel Sheet at the Technical Analysis within the Traderji.com - Discussion forum for Stocks Commodities & Forex; Dear Vikas, I am getteing compilation error on this line please suggest. oChartWS.Cells(nChartRowIdx, ColCtr).Font.Color = ...


Go Back   Traderji.com - Discussion forum for Stocks Commodities & Forex > METHODS & STRATEGIES > Technical Analysis

Technical Analysis Discussion of all the principles involved in technical analysis.


Reply
 
Thread Tools
  #11  
Old 14th October 2009, 03:11 PM
subodh9's Avatar
Member
 
Join Date: Aug 2008
Location: Vadodara
Posts: 83
Thanks: 59
Thanked 88 Times in 35 Posts
subodh9 will become famous soon enough
Default Re: Point and Figure Chart Excel Sheet

Dear Vikas,

I am getteing compilation error on this line please suggest.

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

Regards,
Subodh Apegaonkar



Reply With Quote
The Following User Says Thank You to subodh9 For This Useful Post:
findvikas (15th October 2009)
Sponsored Links
  #12  
Old 14th October 2009, 07:07 PM
findvikas's Avatar
Member
 
Join Date: Jan 2008
Posts: 3,296
Thanks: 1,103
Thanked 3,260 Times in 2,030 Posts
findvikas has a reputation beyond repute
findvikas has a reputation beyond reputefindvikas has a reputation beyond reputefindvikas has a reputation beyond repute
Default Re: Point and Figure Chart Excel Sheet

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

also what is the Excel Sheet's version that you using?
Reply With Quote
  #13  
Old 14th October 2009, 07:21 PM
Member
 
Join Date: Mar 2008
Posts: 1,284
Thanks: 5,985
Thanked 1,180 Times in 621 Posts
Sunny1 has much to be proud ofSunny1 has much to be proud ofSunny1 has much to be proud ofSunny1 has much to be proud ofSunny1 has much to be proud ofSunny1 has much to be proud ofSunny1 has much to be proud ofSunny1 has much to be proud ofSunny1 has much to be proud of
Default Re: Point and Figure Chart Excel Sheet

I dont have MS office
using open office and not able to get data and plot
Reply With Quote
  #14  
Old 14th October 2009, 07:31 PM
findvikas's Avatar
Member
 
Join Date: Jan 2008
Posts: 3,296
Thanks: 1,103
Thanked 3,260 Times in 2,030 Posts
findvikas has a reputation beyond repute
findvikas has a reputation beyond reputefindvikas has a reputation beyond reputefindvikas has a reputation beyond repute
Default Re: Point and Figure Chart Excel Sheet

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
Reply With Quote
The Following User Says Thank You to findvikas For This Useful Post:
Sunny1 (14th October 2009)
  #15  
Old 14th October 2009, 08:00 PM
Member
 
Join Date: Jun 2008
Posts: 4,170
Thanks: 14,188
Thanked 7,339 Times in 2,531 Posts
VJAY has a reputation beyond reputeVJAY has a reputation beyond repute
VJAY has a reputation beyond reputeVJAY has a reputation beyond reputeVJAY has a reputation beyond reputeVJAY has a reputation beyond reputeVJAY has a reputation beyond reputeVJAY has a reputation beyond reputeVJAY has a reputation beyond reputeVJAY has a reputation beyond reputeVJAY has a reputation beyond reputeVJAY has a reputation beyond repute
Default Re: Point and Figure Chart Excel Sheet

Dear friends,
for me it working on office 2007......
Reply With Quote
The Following User Says Thank You to VJAY For This Useful Post:
findvikas (14th October 2009)
  #16  
Old 14th October 2009, 09:20 PM
findvikas's Avatar
Member
 
Join Date: Jan 2008
Posts: 3,296
Thanks: 1,103
Thanked 3,260 Times in 2,030 Posts
findvikas has a reputation beyond repute
findvikas has a reputation beyond reputefindvikas has a reputation beyond reputefindvikas has a reputation beyond repute
Default Re: Point and Figure Chart Excel Sheet

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
Reply With Quote
  #17  
Old 14th October 2009, 09:26 PM
Member
 
Join Date: Jan 2008
Posts: 75
Thanks: 99
Thanked 27 Times in 21 Posts
4076699 is on a distinguished road
Arrow Re: Point and Figure Chart Excel Sheet

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.
Reply With Quote
  #18  
Old 15th October 2009, 12:53 AM
Member
 
Join Date: Aug 2008
Posts: 63
Thanks: 93
Thanked 14 Times in 12 Posts
Sgpal is on a distinguished road
Default Re: Point and Figure Chart Excel Sheet

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.
Reply With Quote
The Following User Says Thank You to Sgpal For This Useful Post:
findvikas (15th October 2009)
  #19  
Old 15th October 2009, 02:10 AM
findvikas's Avatar
Member
 
Join Date: Jan 2008
Posts: 3,296
Thanks: 1,103
Thanked 3,260 Times in 2,030 Posts
findvikas has a reputation beyond repute
findvikas has a reputation beyond reputefindvikas has a reputation beyond reputefindvikas has a reputation beyond repute
Default Re: Point and Figure Chart Excel Sheet

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.

Quote:
Originally Posted by Sgpal View Post
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.
Quote:
Originally Posted by subodh9 View Post
Dear Vikas,

I am getteing compilation error on this line please suggest.

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

Regards,
Subodh Apegaonkar
Reply With Quote
  #20  
Old 15th October 2009, 08:11 AM
itzarvind's Avatar
Member
 
Join Date: May 2008
Location: Chennai
Posts: 201
Thanks: 226
Thanked 561 Times in 151 Posts
itzarvind is a name known to allitzarvind is a name known to allitzarvind is a name known to allitzarvind is a name known to allitzarvind is a name known to allitzarvind is a name known to all
Default Re: Point and Figure Chart Excel Sheet

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




Reply With Quote
The Following User Says Thank You to itzarvind For This Useful Post:
findvikas (15th October 2009)
Reply

Bookmarks


Advertise Here


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off



All times are GMT +5.5. The time now is 02:54 PM.

Indemnity, Disclaimer & Disclosure Notice:
By visiting Traderji.com you automatically indicate that you agree to our Forum Rules, Indemnity, Disclaimer & Disclosure Notice and General Content Disclaimer Notice and indemnify Traderji.com, its associates and related parties of all claims howsoever resulting from the usage of the forum/site.
Disclaimer: Trading or investing in stocks & commodities is a high risk activity. Any action you choose to take in the markets is totally your own responsibility. You are recommended to make appropriate enquiries and seek appropriate advise before sending money, incurring any expenses, acting on recommendations or entering into any commitment in relation to any advertisement published here. Traderji.com does not vouch for any claims made by the advertisers of products and services. Traderji.com will not be held liable for any consequences in the event such claims are not honoured by the advertisers. Traderji.com will not be liable for any, direct or indirect, consequential or incidental damages or loss arising out of the use of any information by anybody mentioned anywhere on this site.
Disclosure: The information in this forum is neither an offer to sell nor solicitation to buy any of the securities mentioned herein. The writers may or may not be trading in the securities mentioned.
All names or products mentioned are trademarks or registered trademarks of their respective owners.
General Content Disclaimer Notice:
In light of our policy of encouraging candid, open exchanges of views and the rapid distribution of information originating from many sources, Traderji.com cannot determine the accuracy or legality of any information that may be uploaded to the forum. Opinions, advice and all other information expressed by participants in discussions are those of the author. You rely on such information at your own risk. You are urged to seek professional advice for specific, individual situations and not rely solely on advice or opinions given in the discussions. Since Traderji.com is an open and free discussion forum, any comments made by members of this forum in their posts reflect their own views and not of the owner or administrator of Traderji.com. Thus the owner/administrator indemnify themselves of all claims whatsoever and will not be liable or responsible for any members comments/views in this forum Traderji.com. Although we constantly delete all irrelevant content and/or SPAM, if you should find any objectionable or offensive posts made by members of this forum which you would like to bring to our notice for removal then please Contact Us.
 


Copyright © www.Traderji.com 2001 - , All rights reserved.

Recommended Websites - www.TradersEdgeIndia.com - www.TradingPicks.com - www.MasterOfTrading.com

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245