good morning to all,
first of all sorry for my ignorance with English and computer science. I need your help to translate a formula that I use in excel. I need to normalize the two sets of data in order to make the spread
((DataSeries 1-min) / max-min)) - ((dataseries2-min) / (max-min))
the spread I would do it on different instruments and for the minimum and maximum mean minimum and maximum of the two instruments in the same period. for example, the minimum weekly monthly or otherwise.
Thank you all (maybe I can plan to understand the logic of writing the power editor)
raffaele
spread of normalized data
-
Henry MultiСharts
- Posts: 9165
- Joined: 25 Aug 2011
- Has thanked: 1264 times
- Been thanked: 2957 times
Re: spread of normalized data
Hello raffaele,
You can program it the following way (HighW and LowW are the highest high and the lowest low for the current week):
You can program it the following way (HighW and LowW are the highest high and the lowest low for the current week):
Code: Select all
plot1(((close of data1-LowW(0)) / HighW(0)-LowW(0)) - ((close of data2-LowW(0)) / HighW(0)-LowW(0)));