Hello,
I have a list of numbers in the format 1234.56 on excel
I would like to see if there is a way through excel, macro, script or external programs to find patterns.
The sequences look like this
[TABLE="width: 126"]
<tbody>[TR]
[TD]7680.46[/TD]
[/TR]
[TR]
[TD]7677.38[/TD]
[/TR]
[TR]
[TD]7678.6[/TD]
[/TR]
[TR]
[TD]7675.3[/TD]
[/TR]
[TR]
[TD]7672.99[/TD]
[/TR]
[TR]
[TD]7674.1[/TD]
[/TR]
[TR]
[TD]7670.7[/TD]
[/TR]
[TR]
[TD]7669.46[/TD]
[/TR]
[TR]
[TD]7668.44[/TD]
[/TR]
[TR]
[TD]7669.53[/TD]
[/TR]
[TR]
[TD]7669.63[/TD]
[/TR]
[TR]
[TD]7669.25[/TD]
[/TR]
[TR]
[TD]7668.06[/TD]
[/TR]
[TR]
[TD]7669.14[/TD]
[/TR]
[TR]
[TD]7672.52[/TD]
[/TR]
</tbody>[/TABLE]
etc..
Since it's a project for a trading algo,
It's real. I am sure there is a specific algo.
I have a list of numbers in the format 1234.56 on excel
I would like to see if there is a way through excel, macro, script or external programs to find patterns.
The sequences look like this
[TABLE="width: 126"]
<tbody>[TR]
[TD]7680.46[/TD]
[/TR]
[TR]
[TD]7677.38[/TD]
[/TR]
[TR]
[TD]7678.6[/TD]
[/TR]
[TR]
[TD]7675.3[/TD]
[/TR]
[TR]
[TD]7672.99[/TD]
[/TR]
[TR]
[TD]7674.1[/TD]
[/TR]
[TR]
[TD]7670.7[/TD]
[/TR]
[TR]
[TD]7669.46[/TD]
[/TR]
[TR]
[TD]7668.44[/TD]
[/TR]
[TR]
[TD]7669.53[/TD]
[/TR]
[TR]
[TD]7669.63[/TD]
[/TR]
[TR]
[TD]7669.25[/TD]
[/TR]
[TR]
[TD]7668.06[/TD]
[/TR]
[TR]
[TD]7669.14[/TD]
[/TR]
[TR]
[TD]7672.52[/TD]
[/TR]
</tbody>[/TABLE]
etc..
Since it's a project for a trading algo,
It's real. I am sure there is a specific algo.
Last edited by a moderator: