Hope some one can help me. I have uploaded data file and .qvw so that the smart person can upload the solution.
I have stock data in date descending order, and created field called "Marker". In this field I have values, of which 50 represents the important line.
1. For every line that has a 50, I need to get the date where the "High Price" field meets or exceed the "Exit_Price" field.
2. Once I have this #1, I then need the number of days between the date found in #1 and the date on the line with the 50.
I am stuck and burned out here. I don't think I cant try anything, I need someone smart to give me a working model. Any help will be greatly appreciated.