MarketView ExcelTools 4.5.5

Enhancements

Curve – days, months, and years back feature added just like Desktop. • Change the close field to display settle only.  When checked the close is blank during the day and it holds the settle price during night trading.  • Xchange can now reference formulas using GvUpdatableQuote.  In this example B4 would contain a formula which would then automatically update the symbol every 10 seconds.  =GvUpdatableQuote(“#MVXCHGBRENTCRUDE”, “Hundredths”, B4) • New ‘Upload Prices’ button has been added to the toolbar, turn on MV Xchange to make this button visible.  This flexible tool allows the users to create new symbols and folders dynamically.  Upload prices to the PDH for multiple symbols and multiple dates all at once.   • Moneyness was added to the Options drop down.  Moneyness is the Strike price of an option divided by the price of the underlier with puts displayed under 100% and Calls over 100%.  See the spreadsheet for an example. 

Contract Date

Moneyness

 

50%

75%

100%

125%

14-Sep

Imp Vol of Put

Imp Vol of Put

Imp Vol of Call

Imp Vol of Call

14-Oct

Imp Vol of Put

Imp Vol of Put

Imp Vol of Call

Imp Vol of Call

14-Nov

Imp Vol of Put

Imp Vol of Put

Imp Vol of Call

Imp Vol of Call

 

  1. Symbol Tree enhancements to match MV Desktop.  You can now right-click in the symbol tree to refresh and add folders or edit UDFs.
  1. Open Interest is now a field in Charts
  1. Options ATM count upped to 40.
  1. MarketView Data guide link added to all components.
  1. Additional History fields Display Date and Contract Date.
  1. Shortened the loading time of large historical tables by caching data and eliminating duplicate requests.
  1. Additional ISO blocks 1 x 16 and 2 x 16 which will display weekend dates and holidays. 
  1. Additional header options now allow the user to see only the symbol in the header excluding the description.

Bug Fixes

  1. Symbol descriptions not displaying.
  2. New signed certificate so IE doesn’t block the download.
  3. Fixed the resolution of the ET ribbon.
  4. Fixed max number of rows allowed in a history table.
  5. Fixed several localization bugs.
  6. Various other fixes related to specific spreadsheets.