Tabular stock market data. Visualizing it? Finding patterns in the data?

[Elijah]

"I have the statistical data so that I can input the data - of size of upmoves as pluses above and size of down moves as minuses below - a given price line."

Some user on another forum said this several years back and I've been pondering what he meant ever since (he's not around to answer any longer). This relates to stock market data from 09:30 - 16:00. 6,5 hours.

I have tried to collect the size/time of the most significant daily moves and set it up in tabular form. One row per day. I've decided to have a maximum of 5 moves per day.

PL2.png

I measure both the size of the moves and from which price point (measured from the opening price) it starts from.

I wonder if it could be visualized like this:

PL1.png

Anyone have any input as to what that quote could mean? How it could be displayed/visualized?

How would you proceed if you wanted to find similar rows (one day is one row) or patterns in such a dataset?

I'm thinking that 'price line' would simply be a flat horizontal line from which moves are visualized, but I may very well be wrong. Alternatively, this price line would be the opening price.

Thanks in advance for any thoughts on this.

Attaching a workbook with some of my raw data and some of my 'transformed' sheets.

Elijah

[Elijah]

How would you proceed if you wanted to find similar rows (one day is one row) or patterns in such a dataset?

I'm thinking that 'price line' would simply be a flat horizontal line from which moves are visualized, but I may very well be wrong. Alternatively, this price line would be the opening price.

Thanks in advance for any thoughts on this.

Any comments at all?

Would really appreciate it. I know there's some very clever minds on these boards.

Thanks in advance.

Elijah