Welcome to the Traders Laboratory Forums.
Open E Cry The unofficial Open E Cry forum.

Reply
Old 08-04-2009, 03:21 PM   #1

Join Date: Jan 2008
Location: San Francisco
Posts: 394
Ignore this user

Thanks: 17
Thanked 338 Times in 156 Posts

Building Customized Dashboards in Excel

example of Market Profile Type of Dashboard

Lets see some of yours

Attached Thumbnails
Building Customized Dashboards in Excel-mp-snapshot.png  
Frank is offline  
Reply With Quote
Old 08-04-2009, 07:09 PM   #2

UrmaBlume's Avatar

Join Date: Apr 2008
Location: Las Vegas
Posts: 670
Ignore this user

Thanks: 87
Thanked 618 Times in 251 Posts

Re: Building Customized Dashboards in Excel

Quote:
Originally Posted by Frank »
example of Market Profile Type of Dashboard Lets see some of yours
While not presented in Excel here is our idea of a real market dashboard.

The top line shows longer term trader commitment so far that session as well as current trade flow as measured by contracts per minute.

The red, yellow and green bars are buy/sell signals in 11 different time frames and a are constantly changing throughout the session.

Blue bars on the left show the percentage of time of day normalized volume in 6 different time frames.

The pie charts demonstrate the buying and selling during the most recent blocks of trade and are constantly pulsing with surges of buying and selling power.

The price ladder in the middle shows current and recent prices.

The red and green bars on the right show time of session normalized trader commitment over 6 time frames.

The balance of trade is shown on the bottom left and price on the bottom right.


UrmaBlume is offline  
Reply With Quote
Old 08-04-2009, 08:08 PM   #3

Join Date: Jan 2008
Location: San Francisco
Posts: 394
Ignore this user

Thanks: 17
Thanked 338 Times in 156 Posts

Re: Building Customized Dashboards in Excel

cool graphics, thanks for posting.

can you tell me how the '% average time of day volume' is computed? I get the idea -- just curious how its being more precisely calculated. I assume that is something like 'this volume bar as a percentage of the past (5) days average volume during this same time bar' ?..?..?
Frank is offline  
Reply With Quote
Old 08-04-2009, 08:27 PM   #4

UrmaBlume's Avatar

Join Date: Apr 2008
Location: Las Vegas
Posts: 670
Ignore this user

Thanks: 87
Thanked 618 Times in 251 Posts

Re: Building Customized Dashboards in Excel

Quote:
Originally Posted by Frank »
cool graphics, thanks for posting
can you tell me how the '% average time of day volume' is computed? I get the idea -- just curious how its being more precisely calculated. I assume that is something like 'this volume bar as a percentage of the past (5) days average volume during this same time bar' ?..?..?
Thanks for the kind words.

We divide the day session of the ES into 405 windows of the appropriate length for each of the six different time frames and then compare volume & commitment to that same (each of six) lengths, updated every minute throughout the 405 minute session to the same levels of volume and commitment over the previous 62 days. It tells us how current activity in 6 different time frames compares to activity in those same time frames - at those same times of day in the past - compare to today's activity.

The idea is that what is a lot of either volume or commitment during the middle of the sesion is actually very little during the first or last parts of the session - hence "time of day normalized."

This comparison is a help in spotting "out of sequence" activity in either volume or commercial trader commitment.

BTW - I notice San Francisco - we moved to Las Vegas from Hillsborough - just south of you - Cheers

Last edited by UrmaBlume; 08-04-2009 at 08:33 PM.
UrmaBlume is offline  
Reply With Quote
Old 08-09-2009, 05:45 PM   #5

Join Date: Jan 2008
Location: San Francisco
Posts: 394
Ignore this user

Thanks: 17
Thanked 338 Times in 156 Posts

Re: Building Customized Dashboards in Excel

following up on the graphics --- I was curious what that dashboard was written in --- ie, which technologies create a richer user interface such as that one? the key with dashboards is to customize it to the particular users style -- because everyones is a bit different --- but the foundation technologies would be the common ground, do you know which were used?
Frank is offline  
Reply With Quote
Old 08-09-2009, 06:27 PM   #6

UrmaBlume's Avatar

Join Date: Apr 2008
Location: Las Vegas
Posts: 670
Ignore this user

Thanks: 87
Thanked 618 Times in 251 Posts

Re: Building Customized Dashboards in Excel

Quote:
Originally Posted by Frank »
following up on the graphics --- I was curious what that dashboard was written in --- ie, which technologies create a richer user interface such as that one? the key with dashboards is to customize it to the particular users style -- because everyones is a bit different --- but the foundation technologies would be the common ground, do you know which were used?
While we deploy several versions, this particular version is driven by data exported from Trade Station on a tick by tick basis via our own dlls to the application itself which was written in C++.
UrmaBlume is offline  
Reply With Quote
Old 09-09-2009, 08:56 PM   #7

Join Date: Dec 2008
Location: Florida
Posts: 76
Ignore this user

Thanks: 0
Thanked 13 Times in 8 Posts

Re: Building Customized Dashboards in Excel

UrmaBlume, could you please describe how long term trader commitment is computed to some degree. I unfortunately am still confused by this.
davewolfs is offline  
Reply With Quote

Reply

Thread Tools
Display Modes Help Others By Rating This Thread
Help Others By Rating This Thread:


Similar Threads
Thread Thread Starter Forum Replies Last Post
Building a GAP Trading Strategy brownsfan019 The Candlestick Corner 42 04-19-2012 02:53 AM
Building Your E-mini Trading Strategy CME Group Knowledge Trading Center 1 08-07-2008 10:12 PM
building a track record? darthtrader Market Analysis 7 06-22-2007 11:19 PM
Building a Computer System wsam29 General Discussion 5 03-04-2007 06:28 PM
Another Plane Crash Into A New York Building! Rohitpatel General Discussion 1 12-04-2006 10:42 PM

All times are GMT -4. The time now is 07:48 PM.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
CS to VB integration by DeskLancer
©2006-2011 Traders Laboratory, All Rights Reserved.