Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

When using an IF statement, why does the column “Bar” only return the Close, not the Open, High, Low, Close?

April 26, 2017bar column high low Return

0

Posted

When using an IF statement, why does the column “Bar” only return the Close, not the Open, High, Low, Close?

1 Answer

0

Posted

The following example query will only return the Close of DELL. SHOW 1: IF Date is 7/13/2001 THEN BAR of DELL ENDIF WHEN Date is 7/13/20 When Bar is unused in a value context it reverts to Close. To show the Open, High, Low, Close you will need four IF statements.