An alternate solution that works a good percent of the time was too us a formula to look up the first and last numeric values in this column C and then use a combination of the indirect/address/match/index functions and then use the maxdrawdown function which you defined. The solution seems to be defining a formula using the Name Manager…but that has not worked. Column C follows the above mentioned formula, and lets assume in cells D1 and E1 I have the dates and, so in other words column C displays only the prices of the trading days in February. Next in column C I have a formula which states, only display the values from column B if the dates in column A fall within a certain allowable range, which is defined by date in values in cells say, D1 and E1.įor example, column A has the dates for the first 100 trading days of the year, next column B has the prices for the first 100 trading days of the year. How would you accommodate this for flexible dates? Say in column A I have 100 dates (100 rows long), and in column B I have 100 prices (100 rows long). if there are recent increases it still is defeated by the fact that the trend is downward - we are making the assumption that the difference between the LOCAL minima and maxima are irrelevant to the investor's psychological "experience" within the entire data sample examined).Īlso be aware as you play around with this formula that as you spot check percentage changes to ensure the formula is correct, the formula focuses on the largest PERCENTAGE dip, i.e., later in your time series you could end up having a larger DOLLAR drop, but we assume you are interested in how much you dropped in value on a percentage basis. This newest formula I provide here gives more attention to the previous high RATHER than the more recent high (i.e. One other thing to note is that as you experiment with this formula, due to the choppiness of price series, calculating this metric can mean one thing to one person, and something entirely different to another, depending on what their definition of "relative" mins and maxes are within the data sample. Let me correct that formula I posted earlier to the following:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |