MixedHerbs

Hello. I have a pension policy that allows me to allocate money across 361 funds. I want to build a list of those funds in Excel together with price history. I would calculate Relative Strength by comparing each fund to an index made up of all funds in the list. My intention is to sort the list so that the funds with the highest strength appear at the top. My question is, how do you compare Relative Strength over time? Comparing it on a single day is easy, but choosing a fund that has the higher strength over the last three months (say) is trickier. Peter.

Quote from ZDO; "Building an array of setups is a good idea..." That's not quite what I meant. My intention is to arrange the data in such a way that it can be searched as efficiently as possible - probably using bitmaps. Before indexing, I would convert the raw data into a form that made volumes and prices the same scale. I would take the last period's data for a share price, convert it into the same form as the index, then work my way backwards to discover if history has repeated itself. As you say, there will need to be some adjustment for "granularity", but it will be fun to discover. Searching for contextual layers is an interesting idea, thank you. I will put some thought into that. Regards, Peter.

Hello, I am about to start a hobby-project that will hopefully get a nagging idea out of my head. However before starting, I would like your views on whether it is completely daft. It involves: 1. Grabbing as much historical data as possible for a whole market. 2. Arranging the data in such a way that the whole database can be searched for a pattern formed by the last 15minutes (say) market activity. 3. Count how many times a scenario has taken place before - if at all. 4. Extract details of what happens next. 5. Decide if the odds of making money are good. 6. Search/calculation time to be less than a second. Has anyone tried this before? I have searched the forum, but found little. I apologize in advance if I missed something obvious. Regards, Peter.