Office Management Spreadsheets

This sheet works with daily data, up to above five years,  in .xls format; there is an excel macro to convert .txt files in .xls files . It allows you to view all classic indicators, running a macro, while lenght parameters can be changed in the assigned indicator cell. You can easily draw normal and parabolic trendlines, joining highs or lows and zoom and scroll functions improve the candlestick view . The most interesting value is the possibility to build personal indicators and trading systems, besides the default ten systems, by the help of Excel cell syntax and a number of already built defined names (among them :buy,sell,stop,mantain). Profit/loss performance is immediatly shown in a chart, and can be adjusted in changing values of commissions for unit dealt and stop loss multiplier (linked to the function ATR). Is it also possible to calculate an average profit loss profile testing more systems on one stock or more stocks for a single system. With the right use of excel expression you can test even high level of complexity in the construction of your trading system.

Thanks for contacting me at paolo.bozza@alice.it