Potential Profit/Loss between Open Date and Current Date

rarpecalibrate — Thu, 03 Apr 2014 13:37:37 GMT

Hi,

Here is my problem:

I have a straight table with all open currency trades. I have the Type, Currency Pair, Open Date, Current Close Price and Profit/Loss. What I would like to do is see the max High for a period and min Low for a period - between Open Date and Current Date eg. Today() per trade?

I have the following example:

I have trades that opened on the 6 March and 24 March. I need to find the highest price between the 6 March and Current Day Price and the 24 March and Current Day Price. There may be different Highs because the period between the 6 and 24 might have had a higher price then the period between the 24 March and current date. Therefore 6 March - Current will have a higher potential profit and the 24 March - Current will have a lower potenital profit.

This is what I have tried so far:

max(total {<Date= {">=$(=concat([Open Date],'","'))<=$(=max([Date]))"}>}High)

The problem is that its taking the high from the period between the 6 March and current, and allocating it to both trades.

Please can someone help me. I hope this makes sense.

Ryan

topic Potential Profit/Loss between Open Date and Current Date in QlikView

Potential Profit/Loss between Open Date and Current Date