Search results

We're talking about the 2 exe files, tws + api (for excel DDE). Everyone's DDE problem arised with the April update of TWS. What solved my problem were the posts, from both the staff and other users, saying that in order to have DDE working with the latest version of TWS, you also need to...

Never mind - this post answered my problem: http://www.interactivebrokers.com/discus/messages/2/34913.html?1149239571

I took 4 months off, to learn vba, came back and opened my excel system again and it wasn't receiving prices from TWS anymore. I updated TWS, updated JTS folder, but still it isn't working. Now I even tried updating the new excel sample sheet, but it isn't working. Any ideas of what might have...

I solved the problem by using the following method. Instead of using a new sheet each time, I will start using the same sheet day after day, and at the end of each day, at 22.00 Central European Time (16.00 EST), I tell the sheet that today's high and low will have to be copied onto...

You can ask a lot of information about a stock through your IB DDE-Linked Spreadsheet: http://www.interactivebrokers.com/html/webhelp/Interoperability/DDE_Excel/syntax.htm Request today's high price: server + tik + idn + high Request today's low price: server + tik + idn + low Request...

Miracle! I had a successful contribution from a guy on a forum. This time it seems to work perfectly. If you add to the top of my file (I attached it on my second post on this thread) this code, then everything works and it doesn't freeze: Dim valori(1) As Double Private Sub...

The "Calculate" method freezes my excel sheet, and then I have to terminate the program, the "Change" method ignores the DDE changes, as you all pointed out. It seems that I do need a polling method as most people here are pointing out, and by the way thank you all very much for this...

Thanks for the help - I will look into it. My code is indeed here, once again this is the whole file:

I just found a post by H2O asking the same question: http://www.elitetrader.com/vb/showthread.php?s=&threadid=60297&perpage=20&pagenumber=2

Here is the attached file about which I had my question.

Why isn't it updating the data? In order to calculate Support and Resistance (D2 and D4) my sheet uses C2 and C4 (today's H & L) and I thought I told my vb code that if it saw any changes in those two cells within the time C3 (US market open, CET), it would have to change D2 and D4...

Yes, you are right, it worked out perfectly. It was all I needed. Thanks to everyone.

Thanks to everyone. I have used =now() and at the moment it seems to be the right answer to my problem, as it updates the cell each time the macro is used. I will let you know any further developments.

I am using "now" already but I can't figure out how to get my Support and Resistance sheet to work with it. If I could, I would have no more problems, because I am not concerned with IB's time, but only with my own computer time. Basically I want this sheet to retrieve today's high and low...

I would like to know what kind of "=UserName|tik!id1?" code I need to use in order to request the local time (continously updated). There doesn't seem to be a way to request it, so if that's the case I ask you - how do I create within my DDE Excel sheet a macro or excel formula that...

This newbie is actually a very lucky/smart newbie - he began by asking questions on the best section of the best financial forum. Most people have to go through years of losses with a variety of losing methods (wrong analysis, no analysis, wrong broker, wrong platform, wrong financial...

We have inserted a line that produces an html page, with the balance and realtime trades, for every system that gets traded (I trade 3 systems now), and my pc runs a web server, so I can view that page from anywhere, even when I am not home. It also prints the same information on each system's...

I am sorry, but I don't know anything about this question on options with IB. You should be able to find answers on their web site.

Slippage doesn't prevent it from being profitable. Since I started trading it with real money, it's obviously profitable at the moment, and I would stop the minute (after the first week it loses money) it isn't profitable anymore. As I said, I did real time testing, without real money. And...

First of all I downloaded the example sheet as you did. Then I added 2 excel sheets of my own, and a couple of modules. Actually my friend did that, because he's the coder, and, even though I know the code enough to modify it, I am unable to code a system from scratch. One of the excel sheets...