Hello to everyone, sorry if this has been asked before or in the wrong place.
A little about me, I am currently out working in Afghanistan so internet access is slow and not very reliable.I am from the UK and mostly trade ftse shares. I currently trade what I would consider a medium to long term, I choose shares that match my set criteria, this includes market cap, PE, debt, growth etc etc. At the minuite I scan once a week or so to find shares that match my criteria, then do my research and if I am happy I invest using a trailing stop loss. I do this using data from ADVFN then put this in a spread sheet and apply filters for the results.
Now what I want to do is look back using data to a point in time, run my filter to match my criteria from then onwards, then back test to see what my results would have been if I had invested in these shares with a set amount. I have been round and round looking for some way of doing this, can I do this with NT ?? I am having real trouble already just trying to load up the ftse all share data !. I am trying to see by changing my criteria what effect this has over profit/loss over time.
If anyone can help me or suggest how I can do this a better way or with a different software I would be eternally gratefull.
I am ideally looking to get online , download the data then run it and make changes offline. Thank you for any help you may be able to provide.
A little about me, I am currently out working in Afghanistan so internet access is slow and not very reliable.I am from the UK and mostly trade ftse shares. I currently trade what I would consider a medium to long term, I choose shares that match my set criteria, this includes market cap, PE, debt, growth etc etc. At the minuite I scan once a week or so to find shares that match my criteria, then do my research and if I am happy I invest using a trailing stop loss. I do this using data from ADVFN then put this in a spread sheet and apply filters for the results.
Now what I want to do is look back using data to a point in time, run my filter to match my criteria from then onwards, then back test to see what my results would have been if I had invested in these shares with a set amount. I have been round and round looking for some way of doing this, can I do this with NT ?? I am having real trouble already just trying to load up the ftse all share data !. I am trying to see by changing my criteria what effect this has over profit/loss over time.
If anyone can help me or suggest how I can do this a better way or with a different software I would be eternally gratefull.
I am ideally looking to get online , download the data then run it and make changes offline. Thank you for any help you may be able to provide.
Comment