[amibroker] Re: Mathematics What is the mathematical formula to range a continuous time series in a Range of -1 to 1?

 

Thank you Howard Sir.

1) I want to bin the results. so say 
0-0.2
0.2-0.4
0.2-0.6

etc..

2) About Outliers I think it's best to Cap it to -1000 to +1000 

3) About changing ditribution - I am not sure if its going to help?

Here is what i could find so far:

Calculate the range of the data and divide each entry by the range. This gives the required answer.



In this case Range = 300 - (-500) = 800.



Therefore the data now becomes


0.2500 
0.0175 
-0.6250 
0.0000 
0.0375 
-0.0500 
-0.1375 
0.0000 
0.3750 
0.2875 
0.1125

-0.0500 



Does that approach make sense? Any better way of handling this?

__._,_.___

Posted by: meanomalist@yahoo.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (3)
**** IMPORTANT PLEASE READ ****
This group is for the discussion between users only.
This is *NOT* technical support channel.

TO GET TECHNICAL SUPPORT send an e-mail directly to
SUPPORT {at} amibroker.com

TO SUBMIT SUGGESTIONS please use FEEDBACK CENTER at
http://www.amibroker.com/feedback/
(submissions sent via other channels won't be considered)

For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/


.

__,_._,___


EmoticonEmoticon