Get each day’s highest/lowest MACD for the past 5 days

Trianenn · 2023-02-12T16:03:43+00:00

Hello, I’m looking for a way to retrieve the highest and lowest MACD values (the blue line) for each day for the past five days. Could anyone please help me with that?

Viewing 12 posts - 1 through 12 (of 12 total)

Author

Posts
02/12/2023 at 5:03 PM #209556 quote

Trianenn
Participant

New

Hello,

I’m looking for a way to retrieve the highest and lowest MACD values (the blue line) for each day for the past five days.

Could anyone please help me with that?

02/13/2023 at 11:31 AM #209590 quote

Nicolas
Keymaster

Legend

There are different ways to do, so could you just define how you want to use them or display them on the chart? So I could suggest the best solution.

02/13/2023 at 2:00 PM #209607 quote

Trianenn
Participant

New

I’d like to average these numbers to draw a line on the MACD indicator. The purpose is to know when there seems to be an overreaction to the upside or downside.

02/13/2023 at 3:04 PM #209614 quote

Nicolas
Keymaster

Legend

Ok and it will be used on intraday timeframes such as 15-minutes for instance?

02/13/2023 at 4:41 PM #209625 quote

Trianenn
Participant

New

Yes, that’s correct!

Does that mean the code is dependent on the graph’s timeframe and there is no way to search for data in-between given dates?

Does the graph has to have a 5-day history for the data to be retrieved?

02/13/2023 at 6:07 PM #209632 quote
Nicolas
Keymaster

Legend
I was thinking of different manner to do it, here is the code that calculate the mean of the last “period” days of highest and lowest MACD values.
```
period = 5

// ---------------------------
imacd=MACD[12,26,9](close) 

once hh = imacd 
once ll = imacd 

if IntradayBarIndex =0 then 
ii=ii+1
$hh[ii]=imacd
$ll[ii]=imacd 
endif

$hh[ii]=max(imacd,$hh[ii])
$ll[ii]=min(imacd,$ll[ii])

//mean
if ii>period then 
sum = 0 
for i = ii downto ii-period do 
sum=sum+($hh[i]+$ll[i])/2
next
mean=sum/period
endif 

return mean//,$hh[ii],$ll[ii]
```
Trianenn thanked this post
02/14/2023 at 9:11 AM #209646 quote

Trianenn
Participant

New

Thanks a lot Nicolas!

I’m going to give a try and see if I can tailor it further.

Does the graph have to extend beyond the period (5 days) to calculate the values or can they be calculated independently of the graph’s history length?

02/14/2023 at 9:44 AM #209648 quote

GraHal
Participant

Legend

Link to above code added as Log 353 here …

Snippet Link Library

Trianenn thanked this post

02/14/2023 at 10:24 AM #209651 quote

Nicolas
Keymaster

Legend

The chart must contained the X days history visible.

02/14/2023 at 1:30 PM #209663 quote

Trianenn
Participant

New

Is there no way around it?

Can’t we parse historical data even if it’s not on the current graph?

02/15/2023 at 10:52 AM #209725 quote

Nicolas
Keymaster

Legend

No, the highest and lowest values of an indicator calculated upon a data serie must read it and therefore must be visible on the chart.

02/15/2023 at 2:35 PM #209764 quote

Trianenn
Participant

New

Understood, thanks Nicolas!
Author

Posts

Viewing 12 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic.

New

Stuck on this ProBuilder code?

Describe what this topic is trying to build, in plain English, and ProRealAI writes the ProRealTime™ indicator, screener or system for you.

Available in 7 languages

Try ProRealAI

Get each day’s highest/lowest MACD for the past 5 days

ProBuilder: Indicators & Custom Tools

New Reply

Author

Trianenn @trianenn Participant

Summary

This topic contains 11 replies,
has 3 voices, and was last updated by Trianenn
3 years, 8 months ago.

Topic Details

Forum:	ProBuilder: Indicators & Custom Tools
Language:	English
Started:	02/12/2023
Status:	Active
Attachments:	No files