Sharing investing and trading ideas. Helping traders get started.
Advertisement

Thursday, June 11, 2009

Excel VBA and Tips about Excel

Excel is a ubiquitous tool in the office. Most office workers today are expected to know some amount of Excel programming, inclusive of basic VBA skills. When applying for entry level jobs, claiming that you are competent in Excel programming now implies that you are able to program automation or COM add-ins - not something that many people can do. Therefore, it is important to have some VBA skills. In trading, Excel offers an extremely high degree of the flexibility and customizability for small-scale backtesting projects.

Contents


Your (and my) first step before you do any actual Excel VBA coding or editing. You never know who might be reading your documents.


A look at what are some of the pros and cons for using Excel and VBA programming.


Some programming habits that will increase your productivity. Comes with VBA code.


A useful tool to check if your data has errors in it.


A much faster way of extracting data from the web.


Includes steps on adding descriptions and categories to your UDFs.



Like what you have just read? Digg it or Tip'd it.
The objective of Finance4Traders is to help traders get started by bringing them unbiased research and ideas. Since late 2005, I have been developing trading strategies on a personal basis. Not all of these models are suitable for me, but other investors or traders might find them useful. After all, people have different investment/trading goals and habits. Thus, Finance4Traders becomes a convenient platform to disseminate my work...(Read more about Finance4Traders)

0 comments:

Post a Comment