Requesting advice on how to describe financial data (stock charts) as tabular data.

Another day might look like this:

My suggestion looks like this. Please see attachment.

So, I was wondering if there might be smarter ways to organize/present this data. But this was what I came up with...

Any ideas...?

Hi,

You can use charts like this ...

Hi,

That's a very interesting idea for actual charts. A problem I see here though is that the charts are subject to the first and last swing's start and end time, so the charts aren't of equal length. I suppose that could be solved by inserting 15:30 and 22:00 as a static number as the first and last value for each day?

Would also appreciate input on how you created that chart, although I might be able to create it myself.

Anyway, I'm also interested in primarily how to represent my data in tabular format in Excel. But maybe my initial suggestion ain't that bad after all...

Bump...?

Final bump.

Okay. Maybe one more bump then.

I would appreciate advice on:

1. Ways to describe this data in my tables. Maybe my initial proposal is as good as it gets? Or might there be smarter ways that makes it 'easier' to read and sort the data?

I don't have any immediate ideas myself as this was the best I came up with on my own.


2. Ways to visualize the data on charts.

I liked the suggestion by come2me, but was unable to create it myself...

Every day starts at 09:30 and ends at 16:00. I suppose I would have to add both these time values to my tables in order to get consistent charts of the same length/magnitude?

Another idea I like is to simply plot the up moves as vertical bars above a zero line and down moves below. Something like what I'm attaching.

Thanks a lot in advance!