Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Calculating variable stock returns

Hi,

I would like to make a visual of top 10 stocks differences, but with variable return horizon(ie, price_today - price 2 days before, or price_today - price n days before) where n is given by a measure and can be changed in a hover.

The problem is, my data has only three columns and looks like that (example for 2 symbols)

symboldateclose
T116/10/2022100
T216/10/202295
T115/10/202298
T215/10/202290
T114/10/202230
T214/10/202240

 

In this case i could change a hover and get 1-day diference (setting hover to 1), 2-day diference(setting hover to 2) ...

Need Help
Tutorial Requests
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, Anonymous 

     

    You can try the following methods.
    Measure:

     

    price n day = 
VAR _N = SELECTEDVALUE ( 'Table'[date] ) - 1
RETURN
    CALCULATE (SUM ( 'Table'[close] ),
        FILTER (ALL ( 'Table' ),
            [symbol] = SELECTEDVALUE ( 'Table'[symbol] )
                && [date] = _N ) )
    Difference = IF([price n day]=BLANK(),0,SUM('Table'[close])-[price n day])

     

    Change 1 to 2 to get the difference from the previous 2 days.

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

1 Reply

  • v-zhangti's avatar
    v-zhangti
    Community Support
    3 years ago

    Hi, Anonymous 

     

    You can try the following methods.
    Measure:

     

    price n day = 
VAR _N = SELECTEDVALUE ( 'Table'[date] ) - 1
RETURN
    CALCULATE (SUM ( 'Table'[close] ),
        FILTER (ALL ( 'Table' ),
            [symbol] = SELECTEDVALUE ( 'Table'[symbol] )
                && [date] = _N ) )
    Difference = IF([price n day]=BLANK(),0,SUM('Table'[close])-[price n day])

     

    Change 1 to 2 to get the difference from the previous 2 days.

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly