Search results

Can anyone help me to get rid of second or third grey background in excel charts, as seen in my attached picture? I am not talking about the background of where the chart is, but the frame, the dark grey background around it. I have done extensive searched on manuals and internet, but found nothing.

Orders from my excel workbook to TWS, via API DDE Excel, have been working fine all day long, and in the previous weeks, but today I came across this problem: Error 28 - Out of stack space. My order got as far as the "Orders" sheet of my workbook (the line was there in the right place), and...

A couple of questions to those on this forum who are using a TWS DDE Excel automated trading system: 1) Do these recent (december) API/Excel changes mean that my system (based on the previous TwsDde.xls sheet) will stop working any time soon? 2) If my system is working fine as it is, can I...

Thank you for the information.

I am having troubles customizing the files of IB Controller (http://finance.groups.yahoo.com/group/TWSAPI/files/Auto%20Login%20Codes/) for the new update of TWS. This software allows you to log in with just a click (it fills out the form for you) and it handles the autologoff feature and the...

Thank you very much for the very detailed replies. I will try to simplify my problems and solutions as much as possible, because I don't have the knowledge required to write the powerful code and program you are talking about. I will keep you updated in case I come up with anything good (and...

I have a few questions concerning trade executions going from Excel to IB's TWS platform (via DDE). As far as I know IB doesn't permit Excel to tell TWS to "close" a trade for example but can just say BUY or SELL, and not, more correctly "OPEN BUY", "CLOSE BUY", "OPEN SELL" and "CLOSE SELL"...

Ok, yes, you are right, this seems to solve my problem even better. So I should use something at the start of my procedure (where it first makes contact) saying: If VarType(Cells(2, 3)) = 8 ... Then Exit Sub It seems it should work, and it precedes the error (it doesn't just stop the error...

Got it! No errors at all of any kind (not even "overflow") if you insert this line in the errorhandler, referring to the cells being fed live data from TWS, via the Excel DDE method. This code makes sure the variable type is a double, or else exits sub: If VarType(Cells(2, 3)) <> 5 Or...

m4a1, please read what libertine (and others before him) says, because he has understood exactly what I am talking about. We're not talking about a mistake that "I want to hide", in fact, it's not even a "mistake", as you can tell by libertine's explanation. It doesn't even ever re-appear during...

Well, good point, but not exactly in my opinion (and obviously), even though it has similarities. I don't fully understand all the implications of the differences. Among them, the fact that if I place "iserror" on a cell it will only affect that cell, which in turn allowed me to understand where...

Well, no, I don't see why you are saying this. First of all, I had to change the "0" to "1", so I don't get occasional division by zero problems. Concerning your objection, I only get the "1" value (previous "0") at the start, in the first half a second after pressing "update" and...

Hi, all your advice was great. I used all of it to come up with an answer. But some of you were right on target. Also one guy, Alex, at the IB discussion board was right: http://www.interactivebrokers.com/cgi-bin/discus/board-auth.pl?lm=1161176853&file=/2/38381.html The answer to my...

Well, I am pretty sure all mistakes happen when I open up the excel workbook, and I answer the opening popup question by pressing "Update" (DDE links). These links are the IB links in cells in the form of "=userid|tik!id2?last" for example. These are links to numbers, such as last price, bid...

Regretfully, I don't know exactly where in the sub procedure these 36 "type mismatch" errors are coming from. And this is the most important procedure in my system, so I am not too happy about posting it here, or sending it out. However, thanks to everyone for their willingness to help me.

Thanks to both of you. Yes, I am using vba, and no, I have not recorded a macro, but I have written myself all that code. To the previous post, yes, I did try using "dim x as double" instead of "dim x as integer", and it didn't get rid of any of the 36 "error 13" I get. The other...

I am using IB TWS in connection with Excel DDE, with vba code. Once I connect to the TWS and the data starts coming, I get a bunch of Error13 ("Type mismatch"). On a given vba procedure, the more I refer to data from TWS (that I get with the DDE link) the more Error 13 I get. This doesn't stop...

I have just realized there's a new filter to implement in my system, but I didn't feel like testing it yet, though I am sure it makes sense. It is based on the relationship of range and trend with the time of the day. You must all agree that support and resistance are less likely to last...

John, thanks for the advice. I know you are right in saying that the trend is caused by the news. Yet, those people saying "it's all in the chart" are also right, because you said it yourself that price is influenced by the news. So if you look at price you see the news in it. Now the...

Thanks for sharing your work, newbie2006 and flip. It sounds like you have done more work than I did, and more competent. I hope everyone else can now add to this topic here, because I have ran out of statistical material to back up my assertions on this subject. I realize now that mine were...