Hi I am looking for a stock calculator. I do back testing of my trades manually and it takes a lot of time. I am looking for a back testing tool preferably a free or inexpensive one.
It should be a type in which I can input all of my transaction dates (20 to 30 dates = one year's worth of trading) and any trading symbol and then it would automatically calculate the results at market open (and if possible closing) prices for that symbol.
The progrma could look something like this:
Stock symbol: Nok (Nokia)
Buy 1.15.07 market open.
Sell 2.18.07 market open.
Sell short 2.18.07 market open.
Cover short 3.23.07 market open.
Buy 3.23. market open.
Results for the above trades:
At open prices: Long only +10.5% . Long and short +22%.
At closing prices: Long only -8.2%. Long and short +5%.
Save the trade dates? Yes / No.
The program would get the data from Yahoo or some other source and would give the percentage change - or + for all these transactions for that symbol.
It would be great if the transaction dates could be saved for a future use with other symbols at later date. It could have one portfolio or transaction date list that can be saved and one for testing other dates.
Minimum transaction that the program should have is 10 transactions, but 20 to 30 transactions would be better if this is not difficult to make.
Again if it is not too difficult to do: It would be great to have the results for long only, and long and short.
And if not difficult: it could give a percentage gain or loss for every individual trade, but a total gain or loss would be ok too.
Also if it is not difficult to make; it would be great to have it give results at closing prices too.
It could be a program or a web based, whatever is easier to do.
This site has something similar but it is way too sophisticated. I am looking for a as simple and inexpensive version of it as possible.
http://www.timingcube.com/results/#cumulative
If you have one or are willing to develop one let me know, thanks. Tim