Question for Grob/Hershey...

Status
Not open for further replies.
Quote from easyrider:

The reason I made the comment is because most of us do not attack bar by bar. I would love to do it bar by bar but cannot seem to get the hang of it. I am still stuck at beginner levels. Jack often says that a lot of easy money is there in the stalls and Im sure he and you know what he is talking about. I am constantly trying to steer newer people to the rocket type situations first because I know they work without a whole lot of expertise.
More...

Agreed and you make an excellent point. There is alot of easy stuff out there so I will scale back a bit on my efforts and try a new approach so as not to step on toes... Handling easy stuff first is definitely I great starting point from any context. We can build from there... Let me see what I can dig up STOCH/MACD wise...

Kind Regards,
MAK
 
Mak

appreciate your willingness to look at this - was not my intention. Ok so let me be clear on what I did so I don't waste your time. With the str/squ the way I got it to work was to copy all content into a new xls (not simply a save as) and that worked. I did same with this one when v2 of yours did not work for me out of the box. So I copied all content, macros and formulae into the new one. Excel is fantastic but has its quirks and those quirks seem to love me.

for any other IBers, this xls I am posting offers no value for now so stick with what Mak posted until we make progress.

merci bien

IRL
 

Attachments

Quote from tradingbug:

I am not sure if you mean the xls which is essentially what you posted albeit a few differences.

I changed cells b17 and b18 with the syntax from the prior post.

The time stamp seems to be working in B17 and C4. Volume seems to be cumulative and working in B18. B3 and C3 seem stuck on 0.

Thanks for the help. RaginCagin and I have been trying all sorts of things.
More...

To give a little more info since its tough to debug in the first place let alone without having esignal(lol). When enabling macros, it gives a run-time error'13': type mismatch.

If I press the debug button, in the Private Sub Workbook_Open(), it yellowhighlights 9 lines down;

sheet1.Cells(1,2).Formula="'=" & sheet2.cells(18,2) & ""


thanks again
 
Quote from tradingbug:

I am not sure if you mean the xls which is essentially what you posted albeit a few differences.

I changed cells b17 and b18 with the syntax from the prior post.

The time stamp seems to be working in B17 and C4. Volume seems to be cumulative and working in B18. B3 and C3 seem stuck on 0.

Thanks for the help. RaginCagin and I have been trying all sorts of things.
More...

Simple enough. Some pages back I mentioned that the cells were explicit strings (ie. they are not formula cells, just syntax). In other words, the code behind the sheet reads the syntax and then constructs the actual formula to be used. In a nutshell cells B17 and B18 should not have any "=". The sheet you posted shows a caculated value from the formulas where b17's and b18's formula is respectively...

"=WINROS|timeupdate!'es #f'"
"=WINROS|totalvol!'es #f'"

whereas it should explicitly be

"WINROS|timeupdate!'es #f'"
"WINROS|totalvol!'es #f'"

B17 and B18 are not supposed to evaluate anything. They are syntax strings and thus should appear as the latter string pairs as opposed to the evaluated values of

11:59
587703.00

that your sheet is reading. Make the above corrections, restart excel and the sheet, and let me know if that corrects the problem.

Regards,
MAK
 
Quote from makosgu:

...

Anthony, I got your PM and will find some time to take a look at the IB debacle that some of you are encountering. ...
More...

Thanks Mak for your comments.

You've gone above and beyond as it is - if I might suggest, instead of digging into the code yourself, post or PM me the pseudo code for your logic.

I'll volunteer to make the updates to the spreadsheet in order to get it to work with IB.

Anthony
 
Quote from makosgu:

Simple enough. Some pages back I mentioned that the cells were explicit strings (ie. they are not formula cells, just syntax). In other words, the code behind the sheet reads the syntax and then constructs the actual formula to be used. In a nutshell cells B17 and B18 should not have any "=". The sheet you posted shows a caculated value from the formulas where b17's and b18's formula is respectively...

"=WINROS|timeupdate!'es #f'"
"=WINROS|totalvol!'es #f'"

whereas it should explicitly be

"WINROS|timeupdate!'es #f'"
"WINROS|totalvol!'es #f'"

B17 and B18 are not supposed to evaluate anything. They are syntax strings and thus should appear as the latter string pairs as opposed to the evaluated values of

11:59
587703.00

that your sheet is reading. Make the above corrections, restart excel and the sheet, and let me know if that corrects the problem.

Regards,
MAK
More...

OK. That worked. I didnt even know that it was possible to auto read the syntax. LOL.

Thanks a lot. You really are pretty far ahead of me in terms of progress and I really appreciate your willingess to help. ET is very very lucky to have people like you, grob, and spyder.

Hopefully, your character traits will rub off on me to become a better person.
 
Quote from Ireland:

Mak

appreciate your willingness to look at this - was not my intention. Ok so let me be clear on what I did so I don't waste your time. With the str/squ the way I got it to work was to copy all content into a new xls (not simply a save as) and that worked. I did same with this one when v2 of yours did not work for me out of the box. So I copied all content, macros and formulae into the new one. Excel is fantastic but has its quirks and those quirks seem to love me.

for any other IBers, this xls I am posting offers no value for now so stick with what Mak posted until we make progress.

merci bien

IRL
More...

IRL

Same solution as TBug...

your b17 and b18 should is currently evaluating whereas it should just be a string syntax... The line of code that tbug pointed out where the error occurs is because it reads the b17 and b18 strings and converts them to the formula it wants. It is a coding framework I had chosen so as to make the sheet datafeed and syntax blind.

your B17 and B18 have equal signs...
drop them such that b17 and b18 respectively read as the following strings...

"now()"
"yourIBidhere|tik!id501?volume"

Je vous en prie!
MAK
 
Quote from makosgu:

Agreed and you make an excellent point. There is alot of easy stuff out there so I will scale back a bit on my efforts and try a new approach so as not to step on toes... Handling easy stuff first is definitely I great starting point from any context. We can build from there... Let me see what I can dig up STOCH/MACD wise...

Kind Regards,
MAK
More...

Was not my intention to change your direction Mak. You should do what interests you as there seems to be plenty of people interested in that, too.
 
Quote from makosgu:

IRL

Same solution as TBug...

your b17 and b18 should is currently evaluating whereas it should just be a string syntax... The line of code that tbug pointed out where the error occurs is because it reads the b17 and b18 strings and converts them to the formula it wants. It is a coding framework I had chosen so as to make the sheet datafeed and syntax blind.

your B17 and B18 have equal signs...
drop them such that b17 and b18 respectively read as the following strings...

"now()"
"yourIBidhere|tik!id501?volume"

Je vous en prie!
MAK
More...

Mak

it seems either I am a clown and missing something obvious (likely outcome) or IB is not behaving as expected.

I made changes exactly as described and had tried this back when you pointed the differences out some pages back but to no avail.

Attached screen shot of what I have for B18 - and in B17 I have now() without the = sign

I have hook in place as normal to provide the dde - that is in B19 and standard GLOBEX reference which is working.

Anyone else got IB to work ? only 25 people downloaded the xls so far - I bet if you charged for it 25,000 people would

appreciate your time - Vous êtes tres patient

IRL
 

Attachments

Status
Not open for further replies.
Back
Top