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