Search results

I see (sort of). So would you expect this to cause problems with just one website (ie. interactivebrokers.com) ? Not sure what you mean by "network control panel" - I'm on XP with IE7 - do I have such a thing?? I'll give that a go. IB did tell me however that the people experiencing...

OK. What does that mean? What can I do about it? Thanks.

I'm still having problems here - interactivebrokers.co.uk is fine but when I try to log into Account Management (which seems to come from interactivebrokers.com) things come to a halt. I spoke to IB support who seem to think it isn't their issue - mainly because only "a few" customers have...

Yes it does, thanks for posting.

OnTime should solve your problem. I guess you are not using it correctly. Experiment with this, and you should get the picture : Sub OnTimeTest() RunAgain = MsgBox("Run again in 15 seconds?", vbYesNo) If RunAgain = 6 Then Application.OnTime Now + TimeValue("00:00:15"), "OnTimeTest"...

The "#N/A" values that will show in Excel prior to the data connection with TWS being established will only show up for a couple of seconds....why not hold off on running any code until the "#N/A"'s have all been replaced by data? You can use IsError within the spreadsheet as you have...

Does your VBA code need to run constantly? Why not just trigger it when necessary?

That code looks fine. Who is your cell phone provider??

I have excel send an email to a www.sms2email.com account, which forwards it to my phone. Works in the UK, I don't know about elsewhere. If you (or anyone else) needs the code to get excel to send emails, let me know and I'll post it.

Just noticed this thread. I have what I believe to be a complete set going back to Feb '04 - and I don't have those files. I would guess therefore that there was no trading on those days. If you have any other gaps, let me know.

I see. Thanks.

Anyone know if it's possible to get more than 5 rows of market depth data for Globex futures through the IB API? If I set up any more than 5 they just show zeroes. Thanks.

Right then : As you've no doubt already noticed, this code works fine but needs to be run manually each time you want to have the correct colour displayed. Which is no good, realistically, because you want to be sat on your balcony getting drunk in the sunshine, not clattering away at your...

This will do the trick : Sub FormatCells() Dim AskIndicatorAddress As String Dim BidIndicatorAddress As String Dim AskIndicator As Variant Dim BidIndicator As Variant Dim FoundMatch As Boolean Dim MatchRow As Variant Dim MatchInteriorFormat As Variant Application.EnableEvents =...

This is a good post. I'm sure you won't be upset when it gets almost totally ignored.

That's the ticket fellows. Over and out.

Thanks for answering. Just to clarify: You're saying that, when TWS is connected to the HK server, cumulative volume is reported in the normal way (eg. for Nasdaq stocks or Globex futures) except for those specific markets which you mention?

An old thread I know but... I'm considering moving to the IB HK server because of the difference in reset time....but I'm being told by IB support that in doing so I would lose access to volume data. Could someone who connects to the HK server please confirm to me that this is the case...

Do these things you mention (I don't know what they mean exactly, though I have heard them mentioned before) lead to high volatility significantly more often than not? If so, they may provide an edge for a break-out system. In order to find out, you will need a measure of volatility that you...

I'm feeling charitable : This system is probably doomed to break even over time or worse, because it has no edge, and neither has an attempt been made to find one as far as I can see. It relies on the market exhibiting the same character as it has done in the past, which will work some of the...