Hello everyone,

Here goes my story for the The Data Geek Challenge

I took the Stock values from the EUR/USD from 01.01.1971 to today (Monthly values)

Well I think I first need to explain a little:

-every monthly entry has an Opening, Closing, High, Low price

With this info I started.

I was curious about some statements you hear the last time:

-is the range (difference between High and low) bigger the last time

-can I simple visualize the bigger and smaller stock market crashes

Well Here are the visualizations :

First up, the tag cloud representation for the dates were we had the biggest negative range (Open-Close)

Well indeed the difficult years (crashes and other big pull downs) are nicely in the center!

And see there…2008 was actually the biggest monthly fall from 1971 till now!

Capture.JPG

In a Phie Chart…we also see…at 1.10.2008 we had a drop in the EURUSD of 2.24%…

Capture2.JPG

Same view in the Tree Map

Capture3.JPG

And we also can see that the ranges go bigger and bigger if markets are dropping

Capture4.JPG

Well it’s it’s a nice tool I think… maybe not that suitable for Stock-markets….

Anyway I learned the basics of SAP Lumira

Best regards,

To report this post you need to login first.

9 Comments

You must be Logged on to comment or reply to a post.

  1. Henry Banks

    hi,

    some issues with your graphics, not all screenshots are showing.

    also i would recommend using Boxplots – they are perfect for displaying ‘ranges’ .

    and maybe use a Rank for ‘top 25’ by years, or something?

    another point , you got a typo for ” Pie charts”

    Also, can you quantify and qualify your conclusions better ?

    regards,

    H

    (0) 
        1. I. Braun Post author

          Hi,

          Strange….I see all the pictures in the blog?! as well in edit view as well in show mode..

          What I’m doing wrong then… 😕

          Well I inserted the pics again…hope this is working…

          (0) 
          1. Irshaad Bijan Adatia

            There appears to be a total of 8 photos.

            #1, #4, #6, and #8 are NOT showing.

            Please fix those by editing this post, deleting the photo’s, saving the blog post, and then going back in and uploading the photo’s one more time. (Don’t forget to save)

            Once that’s done let us know, and we’ll confirm on our side.

            It could be just a simple refresh required for the server.

            Thanks for your co-operation!

            (0) 
            1. I. Braun Post author

              wellwell….

              strange…strange… I only have 4 images NOT 8 images ….?!

              anyway…I deleted everything, saved it..copied the old tekst back, inserted the images again and saved it again… Hope that’s working.

              (0) 

Leave a Reply