Search results

Hello, I am interested in backtesting setups based on clusters of retracements and extensions that meet near the same price level. This appears to be a non-trivial programming problem due to finding all the swings that are relevant to current price level. The swings may be from years...

This challenge is all for fun. Feel free to participate if you're interested. This challenge came about when I challenged my friends to come up with a better solution for a particular probelm than what I had developed. After my buddy crushed my solution decisively, he offered this...

Here's the file to be sorted, with info on what the final sorted output should look like. Have fun! -- M

Welcome to the First Annual Excel Guru Challenge. Your task, if you decide to accept, is the following: Use formulas (not VBA) to sort a list. Easy enough right? But to make it a little more interesting, the list has some duplicate values so you need to account for each one. Please...

u da Excel Man!!!! Very nice solution. You did in one column what I did in 150 columns.

Thanks dB. Pretty nifty. -- MMM

Thanks for the suggestion. I was able to figure out how to do it though a combination of the MATCH, OFFSET, and MIN functions by searching for all relevant prices all in one row. Resulted in a huge spreadsheet, but good enough for now. Thanks everyone. -- M

Thanks for the suggestion Bdixon. While your technique works, it requires oneto process each row one at a time to find the desired result. I'd rather have Excel do all that work for me automatically, one row at a time. Thanks again for your time and assistance. -- M

Thanks KTM. CountIF returns the sum of the rows that meet the criteria, rather than the row itself. It does at least tell you whether such a row that meets the criteria exists or not. I'm now working on find rows that meet the criitera from N to N+D. I've done some statistical...

The thought occurred to me last night that I might able be able to use the match function to find rows that are from N to say N + delta points from the current row's price So say the current price is 1000, and I'm looking for the first row that is 1003 or larger. I'd do a manual MATCH...

KTM, Thanks for your suggestion. I actually started doing just as you had suggested. For each row, I transposed the current row through the last row of the data set so that I had a flat, one-row high array. Since I'm looking at five minute data, it was a one row x 81 column array...

Mr. Subliminal, Thanks for your suggested fix. I was hoping to find a solution that does not involve sorting the rows. Ideally, I could just copy and paste the formuals associated with one row, all the way down the column. I am hoping to apply these formulas to year's worth of...

Just a revision ... I'm searching for the first subsequent row that is N points or more above the current price, and N points or more below the current price. Thanks. -- M

Hi, Say you have a day's worth of 5 minute price data in a column in Excel. For this example, say you have 81 data points, although the actual number of data points may vary in future applications. For each row of price data, I'd like to find the first subsequent row pf price data that is...

Florida income tax rates are lower than in California.

That's good to hear. Could be that your power supply was not providing enough power to drive all the cards in your system. -- M

Ges, You will of course have to physically remove unnecessary cards from your system (ie, sound cards, controller cards, etc.). Removing excess RAM memory might be good to try as well, leaving you only the bare minimum. Given how much you value your time, might be cheaper to just buy a...

Ges, Did you physically disconnect the components? You may want to try that before you fiddle with the registry or restoring a prior system restore point. That way you'll save your current software settings. -- M

I like your postings MaxMin, even if they may be similar or identical to what others may have already said. Sometimes it takes a while before a message sinks in. Please keep on posting away, and don't let the others who question the originality of your postings to deter you from posting more...

Ges, Have you tried disconnecting the unnecessary components from your system? It's easy to do, and might solve your problem. -- M