Linest_ function

brunolelli87 — Fri, 20 Nov 2020 18:58:42 GMT

Dears,

I've the following database which provides some historical prices per Ticker. Take a loot at it:

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

Re: Linest_ function

chrismarlow — Tue, 10 Nov 2020 12:04:30 GMT

Hi,

Something like;

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

Cheers,

Chris.