You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Automated trading through Excel
- Thread starter TheStudent
- Start date
I use excel to monitor some market and a few selected stocks. The up-side is that it is very easy to do. The down-side is that the excel is very slow and not scalable (cannot handle a large portfolio), so I wrote a c++ program to do the bulk of analysis.
Quote from karsat:
Hi John,
Can you please direct me how to do that
Thank you
The main analysis (back test, etc) is done in C++. After formulating the rules, I coded them into VBA in excel. For importing live data, in excel you can go to data, then go to external data, and then new web query to link to Yahoo web site.
This is a lost-cost, though limited , way to monitor my positions.
Because I only trade low-frequency, this suits me well.
its good until you see the price ! or ring up for a support issue .
Quote from pepper_john:
I use excel to monitor some market and a few selected stocks. The up-side is that it is very easy to do. The down-side is that the excel is very slow and not scalable (cannot handle a large portfolio), so I wrote a c++ program to do the bulk of analysis.
what are ways to speed up excel recieving quotes?
i read somewhere that these factors help:
-higher ram memeory
-higher speed processer
-Not use loop using functions in low timeframes like ticks, seconds,...
thanks
These guys have a faster Excel interface, I don't know how many issues you can watch at a time but this is probably as good as it gets.
http://www.traderssoft.com/ts8/mdl/
there are so many brokerages/data providers etc that have an Excel interface, it has to come in handy at some point.
http://www.traderssoft.com/ts8/mdl/
there are so many brokerages/data providers etc that have an Excel interface, it has to come in handy at some point.
Programming people: Can anyone help?
If I would like to place a conditional order e.g. to buy 50 call options at $1, and I would like the order to cancel automatically, (or for adjustment in price) if e.g. the underlying stock drops by $1, can this be done in DDE Excel? Or must it be done in CTCI (FIX)?
Also, under what circumstances is user intervention required, and when can something be fully automated?
If I would like to place a conditional order e.g. to buy 50 call options at $1, and I would like the order to cancel automatically, (or for adjustment in price) if e.g. the underlying stock drops by $1, can this be done in DDE Excel? Or must it be done in CTCI (FIX)?
Also, under what circumstances is user intervention required, and when can something be fully automated?