Strategies and signals excel

[rahul100]

Hi

I have seen several front ends such as meta trader and ninja trader, does anyone produce strategies and signals in excel, if not why not?

If there was a competition with large cash prizes would people do strategies and signals in excel or convert there meta trader or ninja trader logic to excel based signals?

Thanks

 

[DionysusToast]

As someone that's been programming for 27 years, I can give a fairly educated opinion.

Excel is sh1t.

Thank you....

Seriously - with platforms out there that give you commands and structure for development, you'd have to be completely crazy to do it in Excel. I've seen people spend weeks doing stuff in Excel that you could do in Tradestation in a few hours.

RIght tools for the job is what it comes down to and Excel is a terrible tool for strategy development.

 

[HowardCohodas]

As someone that's been programming for 27 years, I can give a fairly educated opinion.

Excel is sh1t.

Thank you....

Seriously - with platforms out there that give you commands and structure for development, you'd have to be completely crazy to do it in Excel. I've seen people spend weeks doing stuff in Excel that you could do in Tradestation in a few hours.

RIght tools for the job is what it comes down to and Excel is a terrible tool for strategy development.

You're right about that!

Although I do use Excel for my real-time Dashboard. Not much VBA required except for alarms.

 

[chart rider]

rahul
I see nothing wrong with using excel, it all depends what you are trying to do. I have higher level packages, but still use excel sometimes, for example, am currently experimenting neural networks and rather than invest straight away in a high level program, have initially bought a simple excel add-in. This allows me to start some simple testing and get familiar with the idea.
Alot of strategies can be configured into excel, in addition, there are add-ins for configuration of montecarlo testing etc (although I haven't tried them as I have other packages do this).
CR

 

[JahDave]

Excel can never do what good charting software can do.

 

[DionysusToast]

Actually - Excel can do pretty much anything - you just might spend 100's of hours doing something that would take a few hours with the right tools..

If you are poor and have too much time on your hands, it's perfect !

 

[adamscj]

Personally I use Excel for playing around with long term strategies (daily signals) as it's so easy to graph stuff, work out returns/sharpes etc but would never use it for trading or intraday signals

When it comes to implementing the real thing I've written my own app in Java that does everything automatically with a few "big dials" for my control - this is to give me the ultimate flexibility in what I'm doing

 

[rahul100]

Can anyone suggest a uniform method?

 

[HowardCohodas]

Can anyone suggest a uniform method?

What do you mean?