Dan-o
19 posts
msg #58983
- Ignore Dan-o |
1/14/2008 8:45:04 PM
Does anyone use an Excel spreadsheet with a DDE feed to automate their trading? I'd like to write a Visual Basic program to automate entry and exit based on an Excel sheet. Does anyone have any good reference material? I'm pretty good with Excel, but just a beginner with Visual Basic. Any input is appreciated!
Thanks,
Dan-o
|
guru_trader
485 posts
msg #58984
- Ignore guru_trader |
1/14/2008 10:30:49 PM
Why not use XLQ or AnalyzerXL to help with your datafeed and then code around that?
|
traderrmr
7 posts
msg #59014
- Ignore traderrmr |
1/15/2008 6:12:41 PM
I am very interested in this subject. Does anyone know the specifics on how to automate their trading? how does the date get converted in API?
What data feeds would be needed?
|
drew9
171 posts
msg #59016
- Ignore drew9 |
1/15/2008 8:44:05 PM
I use Omni Trader Professional. They have a feature called Integrated Brokerage. This is all done visually on the chart. Just drag a chevron where you want to enter the order and it will manage the trade based on your parameters. I use Interactive Brokers and it uses their API. I could not find much on this piece on their website but it is very cool. (omnitrader.com). Only issue I have had is you need a relatively new computer as it is very CPU intensive. Just have to keep the number of symbols within reason. I do plan on upgrading to a new system soon.
|
Dan-o
19 posts
msg #59042
- Ignore Dan-o |
1/16/2008 3:14:28 PM
Thanks for your input, everyone. What I plan on doing is using results of SF screens to generate my daily list of names to trade. From there, I'll be using a really simple rules based system which I feel could be put together pretty easily using, say, an eSignal feed. I'd really like to code it myself just for the experience.
Thanks,
Dan-o
|
traderrmr
7 posts
msg #59095
- Ignore traderrmr |
1/18/2008 6:15:14 AM
Drew. Are you setting technical parameters. Can you set it to for example (Buy if a stock hits a RS 2 and short a RS 99). Or will is trade MA Cross overs? Thanks in advance.
|
drew9
171 posts
msg #59115
- Ignore drew9 |
1/18/2008 12:52:03 PM
They do have that functionality with an add on product called Omni Pilot. It uses Visual Basic and I do not have much time to learn it. I use the chart feature where you can set a price such as just above or under the price. It also allows you to use the same functionality with trend lines. Just draw a line on the chart and if broken by a certain threshold, it will buy or sell and then manage the trade automatically. (Nice to use now for when the market ever returns to the upside.) What I like to do is use SF for my set ups and then use Omni Trader to enter at the appropriate point and then manage the trade once I am in.
|
drew9
171 posts
msg #59116
- Ignore drew9 |
1/18/2008 12:58:07 PM
Dan missed your prior message. I use E-Signal to feed Omni Trader. You only need this if you plan on trading real time. If end of day, Omni Trader has their own feed. Omni Trader keeps the order hidden which is a nice feature and only when the the order is triggered is it sent to Integrated Brokers. They also currently support MB Trading for a broker.
|
drew9
171 posts
msg #59118
- Ignore drew9 |
1/18/2008 1:13:19 PM
One last thought, there is another product that perhaps you have heard of called Cool Trade. I have used it in the past and it was nice as well. For trading the automated technical set ups, it is perfect. I like the trade management features better in Omni Trader though.
|