I belong to a couple of decent stock picking newsletters that have had good results. However, I'm trying to figure out the appropriate risk/reward ratio were I to enter into the various suggested trades. I have a slew of old trade idea records that I would like to analyze (and it would take way too long to click through the charts of each ticker).
Can someone explain how I can create a program that spits out the result of a specific trade, given that I provide the following trade metrics?: (i) ticker symbol, (ii) stop loss price/percentage, (iii) entry price, (iv) profit target price/percentage and (v) shares purchased?
It seems like it should be relatively simple to accomplish - I have all of the data in a spreadsheet and if I can figure out how to code something that will tell me the end result of each trade (e.g. stop loss hit for 2% loss or target hit for 15% gain), that would be perfect.