Downloading single stock data of an index

If you are investing foreign markets you need to calculate some indicators by yourself. For example New highs and new lows indicator requires additional effort to estimate for the non-US markets e.g. Turkey, germany etc..

There are many websites for the US markets which provides also such kind of indicator graphs.
But for other cases we need to calculate this by ourselfts. The below excel macro shows you how you can download the 30 DAX stock data to make new highs new lows analysis of the DAX index.