spread of normalized data
Posted: 15 Sep 2014
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
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