Calculated column

Optuma Scripting
1

Hi I like to add a third column to my watch list that show me the percentage of change between "total call volume"/ Average volume call 5 day.

How I can do it ?

Ciro

third-column.png
third-column.png899×674 90.1 KB

2

Hi Ciro,

These look like Bloomberg data fields so you would need to use the DATAFIELD function for the 2 columns, and use them to calculate the percentage:

TVC = DATAFIELD(FIELD=VOLUME_TOTAL_CALL, LATESTONLY=True);
AVC5 = DATAFIELD(FIELD=VOLUME_AVG_5D_CALL, LATESTONLY=True);
TVC / AVC5

Capture

3

To be honest with you i'm unable to replicate your suggestion.

something is missing.

 

by the way could be usefull to add Always link to instructions. I don't use Optuma as a developer and I easily forget how to do it.

thanks again.

Ciro