Skip to main content
Announcements
Discover what’s possible with embedded analytics! March 6, 10 AM ET SIGN UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Get specific values between dates

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.

0 Replies