Ok, I thought I'd quickly stop by, just to keep you updated.
At the moment, as far as discretionary trading, I am holding some metals and some grains, because they were really low, and so if hyper-inflation is to happen, I will be holding some "physical" goods. The value of USD will lose 50% but the amount of USD will double, given my investment - which at any rate cannot really fall any lower. So this isn't really one of my typical trades, because I'll be holding it for months, probably till December's expiration.
Now, as far as automated trading, what I really have to deal with is something else, quite a feat. I have to do a brain transplant from my previous DDE excel workbook to the new workbook, which is based on the newest version of "twsdde.xls", IB's sample sheet.
My first customization of that file dates back to 2005. Since then, I've already done a couple of brain transplants, because these sample sheets get obsolete, along with their VBA/DDE code within (written by IB programmers).
Just last Monday, things on my workbook weren't working anymore, after my break of 4 months due to insufficient funds (I need a large capital to trade my systems, with my new automated money management formula): it stopped sending orders to TWS.
It's a lot of work. I first downloaded the latest twsdde.xls, removed all the unnecessary sheets: all of them but these:
tickers,
basic orders, extended order attributes (I kept deleting it without realizing I needed it),
historical data,
account
Then, given that these 5 are all I need, and given that my old customized twsdde.xls has about 50 sheets, the easiest thing to do now is to do a brain transplant from the new twsdde.xls to the old (modified) one.
But to do an effective brain transplant, I first need scoop the previous brain out of the old (modified) sheet. This is going to take a while, because I also have to check all the connections that my added VBA modules have to the old IB brain, and reconnect those to the new brain. A lot of work, but it would be more work if I tried different routes.
And then, when I'll finally be done, I will turn it on, and hopefully I will be able to say "it's alive!":
"It's Alive!!!" - YouTube
...
Almost done. I started yesterday and I will finish tomorrow. It seemed like a hell of a nightmare, but it wasn't. The planning part was very important though. If I hadn't planned so carefully, like you plan surgery, i might have taken a much longer route.
For example, I decided to move the new brain on the old sheet, but initially I was thinking of moving the customized 50 sheets to the new twsdde.xls. That might not have worked (when you move things around, you get a lot of problems with the references) and I might have wasted a month on it, and given up.
This was awesome planning, I'd say. A dog barking woke me up at 5 am, and that's when I came up with the idea of transplanting the brain from the new sample sheet to the old customized one.
Oh, and the idea of discarding ActiveX wasn't granted at all. I thought about it, and I decided it wasn't worth all the work. After these useful decisions and planning, I managed to finish everything in just 48 hours (including tomorrow). I am very satisfied with myself.