You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
backtesting using fundamental and technical data
- Thread starter macgibby
- Start date
Quote from gkishot:
This is weird. How would this be possible to program fundamental data like corporate profits for example into your system?
I don't think it should be a problem to use QOQ sales growth or earnings growth as part of the system. But I don't know which software will allow you to do this. Wealthlab or Metatrade don't have this option...
Fundamental data is useless for short term trading. It determines only the long term trends. But long term trend for QQQQ is a buy. You don't need a system for that.Quote from macgibby:
I don't think it should be a problem to use QOQ sales growth or earnings growth as part of the system. But I don't know which software will allow you to do this. Wealthlab or Metatrade don't have this option...
Back-testing with both fundamental and technical data is possible but requires a few extra steps and the right software to support this process.
Technical data is easy to back-test, so I will skip this step.
As for fundamental data, you first need to find a source that you can export into text files for further import/input. TC2000 has a large number of fundamental data fields for each symbol. It also has a COM/OLE API that allows access from third-party tools. What is needed here is to write a small tool (in VB or other COM compatible language) to perform a recursive loop on all stock symbols and export the data fields to a comma, delimited text file.
The next step requires a back-testing program that can read in text files while scanning its stock database. My choice is Wealth-lab. Since it can read from TC2000 also, all technical data will stay in sync. As each stock is loaded, you just open the file containing the fundamental data and load the fields into an array of variables. Then you can process whatever calculations you wish.
This is a more advanced topic; so be ready to get your hands dirty before attempting this.
Technical data is easy to back-test, so I will skip this step.
As for fundamental data, you first need to find a source that you can export into text files for further import/input. TC2000 has a large number of fundamental data fields for each symbol. It also has a COM/OLE API that allows access from third-party tools. What is needed here is to write a small tool (in VB or other COM compatible language) to perform a recursive loop on all stock symbols and export the data fields to a comma, delimited text file.
The next step requires a back-testing program that can read in text files while scanning its stock database. My choice is Wealth-lab. Since it can read from TC2000 also, all technical data will stay in sync. As each stock is loaded, you just open the file containing the fundamental data and load the fields into an array of variables. Then you can process whatever calculations you wish.
This is a more advanced topic; so be ready to get your hands dirty before attempting this.
Quote from bobcows:
Back-testing with both fundamental and technical data is possible but requires a few extra steps and the right software to support this process.
Technical data is easy to back-test, so I will skip this step.
As for fundamental data, you first need to find a source that you can export into text files for further import/input. TC2000 has a large number of fundamental data fields for each symbol. It also has a COM/OLE API that allows access from third-party tools. What is needed here is to write a small tool (in VB or other COM compatible language) to perform a recursive loop on all stock symbols and export the data fields to a comma, delimited text file.
The next step requires a back-testing program that can read in text files while scanning its stock database. My choice is Wealth-lab. Since it can read from TC2000 also, all technical data will stay in sync. As each stock is loaded, you just open the file containing the fundamental data and load the fields into an array of variables. Then you can process whatever calculations you wish.
This is a more advanced topic; so be ready to get your hands dirty before attempting this.
Thank you, I didn't know Wealthlab can do the job... How long back TC2000 has earnings, sales, etc. data?