I want to download McClellan Oscillator Indicator for sp500 using Eikon api with python ?
Upgrade from Eikon -> Workspace. Learn about programming differences.
For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
I want to download McClellan Oscillator Indicator for sp500 using Eikon api with python ?
Hi @soroosh,
May I ask what was the formula in the excel sheet cell in your screenshot?
Hi,
Thank you for your participation in the forum.
Are any of the replies below satisfactory in resolving your query?
If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.
Otherwise please post again offering further insight into your question.
Thanks,
AHS
Hi,
Please be informed that a reply has been verified as correct in answering the question, and marked as such.
Thanks,
AHS
@soroosh So we can get the number of advances and declines historically using our RD library:
import refinitiv.data as rd rd.open_session()
rd.get_history(universe=".AD.SPX", fields=['ISSUES_ADV','ISSUES_DEC'], interval="1D")
From here you can easily create the McClellan Oscillator.
To get the current latest value snapshot you can use the rd.get_data function:
rd.get_data( universe=['.AD.SPX'], fields=['CF_DATE','CF_TIME','ISSUES_ADV','ISSUES_DEC'] )
I hope this can help.
@soroosh I don't think we would deliver the Mclellan Oscillator as a precalc'd item but we have 3 potentially helpful fields - 'TR.ISSUESADVANCED', 'TR.ISSUESDECLINED', and 'TR.25DAYSMEANADVANCEDECLINERATIO' . Once you have these it is pretty straightforward to calculate the Oscillator in Python. However these fields don't seem to be populated which is strange - I have opened a support case number: 12137983 to look into this and will report back as soon as they respond. I hope this can help. Please bear with us.