I got a weird error the other day in SSIS that said “Error: The component is missing, not registered, not upgradeable, or missing required interfaces.” It was referring to an XML source component in a data flow. I am not sure if this error is specific to XML sources, or it just occurred because this happened to be the first component that got initialized. I am using Visual Studio 2015 Community and SQL Server 2016. After much wailing and gnashing of teeth I figured out how to fix the the problem. You need to change the “Target Server Version” property of the SSIS project (right click on the SSIS project and select properties to get there) to “SQL Server 2016”. Originally it was set to “SQL Server vNext”.
I receive daily activity statements from my broker and I wanted to download them, extract the data into a MySQL database and then archive the statement on the hard drive. The first part is downloading the attachment, and then moving the email to another imap folder, which is something I had trouble with in Gmail. I use Python to do it, and the email and imaplib packages. Here’s a look at the code that moves all the messages in the inbox from a single recipient to another imap folder.
import Messaging, Util, Const
import email, imaplib, os
m = imaplib.IMAP4_SSL(Const.IMAP_SERVER)
resp, items = m.search(None, 'FROM', '"email@example.com"')
items = items.split()
for emailid in items:
resp, data = m.fetch(emailid, "(RFC822)")
if resp == 'OK':
email_body = data.decode('utf-8')
mail = email.message_from_string(email_body)
if mail.get_content_maintype() != 'multipart':
if mail["Subject"].find("Activity Statement") > 0:
print("Moving message " + mail["Subject"] + " to " + Const.IMAP_DEST_FOLDER)
result = m.store(emailid, '+X-GM-LABELS', Const.IMAP_DEST_FOLDER)
#result = m.store(emailid, '+FLAGS', '\\Deleted')
mov, data = m.uid('STORE', emailid , '+FLAGS', '(\Deleted)')
I use another file called Const.Py to store all my configurations, so change those to whatever you need. The key here is to change the label with the line “result = m.store(emailid, ‘+X-GM-LABELS’, Const.IMAP_DEST_FOLDER)”, and then add the “Deleted” flag, before expunging the inbox.
The Nasdaq futures (NQ) broke out of resistance at 4,441.50 but got promptly rejected at 4,450. That failed breakout look very bearish to me, and I think we could find ourselves going lower in the next few days.
Below us there is good looking demand at 4,205.75, which is where I’ll be starting to look for a long.
Looking at the weekly chart, with indicators courtesy of Emini-watch, you can see that we put in a pullback to end of trend, with a yellow amateur bar trying to get long at the top. The picture is quite bearish.
I currently have a short order placed at 4,401.75, from a small 2 minute zone.
Most of my trading has been done on Tradestation, which still in my opinion has one of the best platforms out there as far as ease of use goes. When I switched to Interactive Brokers I found it quite an adjustment getting used to Trader Workstation – the IB platform. You can do most everything TS does in this platform, but it is all done a little differently so it takes some time to adjust.
One of the things I battled with was adding an OCO for a target and a stop for an existing position. What I usually do is get into a position with a limit order and a stop, and then add the target at a later stage. It’s not a good habit, and something I am changing. Having said that, if you find yourself in a position, wanting to add an OCO (order-cancels-order) for a profit target and a stop, here is how you do it.
In the classic TWS, click on the contract/stock/forex pair that you want to place the order for. For this example, lets say that I am long one contract of ES at 2070.
Press the order button in the top left hand corner.
Lets place the stop first. On the basic tab, we’ll make it at 2068, GTC and a stop order.
This is the important part. Go to the Misc. tab, and give the order a group name. It must be unique per trade, so you can’t use the same group name all the time. This is the part that links the orders into groups. I’ve called mine “ES_OCO_LONG_01_01”. Press Transmit.
Now click the Order button again and this time we’re going to do the target. We’ll set our target as a LMT sell order, GTC with a price of 2080.
Now go the the Misc tab, and paste in (or type) the group name exactly as you did for the stop order. Mine is “ES_OCO_LONG_01_01”
Press Transmit and double check you’re order in your Activity Monitor and you’re all done.
It’s a lot more work than doing it in TS, but the result is the same and once you get used to it, it really isn’t all that bad. The only thing I wish you could do was place multiple target orders at the same time.