Like what you have just read? Digg it or Tip'd it.
Tuesday, June 23, 2009
Can I do it too? Learning Quant
Like what you have just read? Digg it or Tip'd it.
Please use this website in an appropriate and considerate manner. This means that you should cite Finance4Traders by at least providing a link back to this site if you happen to use any of our content. In addition, you are not permitted to make use of our content in an unlawful manner. You should also understand that our content is provided with no warranty and you should independently verify our content before relying on them. Do refer to the site content policy and privacy policy when visiting this site.
Thursday, June 18, 2009
Cleaning your data: A free excel spreadsheet with VBA code to screen your data

There are two ways you can use the file. You can paste your data into the file, click onto the “Try” button, select where you left your data and a new spreadsheet will be generated with the output. Alternatively, you can open the Visual Basic Editor (Alt+F11) and copy the entire code over to your spreadsheet.
There are only 3 main restrictions that I can think of which will require you to edit the VBA code. Your data must be arranged in rows, not columns. And the first and second columns must contain the day and time information respectively. Finally, real tick-by-tick and quote-by-quote data is inconsistent in frequency due to its nature. Hence, such data will show an especially high error rate in my spreadsheet, unless you change the formula.
If you find this post or tool useful, you can help me by promoting my blog to your friends or sharing an article or tool that you find useful or providing feedback on this tool to finance4traders@gmail.com
Alt site: http://sites.google.com/site/finance4traders/
Notes: You need to enable macro to let it work. Please be informed that I am not liable for any damage or losses out of this spreadsheet and no warranty is provided. Ironically, do not worry about viruses. I sent this file to VirusTotal to be scanned by more than 20 antivirus software engine before I uploaded it.
Related Articles: What is good quality historical data?
Like what you have just read? Digg it or Tip'd it.
Please use this website in an appropriate and considerate manner. This means that you should cite Finance4Traders by at least providing a link back to this site if you happen to use any of our content. In addition, you are not permitted to make use of our content in an unlawful manner. You should also understand that our content is provided with no warranty and you should independently verify our content before relying on them. Do refer to the site content policy and privacy policy when visiting this site.
Friday, June 12, 2009
Why technical indicators alone are not enough?
Like what you have just read? Digg it or Tip'd it.
Please use this website in an appropriate and considerate manner. This means that you should cite Finance4Traders by at least providing a link back to this site if you happen to use any of our content. In addition, you are not permitted to make use of our content in an unlawful manner. You should also understand that our content is provided with no warranty and you should independently verify our content before relying on them. Do refer to the site content policy and privacy policy when visiting this site.
Sunday, June 7, 2009
About Finance4Traders
Unbiased trading research: Bringing open source to trading
These days, there are a lot of internet websites that promote materials and courses purporting to help traders. Yet there are surprisingly few websites that compile and publish, in an impartial manner, the profitability of various technical indicators and trading strategies etc. Furthermore, traders tend to be secretive of their strategies and methods. Hence, the first objective of this website is provide unbiased transparent research so that aspiring traders do not need to reinvent the wheel.
Bridging the knowledge gap
Sophisticated models are often explained in an unintuitive manner in books. Most websites do not explain how they work, but promote some software to that aim to help traders get started. Even if the computer code is freely distributed, the trader might need to run it on highly expensive software such as Matlab or SAS. Part of the objective of Finance4Traders is to explain such models to visitors in a highly intuitive manner and help them build these models using commonly available software such as Excel or NinjaTrader.
A hobby site
Finance4Traders is first and foremost a hobby site. No, we still have not come up with a trading strategy, that we believe is highly profitable. After all, the holy grail of trading is not easy nor quick to achieve. Nonetheless, this website helps us to deposit and keep track of our work, and contribute to existing knowledge and disseminate new knowledge. At this stage, we do not intend to charge for, nor seriously provide any services.
Visitors are welcome to comment and exchange ideas.
Like what you have just read? Digg it or Tip'd it.
Please use this website in an appropriate and considerate manner. This means that you should cite Finance4Traders by at least providing a link back to this site if you happen to use any of our content. In addition, you are not permitted to make use of our content in an unlawful manner. You should also understand that our content is provided with no warranty and you should independently verify our content before relying on them. Do refer to the site content policy and privacy policy when visiting this site.