Results 1 to 9 of 9

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

Threaded View

  1. #9
    Forum Contributor
    Join Date
    03-31-2010
    Location
    Norway
    MS-Off Ver
    Excel 365
    Posts
    632

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

    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!
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Conditional formatting data bars into quartiles/multiple stock charts
    By kcranick in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-06-2014, 03:05 PM
  2. Stock charts - adding extra data series
    By alexisjohansen in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 08-24-2014, 12:24 PM
  3. Requesting for Stock market Technical indicators excel formulas?
    By sreedharkadam in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-03-2014, 03:02 AM
  4. Transpose data into a tabular format
    By fausto1234 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-09-2012, 02:04 AM
  5. Help In Requesting Data
    By pasteis in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-03-2012, 01:14 PM
  6. Stock charts - adding extra data series
    By steven723 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-04-2008, 05:58 PM
  7. Need Help Converting Tabular Data to Columns
    By raja3122 in forum Excel General
    Replies: 1
    Last Post: 05-07-2005, 06:59 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1