A Reader Comments On Trading Using Excel Vba As Well As Ingredient Model

Thoughtful comments from a reader John S. from the Great Britain on his sense alongside trading technology scientific discipline as well as models:

"I convey been developing my ain personal automatic trading systems using Excel VBA as well as based on rules I convey developed over the years every bit an active individual trader investor using both technical as well as cardinal information analysis.

One of the key merits inwards adopting an automatic trading arrangement approach that has helped me is to avoid the temptation for manual interference as well as thereby improving profitability yesteryear maintaining consistency. I convey institute the challenge of developing a successful arrangement really rewarding from a personal perspective every bit I recognise that in that place are many that convey tried as well as failed. However i employment I convey encountered is my ongoing wishing to regularly modify as well as ameliorate the arrangement which I convey institute tin larn counter productive every bit in that place is a existent danger that arrangement evolution becomes an goal inwards itself! I merely can't seem to halt tinkering every bit presently every bit I come upwards up alongside a novel stance or feature!

One payoff of using Excel VBA that I convey institute is that it is inherently flexible every bit it facilitates the processing of information which tin hold upwards of import particularly when using cardinal information every bit purpose of the system. In this honor I recognise that every trader is trying to construct inwards an border that volition brand the arrangement to a greater extent than profitable. I convey noticed that many traders seem to alone focus on cost yesteryear trying to seek an border yesteryear looking at special indicators or combination of indicators etc. Combining cost information analysis alongside a Factor Model approach is a challenge which is ideally suited Excel VBA every bit it tin hold upwards easily used to procedure both cardinal as well as macroeconomic information into a bird that tin hold upwards integrated alongside cost information analysis.

I recognise from your mass that Matlab is to a greater extent than powerful than Excel VBA as well as may hold upwards merely every bit flexible inwards integrating cardinal as well as macroeconomic information but I merely wanted to depict your attending to benefits I convey institute using Excel VBA which may suit those who similar myself are to a greater extent than comfortable inwards using Excel VBA as well as are reluctant to change. Other features that tin hold upwards exploited that I convey institute helpful when dorsum testing are automatically producing Price Charts that comprise Entry as well as Exit points which provides visual reassurance that the arrangement is working every bit intended every bit good every bit generating automatic Word reports recording key output for futurity reference.

I am sad if I audio likewise much similar an cite for Microsoft!"