Search results

The attached image shows an excel spreadsheet I created for backtesting ES. Charts can be set to any time frame since they are created from tick data. Instructions, tick data and the file are downloadable here. (If "volume candlestick data" refers to constant volume bars, I have never...

There was a timing issue with the opening and closing of the hidden instances of Internet Explorer required to run the script. If your error in Vista was "remote server error" then you might try a current version. The most current version is always available here.

I should have mentioned that I sped up the video by a factor of ten due to youtube's time limitation. They are 5 minute bars. It's all VBA/Excel

I have also developed automated channels based on my interpretation of the channels for building wealth document. I use volume to determine channels as you can see in the following youtube video

Today I added the ability to Pause/Resume. Before if you hit the stop button or reset button, you had to start all over. :mad:

I have posted a trading simulator that I recently created here Charts are created from recorded tick data. you can choose a charts timeframe on the setting tab. This is just a first version. I may update/add features from time to time.

Hey Junkyard, This is very easy to do with excel so follow these instruction s and view this video for clarification. To modify IB’s excel Sample so that it sends all orders that you have typed in on the order entry page. Assuming you know nothing about VBA programming and/or are new to...

Thanks for the response. At first I thought you were on to something however after testing I find that entering a 1 or 0 on the orders sheet has NO EFFECT whatsoever as to whether or not an order transmits. You can set both your limit order and MKT to 0 and they will both transmit. You can...

I have been unable to send child orders that are connected to the parent (using IB/excel) and wondered if you are now doing it successfully. I have found that (following all instructions on IB forums etc and)setting the transmit field to a 1 for true or a 2 for false has no effect whatsover...

I am using live formulas for the channel calculations with no user input. Right now I use 6 sets of formulas for up and 6 for down (12 total). On a few occasions, I have had a need for a few more.

A while back, I spent a three days weekend programming channels in excel. IN the end I simplified things by eliminating VBA and instead relying solely one formulas (and array formulas). Here are a bunch of snapshots from today. You will notice that a channel will disappear once price...

Dim price2 as double price2 = (that string variable's name) ?

Ok, well you have me convinced that it is something unusual with your system. I use tws with excel every day and can confirm that there is not a general problem. Here is what I would try next and I am really reaching here for a solution. Recently there was a Microsoft update, If you...

You can work on this through the weekend using edemo account (password demouser). Also can you answer: Are you using (having freezes with) a modified version of the TwsDde.xls sheet? If so have you tried the getting quotes from the original TwsDde.xls?

Try uninstalling/reinstalling both the API and TWS again, but this time go and manually delete the "JTS" folder. (and don't forget to enable dde on new install) Are you using a modified version of the TwsDde.xls sheet? If so have you tried the getting quotes from the original TwsDde.xls...

Some of you may get a kick out of this. Formula drawn channels in Excel. Does this officially me me an excel nerd? :D (once current price is above or below a point one, the channel is cleared so the formulas can be reused for newer channels)

1. he could have a witness. 2. He could record a camtasia video etc. He can set the papertrading account balance = the balance of his real account, then try to duplicate the exact order and the order should reject just like a normal account. correct me if I am wrong. Maybe it's worth...

Since you believe this may be a software issue, have you tried to recreate this scenario using a papertrading account? send the basket order and purposely go over margin, wait for the rejected order, unplug the internet until tws shows disconnected then reconnect, see what happens. Maybe you...

see this thread

1. Open final Universe Macro.xls 2. Press ALT+F11 which opens "Microsoft Visual Basic" 3. In MVB (not excel), Click "EDIT">"REPLACE 4. Make sure "Current Project" is selected. 5. Find what> http://quote.yahoo.com/d/quotes.csv?s= Replace with>...