In my last post, I have discussed the most important Excel function when creating Excel-based applications for personalized backtesting and stock screening - the web query.

In this post, we shall look at the next most important Excel function - macros.
Macros has made Excel programming a lot simpler for me. Well, I cannot remember every […]

Popularity: 15% [?]

In this first part of the series of articles describing Excel Techniques for Personalized Backtesting and Stock Screening, I shall introduce the most important Excel function of all - the web query.

1. Let’s say I want to use the data from this webpage from MSN MoneyCentral, I would browse to this particular page in my […]

Popularity: 16% [?]

The market goes into volatile mode as we enters the earnings season. The market seems to be some sort of consolidation. Check out the daily charts for Dow Jones:

and for S&P500:

Check out the above Fibonacci Retracement levels. Wonder if traders all over the world are looking at the same levels or what! No wonder some […]

Popularity: 12% [?]