Linest_ function

[brunolelli87]

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 

[chrismarlow]

Hi,

Something like;

LinEst_B(aggr(Sum({<TICK={'GGBR4'}>}VDAF),DVPG),aggr(Sum({<TICK={'ITUB4'}>}VDAF),DVPG))

?

Cheers,

Chris.