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

    • Near Term Outlook Unchanged as AUDUSD Trades Weaker   AUDUSD Price Analysis – August 22 The Aussie is holding weaker so far with the yuan softer on the day on a softer note for the equities and treasury yields. However, yuan has a relative effect on USD as the PBOC fixed the yuan weaker again today, reaffirming the notion that they will allow the currency to weaken but not too quickly.   Key Levels Resistance Levels: 0.7205, 0.7085, 0.6827 Support Levels: 0.6748, 0.6676, 0.6620   AUDUSD Long term Trend: Bearish But as seen in the daily picture above, the near-term picture in AUDUSD remains unchanged despite the pair slipping to session lows on the level at 0.6748 currently. Both buyers and sellers have more work to do to gain more momentum to push prices out of the downward range since last week.   While the forex pair is experiencing a stall, this could just be a correction, as both the medium and long-term trends are still bearish.   AUDUSD Short term Trend: Ranging However, AUDUSD needs to break the monthly support zone on the level at 0.6676, which is currently providing support for the momentum on the pair at the level at 0.6748.   The currency exchange rate will most likely continue to trade downward and flat for today waiting for the required volatility to change the direction.    
    • Staying Within Previous Boundary EURJPY Continues to Trade Within a Range   %2> EURJPY Price Analysis – August 23 In today’s trading session, the common European currency traded sideways against the Japanese Yen. The currency pair was trading below the moving average 5 and 13 since yesterday’s trading session. We may see bearish traders pressurize the currency pair towards the level at 117.50 before the end of today’s trading session.     Key Levels  Resistance Levels: 123.01, 119.88, 118.33  Support Levels: 117.65, 117.50, 117.00    EURJPY Long term Trend: Bearish In the daily picture, the EURJPY pair may most likely maintain the price range during the next trading session. Alternatively, a breakout may occur downwards.  While the exchange rate has been trading within the range of the level at 118.33 and 117.50 since mid-August. The trend is bearish, showing an intact downtrend in the medium and long-term.     EURJPY Short term Trend: Bearish Today’s trading range has been going negative and more, and that’s below the last trading month’s daily average range. On the flip side, we may see a change in trend with renewed upward strength.   Buying could accelerate should prices move above the close-by swing high towards the level at 118.33 where further buy stops might get activated. Although with the level at 119.88 resistance intact, near term outlook remains bearish.  
    • Date : 23rd August 2019. MACRO EVENTS & NEWS OF 23rd August 2019.FX News Today A confluence of factors whipped the markets around Thursday heading into the Jackson Hole Symposium and Chair Powell’s comments Friday at 10 ET. Hawkish remarks from George (she dissented against the July easing) and Harker (who votes in 2020) weighed on Treasuries and erased early gains from Wall Street. Minutes from both Fed and ECB meetings were not quite the all out dovish signal that some had been hoping for and comments from Fed members yesterday also showed a degree of caution with regard to further easing measures. The curve in the US steepened again after inverting briefly overnight, the curve flattened and inverted further in Japan. Stock markets across Asia moved mostly higher although gains remained contained by caution. New Zealand’s central bank governor said he could afford to wait before declining on additional easing measures. Onshore Yuan set at its weakest for 11 years. Japanese core consumer inflation at a 2-year low in July. Meanwhile lingering geopolitical trade tensions and political jitters in Hong Kong, Italy and the UK add to an uncertain backdrop. US futures are also cautiously moving higher. The WTI future is trading at USD 55.37 per barrel. Charts of the DayTechnician’s Corner EURUSD returned to 3-week lows of 1.1064 today, after rallying to session highs of 1.1099 following the sub-50 US manufacturing PMI. Negative European yields appear to be taking their toll on the currency, keeping the Dollar in demand in place for relatively high yielding US Treasuries. This has likely been a major factor keeping EURUSD under pressure, especially ahead of likely ECB easing in September, and perceptions that the Fed will not be as aggressive in easing as previously thought. Key EURUSD level is the 27-month low of 1.1027 seen on August 1. USDJPY rallied to 106.64 highs. The risk-sensitive pairing can be expected to consolidate into today’s much anticipated speech from Fed chair Powell, from Jackson Hole. GBPUSD: Sterling had its best single day rally since March 13 against the Dollar. Cable’s high was 1.2273, which is the loftiest level seen since late July. The gains were sparked by comments made by German’s Merkel, who indicated that a solution to the Irish border backstop conundrum is doable by the October-31 Brexit deadline. UK Prime Minister Boris Johnson followed this up by saying at his joint press conference with France’s Macron that he was encouraged by his talks in Berlin yesterday, and that a deal, he thinks, can be done ahead of October 31. Macron, said, however, that while he has always respected the UK’s decision to leave the EU, the European project has to be protected, to which the Irish backstop remains an important part of ensuring this. Merkel’s remarks were little more than rhetorical platitudes, though enough to trigger a short squeeze in a heavy shorted currency. Main Macro Events Today   Jackson Hole Symposium – Day 2 Retail Sales ex Autos (CAD, GMT 12:30) – Retail sales are expected to have decreased in Canada, with consensus forecasts suggesting a -0.5% m/m decline should be registered in June and an unchanged ex-autos component at 0.3%. In May, Retail sales were disappointing, falling 0.1% for total sales and declining 0.3% for the ex-autos component. The decline in sales was driven by a 2.0% tumble in food and beverage stores. The report casts some doubt on the resiliency of the consumer sector to the ongoing parade of worrisome geopolitical and trade developments. Support and Resistance levelsAlways trade with strict risk management. Your capital is the single most important aspect of your trading business.Please note that times displayed based on local time zone and are from time of writing this report.Click HERE to access the full HotForex Economic calendar.Want to learn to trade and analyse the markets? Join our webinars and get analysis and trading ideas combined with better understanding on how markets work. Click HERE to register for FREE!Click HERE to READ more Market news. Andria Pichidi Market Analyst HotForex Disclaimer: This material is provided as a general marketing communication for information purposes only and does not constitute an independent investment research. Nothing in this communication contains, or should be considered as containing, an investment advice or an investment recommendation or a solicitation for the purpose of buying or selling of any financial instrument. All information provided is gathered from reputable sources and any information containing an indication of past performance is not a guarantee or reliable indicator of future performance. Users acknowledge that any investment in FX and CFDs products is characterized by a certain degree of uncertainty and that any investment of this nature involves a high level of risk for which the users are solely responsible and liable. We assume no liability for any loss arising from any investment made based on the information provided in this communication. This communication must not be reproduced or further distributed without our prior written permission.
    • Thanks for your suggestions man!! Our own decision surely makes us or breaks us. Thanks once again, buddy.
×
×
  • Create New...

Important Information

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