Obtain 'On Balance Volume' from DataStream Python API -- it's expression '058E'

operations04

Hello,

We currently obtain the 'On Balance Volume' using expression '058E' in the Excel plug-in. We would prefer to collect this data using the DataStream Python API.

However, I cannot work out how to write the request. Using '058E' as the 'field' doesn't work: it fails with an error message.

I've also tried using the expanded version of the expression as the 'field' -- which is 'CSUM#((ACH#(X,1D))/ABS#(ACH#(X,1D))*X(VO))'. This returns some data, but the numbers are different to the ones obtained through Excel.

Can you advise on how we should be running this query?

Many thanks.

Jirapongse

@operations04

Thank you for reaching out to us.

I ran the following code and it works fine.

df=ds.get_data(tickers="@GOOGL",fields =["058E(X)"], kind=0)
df

operations04

https://community.developers.refinitiv.com/discussion/comment/121594#Comment_121594

Thank you very much -- that was exactly what I needed to know.