Jump to content

Welcome to the new Traders Laboratory! Please bear with us as we finish the migration over the next few days. If you find any issues, want to leave feedback, get in touch with us, or offer suggestions please post to the Support forum here.

  • Welcome Guests

    Welcome. You are currently viewing the forum as a guest which does not give you access to all the great features at Traders Laboratory such as interacting with members, access to all forums, downloading attachments, and eligibility to win free giveaways. Registration is fast, simple and absolutely free. Create a FREE Traders Laboratory account here.

Frank

Building Customized Dashboards in Excel

Recommended Posts

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.

 

 

GHUDGG.jpg

Share this post


Link to post
Share on other sites

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' ?..?..?

Share this post


Link to post
Share on other sites
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

Edited by UrmaBlume

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites
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++.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Topics

  • Posts

    • ...hallucinates.... Student: “What if we gave the monkey LSD?” Guru: “The monkey already did LSD”
    • Question: To those that had/have cancer, what were the signs that made you think “something is not right here” to make you go see a doctor? Answer: So, 5/25/2018, I woke up, got ready for work, and as I walked to my car, I started gagging. Like something was stuck in my throat and I needed to clear it. And then it went away.   But 10 minutes after that, I was T-boned at 40mph on the driver side door. But what made me see a doctor was while my muscles felt better and bruises were going away, the gagging still continued, I started having fevers, my neck felt swollen, I was having such a hard time breathing, and I'd have random sharp pains in my chest, but not from where the seat belt saved me.   2 weeks after the accident, I finally see an urgent care doctor, who looks me over, tells me I'm fine, but luckily requests a neck X-ray. And I ask for a chest X-ray, which he rolls his eyes but let me have (most of my pain was in the neck, so I understand).   The very next day, he calls and says “So, that chest X-ray shows there's a 4 inch mass on your heart and lungs, and your lungs have been filling up with fluid, as well as in your pericardial (heart) wall. We need you to come in tomorrow.”   Turns out the big mass, due to the accident, caused my heart and lungs to tear and fill with fluid, the swollen neck and gagging was caused by 2 metastasized tumors, and the fevers and weight loss were symptoms. Stage 4b Hodgkin's Lymphoma.   But thankfully, we went very aggressive with chemo (and had a lot of bad side effects that don't normally happen to patients), and now I'm about 16 months cancer-free. Yay lucky X-rays! Rachel Jurina, Quora Source: https://www.quora.com/To-those-that-had-have-cancer-what-were-the-signs-that-made-you-think-something-is-not-right-here-to-make-you-go-see-a-doctor   Profits from free accurate cryptos signals: https://www.predictmag.com/  
    • As a man, the reality of life is the harshest part. I don’t mind looking older or becoming weaker over time; it’s nature.   Have you ever heard that the only people who will be loved unconditionally are women and children? Men will only be loved as long as they can provide until they are no longer needed. It doesn’t matter if you already did your best to get your kids to the best school or get the best things for them, if you stop before they’re done with it, there will be no thank you. The only thing they will remember is that they have to quit school at 15, ignoring all the previous 15 years of life you provided for them. The only people who will accept you, no matter what, are your parents. But in this situation, you might be that ungrateful child.   EDIT: Wow, I didn’t think this would get so much attention.   For those who disagree, I can only say that everyone has their problem. If you don’t get the chance to face such a thing, be grateful. Remember, sometimes what you throw in the garbage is something that someone wishes ever to have.” – ElZee, Quora   Profits from free accurate cryptos signals: https://www.predictmag.com/    
    • The good thing i had noticed so far is that the traderpot value is also on the rise..
    • yup its a gradual rollout the right way in my opinion, its really good and its exciting for the sto in 2027
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.