mercredi 22 mai 2019

Convert this formula into arrayformula

short and simple, how can this formula be rewritten into array formula variant? Thanks

=iferror(if(and(GOOGLEFINANCE(B2, "High")>=D2+Now()-Now(), GOOGLEFINANCE(B2,"Low")<=D2),"Filled",if(F2<0.005, "In Threshold",if(and(E2="Long", GOOGLEFINANCE(B2,"priceOpen")<D2),"JumpedG ap",if(and(E2="Short",GOOGLEFINANCE(B2,"priceOpen")>D2),"Jumped Gap","Active")))))

Aucun commentaire:

Enregistrer un commentaire