Recent content by marktheman

If you are looking at tracking stocks with the most daily price movement and you do this with 10 years of daily prices and then compare the results with other stocks the user will determine the stocks which show the greater daily change.

I would start with a sample of 50 stocks. I would download the historic data from yahoo finance. I would transfer the data to a single excel page. For the day's range for each stock simply divide the day's high by the day's low, use this simple formula =((a1/b1)-1)*100 where a1 is the cell...

Hi, I've created my own tradable index which is based on hedging various indices, currencies and interest rates. The index over the last 7 years has had a low of 8180 and a high of 13200. Its current value is 11416. The index cannot fall to zero or raise to infinity. I would be very grateful...