SPDR S&P Kensho Smart Mobility ETF Dashboard

Traders and investors have a multitude of opportunities for theme investing. That is, ETFs are structured to invest in companies that are part of an industry, such as Biotech, Internet, Aerospace, etc. One such example is the SPDR® S&P Kensho Smart Mobility ETF.

According to the State Street Global Advisors’ website, this ETF “seeks to provide investment results that, before fees and expenses, correspond generally to the total return performance of the S&P Kensho Smart Transportation Index (the “Index”).”

“Seeks to track an index that is designed to capture companies whose products and services are driving the innovation behind smart transportation, which includes the areas of autonomous and connected vehicle technology, drones and drone technologies used for commercial and civilian applications, and advanced transportation tracking and transport optimization systems.” More details are available here: https://www.ssga.com/us/en/individual/etfs/funds/spdr-sp-kensho-smart-mo...

The downloadable Excel dashboard has three quote sections. The top section allows you to enter in symbols (equities and ETFs only). You can see a 5-minute sparkline chart detailing the current session price action. Also, the Bid, Last Trade, Ask, with a highlight that if the current Bid is above the Last Trade the Bid price is highlighted with the color green and the if the current Ask is below the Last trade then the Ask price is highlighted with the color red. Net Change and Percent Net Change is displayed with Percentage Net Change heat mapped. Similarly, the Open, High, and Low are displayed. If the Last Trade is within two cents of the current High then the High is highlighted with a green background. If the Last Trade is within two cents of the current Low then the Low is highlighted with a red background.

Below this quote section is the top and bottom performing fifteen stocks from the ETF. The percent net change is used and is dynamically ranked throughout the trading session.

There are three charts. The first displays the ranked top 15 stocks with their percent net change for the session. The center displays the ranked bottom 15 stocks with their percent net change for the session.

The final chart displays a market with a user input symbol. To properly scale the chart press the “Rescale” button.

Requires CQG Integrated Client or CQG QTrader, data enablements for NYSE and Nasdaq stocks, and Excel 2010 or more recent.

Standard and Poor’s®, S&P® and SPDR® are registered trademarks of Standard & Poor’s Financial Services LLC.

Downloads

CQG Integrated Client
Get a 2-week free trial

Learn More:

Microsoft Excel is a registered trademark of Microsoft Corporation in the United States and/or other countries.