I use LASER from genesis and just need to use excel to exit out of positions only on a specified loss....is this safer approach to use excel? please anyone let me know..... I need way of using Excel with laser to just exit out of positions on losses Please can anyone help???
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.
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.
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.
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?