Sapphire Standalone (Latest 11.0.0.85)
 and Sapphire Add-in (Latest 11.0.0.32)
Sapphire Standalone (Version 11.0.0.85) Dec 10th, 2017
Fixes
  • Fixed issue with click-once update
  • Fixed issue with TLS 1.0 vulnerability
  • Fixed issue with setup files
  • Fixed issue with regression referencing formulas


Sapphire Standalone (Version 11.0.0.85) Dec 10th, 2017
Fixes
  • Fixed issue with click-once update
  • Fixed issue with TLS 1.0 vulnerability
  • Fixed issue with setup files
  • Fixed issue with regression calculation referencing formulas


Sapphire Standalone (Version 11.0.0.40) Dec 02th, 2015
New Internal Data Sources added to Sapphire
  • BMO USD ABS Spreads
  • BMO USD Secondary - USD - UST
  • BMO USD Secondary - USD - AGENCY
  • BMO USD Secondary - USD - SSA
  • BMO USD New Issue Provincial spreads to 3-Month USD Libor
  • BMO USD New Issue Provincial spreads to 3-Month USD Treasury
  • BMO USD New Issue Spreads - Arbitrage vs CAD (all-in)
  • BMO USD Constant Maturity Curve Points
  • BMO USD GC Repo Rates
  • BMO USD Agency Repo Rates
  • BMO CAD ABS Spreads
  • BMO CAD GC Repo Rates
  • BMO CAD AGENCY Repo Rates
  • BMO CAD Provincial Repo Rates
  • BMO EUR New Issue Provincial spreads to 6-Month EURIBOR
  • BMO USD New Issue Spreads - Arbitrage vs CAD (all-in)
  • CDOR
  • LIBOR
  • BMO USD Swap Benchmarks
  • BMO USD Swap Spreads
  • BMO USD Swap Rates
  • BMO CAD Swap Benchmarks
  • BMO CAD Swap Spreads
  • BMO CAD Swap Rates
  • BMO Swaptions
  • BMO Basis Swaps
  • BMO Overnight Index Swaps

Fixes
  • Re-named 'Gen Query' to 'Add Query'
  • Fixed workspace overflow error
  • Fixed Securities and Fields Selection lag


Sapphire Standalone and Add-in (Version 11.0.0.32) May 19th, 2015
Fixes
  • Fixed charting bug so that the full requested history displayed on chart load
  • Fixed bug with workspaces where deleting rows from a workspace prevented the multi series charting functionality


Sapphire Standalone and Add-in (Version 11.0.0.22) Mar 11th, 2015
Features
  • All charts now use the new BMO Color scheme
  • Increased chart size and layout to improve read-ability
  • Sapphire Add-in now available for 64 bit Excel

Fixes
  • Join Type is now ‘Outer’ by default
  • Sort Order is now ‘Desc’ by default
  • Fixed the ‘Days of Data’ bug in the Security Selection dialog box
  • Fixed chart labels on secondary axis
  • Fixed inverted axis on primary and secondary axis
  • Scheduled emails will continue to work with version updates


Sapphire Standalone and Add-in (Version 11.0.0.16) Jan 28th, 2015
Upgrade Notes
  • Version 10.x Sapphire workspaces and macros are backwardly compatible with version 11.x
  • Version 10.x Butterfly workspaces are no longer supported in version 11.x and will have to be re-built

Features
  • Updated the GUI
  • Added a new real-time data spreadsheet function: =BMO(SOURCE, ID, FIELD) [Beta]
  • Added a new real-time data wizard for generating functions [Beta]
  • Updated the Butterfly search tool to match the Bloomberg's BFLY business logic
  • Added a new re-calculate macro button to the Butterfly results sheet
  • Re-organized BFly report to give more details for each trade

Fixes
  • Fixed re-sizing issue. The workspace area now grows as the application is resized
  • Fixed graphing issue that was preventing time series from being charted on the secondary axis
  • Fixed butterfly workspace emailing bug
  • Re-organized Ribbon control. Removed the redundant Butterfly Workspace button and moved the Strategy Analytics button to its own section


Sapphire Standalone and Add-in (Version 10.0.0.8) Sep 11th, 2014
Fixes
  • Fixed a bug with the Strategy Analytics reports


Sapphire Standalone and Add-in (Version 10.0.0.4) Aug 21st, 2014
Fixes
  • Fixed a bug relating to the auto-update process


Sapphire Standalone and Add-in (Version 10.0.0.3) Aug 20th, 2014
Fixes
  • Rewrote proxy logic to add robustness and to provide better support for automatic proxy configuration


Sapphire Standalone and Add-in (Version 10.0.0.1) Aug 15th, 2014
Features
  • New compression algorithm achieving a 95% compression rate when compared to previous versions -- users will be able to download 20 times more data than before.


Sapphire Standalone and Add-in (Version 9.0.0.50) Mar 4th, 2014
Features
  • Auto-updating of excel report templates
  • Dynamic window sizing for the Sapphire Standalone

Fixes
  • Fixed emailer bugs where some users were unable to access the tool and updated the methodology for added robustness
  • Fixed an issue where users were unable to download data to excel when requesting data that is constant over the request period
  • Fixed data issues with reports accessed through the Strategy Analytics menu in the Excel Add-in
  • Strategy publications now available through the "Show Strategy Publications" menu in the Excel Add-in


Sapphire Standalone and Add-in (Version 9.0.0.44) Jan 29th, 2014
Features
  • Client-side error logging to aid in the resolution of application issues


Sapphire Standalone and Add-in (Version 9.0.0.42) Dec 16th, 2013
Features
  • Butterfly Search macro creation from workspace (button added to analytics ribbon)

Fixes
  • Fixed analytics report emailer (including scheduled task creation)


Sapphire Standalone and Add-in (Version 9.0.0.41) Dec 9th, 2013
Fixes
  • Fixed graph link length bug in Butterfly Search


Sapphire Standalone and Add-in (Version 9.0.0.40) Dec 4th, 2013
Features
  • UST Butterfly Search
  • Updated Strategy Analytics report style

Fixes
  • Fixed multiple login dialogs
  • Fixed exception when graphing a string field


Sapphire Standalone and Add-in (Version 9.0.0.34) Oct 31st, 2013
Features
  • Minor changes to Strategy Analytics report style


Sapphire Standalone and Add-in (Version 9.0.0.32) Oct 22nd, 2013
Features
  • New data added:
    • USD Treasury Notes
    • USD Agency Bonds
    • USD Provincial Bonds
    • USD SSA Bonds
    • CAD Government Bonds
    • CAD Provincial Bonds
    • CAD Agency Bonds
  • Added CAD and USD strategy analytics reports
  • Added charts to strategy reports
  • Update button added to ribbon control

Fixes
  • Fixed save/open functionality in butterfly search


Sapphire Standalone and Add-in (Version 9.0.0.20) Sept 30th, 2013
Features
  • Added PDF strategy reports to ribbon control bar

Fixes
  • Fixed chart labels in credit search tool
  • Updated butterfly search template


Sapphire Standalone and Add-in (Version 9.0.0.10) June 27th, 2013
Fixes
  • Fixed "send as pdf" function not working properly in scheduled email task


Sapphire Standalone and Add-in (Version 9.0.0.8) June 19th, 2013
Fixes
  • Fixed Butterfly pdf report Email attachment not showing image correctly issue


Sapphire Standalone and Add-in (Version 9.0.0.6) June 18th, 2013
Updated Butterfly Search Panel:
  • Added reinvestment rate field
  • Removed risk adjusted returns

Added Send as PDF attachment function:
  • Added send butterfly report and workspace chart as pdf email attachment function


Sapphire Standalone and Add-in (Version 9.0.0.2) May 16th, 2013
Auto Update Feature:
  • Upon release of new add-in version, update will be performed when a new instance of excel is opened
  • Updated contents will be applied to all newly opened excel spreadsheet
  • Reopen is needed for currently opened spreadsheet in order for update to take effect


Sapphire Standalone and Add-in (Version 8.0.0.34) April 8th, 2013
Updated GUI:
  • Added Butterfly Search Emailer
  • Updated Schedule Task components to Windows 7
  • Updated RTD Functions

Fixes
  • Popup dialog position issue
  • Improved RTD performance


Sapphire Standalone and Add-in (Version 8.0.0.28) Mar 8th, 2013
Updated GUI:
  • Added Multiple Chart Options

Fixes
  • Secondary chart axis bug
  • Improved query performance


Sapphire Standalone and Add-in (Version 8.0.0.18) Dec 12th, 2012
Updated Add-in technology for Office 2010:
  • Added Credit Search Tool to the Ribbon Menu
  • Re-factored internal code for improved performance


Sapphire Standalone and Add-in (Version 8.0.0.8)) >October 15th, 2012
Updated Add-in technology for Office 2010:
  • Added Relative Value Tool to the Ribbon Menu
  • Re-factored code for the Floating Rate MBS Calculator

Fixes
  • Fixed bug that was causing query results to be cashed when reading from an xml file
  • Fixed bug that was distorting the RTD wizard in the Ribbon Menu


Sapphire Standalone and Add-in (Version 8.0.0.2) August 1st, 2012
Updated Add-in technology for Office 2010:
  • Created an Excel 2010 Ribbon Menu
  • Created an Excel Embedded version of the Sapphire Tool on the Ribbon Menu

Butterfly Search Tool:
  • Embedded into Excel 2010 BMO Analytics Ribbon menu
  • Searches through ~30,000 butterflies in real-time
  • Searches for reversion-to-mean trades, carry trades, roll trades and risk adjusted trades
  • New filters include butterfly range and butterfly symmetry

Fixes
  • Added additional error handling
  • Internal code optimization
  • Fixed improper handling of regional settings


Sapphire Standalone and Add-in (Version 7.1.0.23) May 31st, 2012
Fixes
  • Fixed auto-complete bug where results were cut short


Sapphire Standalone and Add-in (Version 7.1.0.22) May 10th, 2012
Fixes
  • Fixed installation bug that prevented users from downloading data into excel
  • Fixed excel charting bug


Sapphire Standalone and Add-in (Version 7.1.0.21) May 8th, 2012
Fixes
  • Improved navigation tabs when creating views
  • Improved query performance
  • Improved error messages and handling


Sapphire Standalone and Add-in (Version 7.1.0.20) April 25th, 2012
Features
  • Bloomberg-like Add-in usage
  • Acts like a function instead of a VBA macro
  • No longer requires VBA to run. Data is updated during a spreadsheet re-calculation
  • Allows user to manipulate the query within an Excel cell
  • Simpler re-distribution. No VBA references have to be added
  • Less conflicts with other COM or XLL Add-ins

Fixes
  • Improved error handling


Sapphire Standalone and Add-in (Version 7.1.0.10) Mar 9th, 2012
Features
  • Integrated research link into tool (book icons)
  • Simplified macro creation so that the user doesn't have to manually link the button to the code
  • Faster application start-up time
  • Updated the spreadsheet creation from Excel 2003 to Excel 2010
  • Improved Excel data charts
  • Improved Excel regression charts.
  • Improved web services for faster more robust queries

Fixes
  • Better error checking and reporting
  • Removed dependency on stdole.dll for improved compatibility


Sapphire Standalone and Add-in (Version 7.1.0.4) Dec 5th, 2011
Features
  • Added a new chart type for yield and spread data
  • Added a new chart type for regression analysis when comparing two securities
  • Added more credit curves
  • Added Set Chart Title dialog box to menu bar

Fixes
  • Bad data points were removed from provincial curves
  • Fixed sort errors for some data sources
  • Raw data now includes time stamps
  • Fixed calculation on yield curve butterflies
  • Fixed disconnected formula bar in the view panel
  • Fixed Set date range dialog when days were picked instead of months
  • Fixed edge cases that were causing the program to crash
  • Fixed typos in error messages
  • Updated based components to .NET 4.0 (Full version)
  • Made better usage of web connections to increase performance


Sapphire Standalone and Add-in (Version 7.0.0.34) Aug 16th, 2011
Fixes
  • Fixed regression error on formulas. Now the regression is independent of checked rows, and will only graph rows that have had their regression variables selected.


Sapphire Standalone and Add-in (Version 7.0.0.33) Aug 14th, 2011
Fixes
  • Fixed missing options in the Yield dialog box inside the History tool.


Sapphire Standalone and Add-in (Version 7.0.0.32) Aug 10th, 2011
Fixes
  • All version numbers on Sapphire and Sapphire add-in updated to 7.0.0.32.
  • In the Multi-Select dialog box the Clear button is now functional.


Sapphire Standalone and Add-in (Version 7.0.0.30) April 15th, 2011
Features
  • Multi-select allows charting of multiple sets of data (MultiChart).
  • Graph Type tab introduced to allow users to quickly change what formulas are displayed on the History Tool graph.
  • Print Options now contains Print Preview and Print Setup (allows for selection of paper size, paper margins, and page orientation).
  • Show Raw Data now shows multiple columns of data if the graph is a MultiChart.
  • Show Raw Data has now has a Copy Data to Clipboard button.

  • Checkbox on the title row of Sapphire Grid can select/deselect multiple entries at once.
  • Graph icon on the title row of Sapphire Grid allows MultiCharting (charting multiple data sets).
  • Regression button now properly allows Regression charts in Excel.
  • Workspace is now a dropdown menu, allowing the user to create the macros from an XML file or an XML string.
    • Create Macro from XML File first saves the workspace as an XML file, then uses a file reference inside the Excel function.
    • Create Macro from XML String generates the XML string within the Excel function. This means the macro no longer depends on an external XML file, but will not be able to receive further updates from the Sapphire Tool (e.g. by overwriting the XML file with a new workspace).
    • Sapphire Grid now supports moving average calculations (example: "=ma(A1, 4)")
    • Autocomplete Search box added.  After a security and a field have been chosen using the search tool, click on the plus sign to generate query.