Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dears,
I've the following database which provides some historical prices per Ticker. Take a loot at it:
DVPG | TICK | VDAF |
01/01/2019 | ITUB4 | 22,30 |
02/01/2019 | ITUB4 | 21,43 |
... | .... | .... |
31/12/2019 | ITUB4 | 20,63 |
01/01/2019 | CVCB3 | 10,33 |
02/01/2019 | CBCV3 | 22,10 |
... | .... | .... |
31/12/2019 | CVCB3 | 25,44 |
01/01/2019 | GGBR4 | 33,11 |
02/01/2019 | GGBR4 | 31,47 |
... | .... | .... |
31/12/2019 | GGBR4 | 32,23 |
And my question is:
How can I create an expression using Linest_B where X = VDAF when TICK is equal to ITUB4, and Y = VDAF when TICK = GGBR4?
Thank you guys,
Best regards
Hi,
Something like;
LinEst_B(aggr(Sum({<TICK={'GGBR4'}>}VDAF),DVPG),aggr(Sum({<TICK={'ITUB4'}>}VDAF),DVPG))
?
Cheers,
Chris.