Woodiepedia CCI Trading University Forum Index Woodiepedia CCI Trading University
Woodies CCI Club Bulletin Board & Encyclopedia
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

New Woodies CCI Stats Workbook Available Here
Goto page Previous  1, 2, 3, 4, 5  Next
 
Post new topic   Reply to topic    Woodiepedia CCI Trading University Forum Index -> Woodies CCI Stats Workbook
View previous topic :: View next topic  
Author Message
nadone



Joined: 16 Apr 2007
Posts: 3

PostPosted: Wed Mar 12, 2008 6:05 pm    Post subject: Run-time error '1004' Reply with quote

Hi Stu

I was wondering if you might comment on an error I receive when I hit f9 to calculate the fields. I get the error when the 10 trades are complete or not.

Run-time error '1004' unable to set the hidden property of the range class

thanks in advance, and thanks for the great work you have done for us all.
Back to top
View user's profile Send private message
ianh



Joined: 15 Mar 2006
Posts: 343
Location: Blackburn UK

PostPosted: Thu Mar 13, 2008 8:17 am    Post subject: Reply with quote

Zenwalk: The Targets and stops for the NQ need to be set to points, so T1 of 10 ticks = 2.5 points.

Newtrader: The targets and stops are set on Week 1 and they copy from their onto weeks 2 - 5.
Back to top
View user's profile Send private message
zenwalk



Joined: 12 Apr 2007
Posts: 5

PostPosted: Thu Mar 13, 2008 12:42 pm    Post subject: Reply with quote

Hello Ian,

I do not agree because the $ result is wrong. If I go to T1 of 10 ticks in the NQ and then stop out be+1 with 4$ of commission per contract and halfturn it is:

1st contract 10 ticks = 50$
2nd contract 11 ticks(be+1) = 55$
commission 2 contracts 2 halfturns = 4x4$ = 16$
-------------------------------------------------
result = 50$ + 55$ - 16$ = 89$

Thanks in advance.
Back to top
View user's profile Send private message
ianh



Joined: 15 Mar 2006
Posts: 343
Location: Blackburn UK

PostPosted: Fri Mar 14, 2008 5:42 am    Post subject: Reply with quote

Zenwalk: BE+1 is 1 tick, not 11, so would give you $5 and would make the calculation correct.
Back to top
View user's profile Send private message
stuh



Joined: 26 Feb 2007
Posts: 20

PostPosted: Mon Mar 17, 2008 6:10 am    Post subject: Re: Run-time error '1004' Reply with quote

[quote="nadone"]Hi Stu

I was wondering if you might comment on an error I receive when I hit f9 to calculate the fields. I get the error when the 10 trades are complete or not.

Run-time error '1004' unable to set the hidden property of the range class

thanks in advance, and thanks for the great work you have done for us all.[/quote]

Nadone, i have had this issue once before with someone else although never had it myself. Can you explain in a little more detail:-
1. When it occurs, i.e. only on calculations, when the open/close the spreadsheet etc.
2. What version of windows your running and what version of Excel you have
3. Whether you get a debug/close box appear when this happens
4. Whether this stops you from entering further data

Thanks

Stu
Back to top
View user's profile Send private message
nadone



Joined: 16 Apr 2007
Posts: 3

PostPosted: Tue Mar 18, 2008 6:21 am    Post subject: error Reply with quote

Hi Stu

1. it occurs when I save and calculate
2. I have the problem on win 2000 running office 2000, also same problem on my mac runing office 2000
3. I get a debug window which brings me into your code and highlights the code [b]Rows(hiddenRow).EntireRow.Hidden = False.[/b] It pops up 6 times if I click End.
4. It stops me from entering any futer data after row 10.

Thanks in advance

Nadone
Back to top
View user's profile Send private message
DonR



Joined: 15 Jan 2008
Posts: 11
Location: Canada

PostPosted: Tue Mar 25, 2008 4:37 pm    Post subject: Workbook results Reply with quote

Having trouble following the results I am getting in the work book.

Attaching a .ppt screen capture of Week 4 for a ER ZLR short.

Since bar open was 699 my first target is 1 (10 ticks) and the managed exit 2 is 699.6 (a loss of 6 ticks), I would expect the workbook to show +1 in "Exit Results" (line 53 col S) and +.4 in "ES1" ( line 2 col P)

Looks like the program has calculated a loss of 1 on the first contract.

What am I missing?

DonR
Back to top
View user's profile Send private message
JoseyWales



Joined: 04 Aug 2005
Posts: 145
Location: San Diego

PostPosted: Wed Mar 26, 2008 12:07 am    Post subject: Change the short to a long Reply with quote

Change the short to a long.

Josey
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Ash



Joined: 25 Jun 2007
Posts: 5

PostPosted: Wed Mar 26, 2008 10:17 am    Post subject: Reply with quote

Thank you for your great work!! one question
Can I add/edit pattern name (eg HTML, HFE ) in pattern drop down list?
Thx
ash
Back to top
View user's profile Send private message
DonR



Joined: 15 Jan 2008
Posts: 11
Location: Canada

PostPosted: Wed Mar 26, 2008 10:23 am    Post subject: WorkBook results Reply with quote

Thx, Josey. Seems to work but not clear on why one would indicate a long when it is a short?
Back to top
View user's profile Send private message
JoseyWales



Joined: 04 Aug 2005
Posts: 145
Location: San Diego

PostPosted: Thu Mar 27, 2008 6:36 am    Post subject: I looked at it wrong. Reply with quote

Sorry DonR,

I looked at it wrong. Dyslexia can be a wonderful thing... You are right, it looks like it didn't calculate T1 correctly.
Back to top
View user's profile Send private message Send e-mail Visit poster's website
stuh



Joined: 26 Feb 2007
Posts: 20

PostPosted: Fri Mar 28, 2008 5:16 am    Post subject: Re: error Reply with quote

[quote="nadone"]Hi Stu

1. it occurs when I save and calculate
2. I have the problem on win 2000 running office 2000, also same problem on my mac runing office 2000
3. I get a debug window which brings me into your code and highlights the code [b]Rows(hiddenRow).EntireRow.Hidden = False.[/b] It pops up 6 times if I click End.
4. It stops me from entering any futer data after row 10.

Thanks in advance

Nadone[/quote]

Nadone, this now makes sense. As i said i had this issue once before with someone else. They were also running Excel Version 2000.

I do not have this version of excel so it is difficult to test. It does seem this is where the problem is. It is to do with the auto hiding rows for trades 11-30.

I am sure if you were to upgrade to excel 2003 or 2007 you would not have an issue.

In any case, what i will do is recreate the workbook without the auto hiding rows.
You would then bot get the error, (the only disadvantage would be, your screen would show all 30 rows for each day!)

Stu
Back to top
View user's profile Send private message
stuh



Joined: 26 Feb 2007
Posts: 20

PostPosted: Fri Mar 28, 2008 5:36 am    Post subject: Re: Workbook results Reply with quote

[quote="DonR"]Having trouble following the results I am getting in the work book.

Attaching a .ppt screen capture of Week 4 for a ER ZLR short.

Since bar open was 699 my first target is 1 (10 ticks) and the managed exit 2 is 699.6 (a loss of 6 ticks), I would expect the workbook to show +1 in "Exit Results" (line 53 col S) and +.4 in "ES1" ( line 2 col P)

Looks like the program has calculated a loss of 1 on the first contract.

What am I missing?

DonR[/quote]

DonR, i have recreated your trade and yes this can cause a problem. I had not factured in the possibility of reaching your target and then getting out for a loss, which we all know can happen if you get a slip, (or indeed if your strategy allows it).

Thanks for bringing this to my attention. I have already worked out the new code to calculate this. It will be in the New Version, out this weekend.

Stu
Back to top
View user's profile Send private message
stuh



Joined: 26 Feb 2007
Posts: 20

PostPosted: Fri Mar 28, 2008 5:54 am    Post subject: Reply with quote

[quote="Ash"]Thank you for your great work!! one question
Can I add/edit pattern name (eg HTML, HFE ) in pattern drop down list?
Thx
ash[/quote]

Ash, I will add this into the New Version, out this weekend. Ver 2.3

Stu
Back to top
View user's profile Send private message
dhpz



Joined: 27 Nov 2007
Posts: 12

PostPosted: Mon Mar 31, 2008 2:31 am    Post subject: Reply with quote

[img]nonewww.coolgif.de/assets/images/456.gif[/img]

we call it here the final countdown

stu, when is the new WB downloadable [img]nonewww.coolgif.de/assets/images/580.gif[/img]


thanks for all your work and get your cold beer here

[img]nonewww.coolgif.de/assets/images/452.gif[/img]
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    Woodiepedia CCI Trading University Forum Index -> Woodies CCI Stats Workbook All times are GMT - 5 Hours
Goto page Previous  1, 2, 3, 4, 5  Next
Page 2 of 5

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum


Powered by phpBB © 2001, 2005 phpBB Group