Average volume over the past 5 days as a single value-'CLc1'

Chaitra_M

Is there a code to pull a single average volume over the past 5 days rather the timeseries in API for the code-

As per checking, there is none and request you to check and advise if the below can be added-

As the client needs one single volume to be retrieved instead of timeseries 5 days volume.

rd.get_history(
    universe='CLc1',
    fields=['ACVOL_UNS'],
    end='2025-02-18',
    interval='daily',
    count=5)

raksina.samasiri

Hi @Chaitra_M ,

In this case, the user can pull timeseries data of volume over the past 5 days and then use Python code to calculate the single avg volume on their side.

I hope this helps and please let me know in case you have any further questions.

Chaitra_M

https://community.developers.refinitiv.com/discussion/comment/125293#Comment_125293

Hello @raksina.samasiri thanks for the above information, I will share this information with my client.

So I would like to check if there is any possibility of making syntax available for the clients to show the avg volume in future?

Jirapongse

@Chaitra_M

Is it this one?

df = ld.get_history(
    universe='CLc1',
    fields=['ACVOL_UNS'],
    end='2025-02-18',
    interval='daily',
    count=5)
df.mean()

Chaitra_M

https://community.developers.refinitiv.com/discussion/comment/125325#Comment_125325

This works thank you so much @Jirapongse