Market Data Unfair Advantage Posting Status Robert 2016

Unfair Advantage Version 2.10.8 Upgrade Available

Release Date: April 18, 2018
Last Updated: August 16, 2018 (Release 2.10.8.527 BETA RELEASE)


IMPORTANT NOTICE: Do NOT uninstall your current UA for this upgrade. If you do, UA will no longer be usable, and a full reinstallation will be required, from here.

It is strongly recommended that you Backup your portfolio before upgrading in case there is an issue that requires a prior version to be reinstalled. Go to your UA Portfolio menu and select Backup Portfolio. This backup will be placed in your backup directory in a subdirectory using the date of the backup as the name, where it can later be retrieved and restored if necessary. Please contact customer service support@csidata.com for guidance if needed, and refer to this message.

Click here to download the 2.10.8.527 BETA RELEASE upgrade, then install over your current version.

Click here to download the last stable upgrade (Build 494), then install over your current version.

Features include:

Build 527:

  • Weekly, Monthly, Quarterly, and Annual aggregated exports are now updated with the latest recomputed data, rather than being entirely rebuilt after each data update, unless rolls during back-adjustments, whether for futures, or new stock splits/dividends, are detected. Historical corrections will also trigger rebuilds, as well as other custom settings that may be used. But in general, they will be updated to reduce your overall daily download time when using these in your portfolio. There is a global setting that controls this located in the Preferences > Aggregate Data section.
  • CSI, CSIM, and Metastock formats can now be configured to export holidays that contain the prior day prices, or the prior day close. This control is located within Edit Portfolio on the CSIM/Metastock Format page.
  • The Amibroker export format can now be configured to export holidays that contain the prior day prices, or the prior day close. This control is located within the Preferences > Amibroker section.
  • The Price Channel indicator now allows the option to use the Highest and Lowest Close, rather than the Highest High, and the Lowest Low. This is located on the indicators configuration interface.
  • Editing portfolio items that are currently charted, now always reflect those changes immediately when applied. Previously, when changing a futures series from one type of continuous contract to another type, this step was missed, as the software was looking for the previous type of contract among the open charts.
  • An issue with Back-Adjusted and Nth Nearest continuous contracts was discovered that could inadvertently and unexpectedly roll out to a far contract when using V/OI, has been eliminated. In most cases, this had limited exposure, but it was observed to happen under certain conditions.
    For this reason alone, this upgrade is highly recommended.
  • Several charting alignment issues have been cured.
  • The Zoom Box Magnify has multiple levels of depth, which can then be incrementally backed out from by clicking the button twice.
  • The download countdown is reduced from 10 seconds to 5 seconds, enough time to click on the download date control, in the event where prior days need to be recaptured.

Build 514:

  • New ASCII/Excel field feature: @ specifies to include the Spot Contract, with Expiry Date, Closing Price, Volume, and Open Interest with each data record.
  • Trading signals have been added to the Moving Average indicator (optional).
  • Net Volume now represents the Net Change from the previous day.

Build 511:

  • UA now corrects export files when it can: when the correction is for the prior day. Previously, UA was rewriting every file that had a prior day correction. It will no longer rewrite unless it’s necessary: When a roll is detected, a Split and/or Dividend influences the output, it is a historical correction, or an underlying conversion is made. Depending on the size of your portfolio, you will see a reduction in the time it takes to perform a daily update*, especially with large stock portfolios, where volume corrections are transmitted. Futures contracts, and continuous contract files are corrected, too, without a rewrite, when prior day corrections are transmitted.
  • *Note: Your 1st update after this upgrade will be slow due to a portfolio version upgrade. Subsequent updates will then proceed more quickly as a result of this improvement.

Build 504-505:

  • Sunday data, such as that contained within Crypto-Currency rates USDB and USDE, can now be excluded by un-checking the new setting within Edit Portfolio, named Include Sunday Trading Data, located on the Other Settings page.
  • Exported ASCII/Excel data can now be chronologically reversed by checking the new setting named Chronologically Reverse Export Data Order located within Edit Portfolio, on the ASCII/Excel page.

Build 502:

  • The Roll Schedule Report has been updated when specifying the expected roll dates for continuous contracts that roll on days prior to the expiry date. The formulation had not been updated to consider holidays that occur between the expiry date, and the number of trading days prior to the expiry date.

Build 501:

  • Expiry Dates have been added to Settlement Reports.
  • Nth Nearest Futures hold onto the Nth Nearest contract as long as possible until the next Nth contract has begun trading, filling gaps that were previously encountered at times when not using the Strictly Use Absolute Nearest setting.
  • Nth Nearest Futures and Back Adjusted contracts have a new setting when Calendar Date rolling with Days/Months prior from the End of the Month. Roll Prior to Non-Trading Days can be checked so that in cases where you roll a month or more prior, 1-2-3 days before the End of the Month, the software will not roll into the next month if the last calendar days are a weekend of holiday.

Build 500:
Attention Stock Data Subscribers:

We’re offering a new stock sector and industry group convention that follows a broader set of codes. This remains an option within UA in order to preserve the current set of codes used. However, the old set of codes are no longer being assigned to IPOs issued within the last year, so it’s advised to adopt this change.
To enable this new feature, click the Preferences menu and navigate to the Market Specs section. On this page you will find the new setting named Use New Sector / Industry Codes.  Check this option to have your Sector and Industry descriptions follow this new standard.
( Recommended )

    • New Sectors are listed here
    • New Industry groups are listed here
    • Download the latest BETA upgrade above to receive a fully functional version that utilizes this change.

If you have any concerns with this, or if you are using any of our Stock Sector and Industry Indices listed here, please notify us at support@csidata.com to let us know of your concerns, and/or usage of these indices, so we can better plan on how to reconfigure them to use this new standard.

Build 494:

  • When adding Future Days to continuous contracts, the delivery month of the future days now reflects that of the current present day delivery month. The software no longer retains the delivery month used when adding in the Future Days. This functionality will never roll out past the present day.

Build 485-490:

  • Portfolio Right Click menu now contains a Chart feature where you can
    chart one or multiple selections of your portfolio at once.
  • The Settlement report now contains a Percent Change change column.
  • The Settlement report now contains a Highest Volume and Open Interest filter.
  • A new MA Z-Score indicator has been added to the Standard Indicator library.
  • A new Average Monthly Close indicator has been added to the Standard Indicator library.
  • Include charting Holidays and Weekends has been expanded to include filling
    them with prior day prices within charts.
  • Imported portfolios will have delisted symbols automatically removed for those
    whose accounts do not allow for them.
  • A memory leak dealing with charting indicators has been resolved.
  • Charts can now be set with a gradient fill background color.
  • Weekly charts with indicators are now correctly presenting weekly indicator data.
  • A new setting to Ignore Warning Messages has been added to the Data Distribution 1 section within Preferences.

Build 458:

  • Chart printing has been improved.
  • Markets with no Cash prices can be supplied with Spot prices in the $ field when exporting.
  • Dividends are now only distributed based on account subscription, lowering traffic for those who don’t subscribe to Mutual Funds.
  • Last used settings in the Select Data Series interface are now correctly restored.

 

Build 441:

  • A new switch has been added to command the software whether to Delete Dropped Symbol Files from the directory that contains all files within any given Stock Index Component portfolio, when  symbol(s) are dropped from an index during the monthly update cycle.
  • 2 new ASCII/Excel export fields have been added, % and ^ which provide Price Change, and Percent Price Change.   This works with Daily, Weekly, Monthly periods.
  • Tradestation compatible attributes and header formatting has been corrected.
  • Calendars have been added to the Collection Date entry in Preferences, and to the Internet Download interface.  Click on it to suspend the download, and change the date to a previous day to back date the download.

Build 419-421:

  • Excel file driver installation button Install Driver Upgrades has been added to Preferences > Data Distribution 1 page. See Build 408 above for instruction details.
  • The Transfer Settlement Prices to Electronic Markets feature has been reworked to now accurately use the Settlement Prices when calculating offsets during rolls. Market names and table columns are changed to reflect Settlement, replacing Last Trade labels, when this feature is in effect. The Last column in the chart tables still contain the Last Trade price of the market, for reference, but the Close, and the Unadjusted Close fields are derived from the Settlement prices.
  • New right-click menu in chart Table section for Display Values w/ Maximal Precision, for turning this feature on and off without having to go into Preference or Portfolio settings.
  • Expiry Dates can now be formatted using the Excel Date format which corresponds to your system regional settings. Enable this on the ASCII/Excel Fields section within Edit Portfolio.
  • CSI Format can now accommodate 9,999 files in one directory for use with software that can read it, such as Delta Graphics. Find this new setting on the Portfolio Settings CSI Format section.
  • With Build 420, the Excel File Driver installs are downloaded only when requested.
  • With Build 421, rolling by days from the End of the Month now correctly handles situations where
    the last day, or last 2 days of the month land on a weekend. Rolls occur before the end of the month, not after, when specifying to roll on the last day of the month ( typically used with 1 Month Prior ).
  • With Build 422, Holidays are accounted for when they land on the last day of the month, or between the last day, and the number of calendar days, or trading days back from the end of the month.

Build 411-414:

  • Excel files are now appendable when using the Format As Excel Dates option in the ASCII/Excel Fields Layout section of UA. You must make sure that you specify and match the Excel Date format you are using in Excel, with the Date Format and Separator controls in the ASCII/Excel Fields Layout section in order for this to work right. For Example: If your dates in Excel are formatted in DD/MM/YYYY format in Excel, select those options in UA. This Excel format is generally specified in your computers Regional Settings within Control Panel. Previously, these files were being slowly rewritten every time you updated.
  • COT data now includes Average Volume and OI for the term in the Total Volume and Total Open Interest fields. 3 new COT Oscillators have been added that use these values:
    • COT Large Speculator Oscillator
    • COT Commercial Oscillator
    • COT Small Trader Oscillator

Build 408:

    • For customers who use the Excel format, UA now provides the option to use a newer Excel OLEDB driver that replaces the old one that has recently been disrupted by a Microsoft Security Update for users of Windows 7 and above only.  Windows XP users do not need to use this new feature.

To use this, change the Excel File Driver Provider setting in the Data Distribution 1 section within UA Preferences from Microsoft.Jet.OLEB.4.0 to Microsoft.ACE.OLEDB.12.0.
The Install Driver Upgrades button below this selection with then be enabled. Press this button to have the new Excel Driver installed onto your machine. When this is done installing, you will be prompted of it’s success. Click OK and proceed to update your database as normal. Your Excel files should then properly contain your data, just as before this incident occurred.


Click here for prior Build change reports

UA Excel Unexpected error from external database driver (1)

One or more of the latest Microsoft Windows Security Updates has interfered with the
functioning of the Microsoft Excel ODBC Driver that is used by UA to manage Excel export
files. We have confirmed this is an issue with Microsoft, and that they’ve been
notified. The only way for us to handle this for now is to uninstall their security update.
This can be done from your Control Panel’s Program and Features interface.
Go there and click View Installed updates. Locate one of the following updates,
select it and click Uninstall. Your system will run through the uninstall process and
prompt you to reboot. After this is done, your Excel export files can then again
be managed properly.

Security Update for Microsoft Windows
KB4041681 — Windows 7 and Windows Server 2008 R2
KB4041693 — Windows 8.1 and Windows Server 2012
KB4041691 — Windows 10 Version 1607 and Windows Server 2016
KB4041676 — Windows 10 Version 1703

Hopefully Microsoft will not issue this problem back into our systems.
Follow this link to see more on the Microsoft Developer Network:
MSDN Topic of Discussion

A new upgrade to UA will be forthcoming that uses a newer OLEDB driver that is not susceptible to this problem. Check our upgrade page for release Build 408: UA Upgrades

Hurricane Irma – The Aftermath

As most of our clients know, CSI’s home state of Florida was severely impacted by Hurricane Irma. This caused in interruption of service on Monday September 11

The issues weren’t that data couldn’t go out; the problems were more related to incoming data being processed. There was some misunderstanding regarding access to the colocation facility, but more of an impact was the widespread impact of the storm. We had personnel relocated to many places, but the power issues were so widespread that almost everyone was cut off for a time on Monday. And honestly, we feel that we didn’t do a thorough enough job stress-testing out disaster plan. We’re addressing that immediately.

Hurricane Irma storm alert

Due to the severity of hurricane Irma, it is possible that our clients may experience interruptions of service. Although we have co-located our critical systems in a secure place that has guaranteed power uptime and multiply-redundant communications lines, the unpredictability of the storm’s path and level of destruction may cause disruptions. The staff of CSI will give its best efforts to conduct business, but must also consider the safety of each team member.

Relisting of E-mini Russell 2000 Index Futures and Options on CME

Effective July 10th, 2017, CSI will resume coverage of E-mini Russell 2000 Index futures and options on CME under CSI#677 (Symbol ER2). The existing contracts on ICE will continue to be available under CSI#818 until expiration. For more information, see the CME News Release

CANADA DOLLAR MINIMUM TICK CHANGE — 2016 JULY 8

Effective Sunday, July 10, 2016 for trade date Monday, July 11, 2016 the Chicago Mercantile Exchange will amend the minimum price increment for Canadian Dollar Futures. The minimum tick is changing from 0.0001 to 0.00005.
Users of UA versions before 2.10.8 will need to refresh the database history for the affected data sets.
Click here for instructions.
CSI issues affected:
#64 CD
#129 CD2
#880 CD1
#100819 MCD

Taiwan Futures Exchange market closed 2016 July 8

Taiwan Futures Exchange announces that the market will be closed on 2016/7/8 due to Typhoon Nepartak. The Final Settlement Day of the 201607 TOPIX Futures contract will be postponed to the next trading day accordingly. The final settlement price of the contract is the TOPIX Special Quotation (TOPIX SQ) calculated on the final settlement price determination day (the TSE business day following the last trading day, 2016/7/8).

This effects the following CSI#s
#644
#645
#646
#448
#751
#100161
#650
#100489
#100492
#100493

FX PRECISION CHANGE — 2016 MAY 2

Effective Monday, May 2, 2016 certain cross-rate quotes will gain an additional digit of precision.
UA users will need to refresh the database history for the affected data sets.
Click here for instructions.
CSI issues affected:

CSI# Delivery Code Old decimals New Decimals Cross  UA Symbol UA Number
171 37 4 5 AUD-GBP AD3 2160
171 39 2 3 AUD-JPY AD4 2162
390 41 3 4 USD-DKK QE4 2254
390 56 3 4 USD-MXP QF5 2269
390 58 3 4 USD-SEK QF1 2271
390 60 1 2 USD-KRW QF3 2273
590 41 3 4 GBP-DKK DR4 2314
590 44 3 4 GBP-HKD DR7 2317
590 46 2 3 GBP-JPY DR9 2319
590 56 3 4 GBP-MXP DR8 2329
590 57 3 4 GBP-ZAR DR0 2330
590 58 3 4 GBP-SEK DR6 2331
591 46 2 3 EUR-JPY EU5 2345
591 55 4 5 EUR-GBP EU7 2347
690 38 4 5 USD-BHD US4 3301
690 41 3 4 USD-CZK US7 3304
690 45 2 4 USD-INR USA 3308
690 46 4 5 USD-KWD USB 3309
690 49 3 4 USD-RUB USE 3312
690 58 3 4 USD-PEN USN 3321
691 44 0 2 EUR-IDR EUH 3331
691 45 2 4 EUR-INR EUI 3332
691 49 3 4 EUR-RUB EUM 3336
691 52 3 4 EUR-THD EUP 3339
691 53 3 4 EUR-TWD EUQ 3340
775 57 2 4 ZAR-JPY JPYXI 3521
776 43 2 3 CHF-HUF CHFX4 3529
776 53 3 4 CHF-THB CHFXE 3539

 

 

You can paste the list below into your refresh history dialog:

 

2160
2162
2254
2269
2271
2273
2314
2317
2319
2329
2330
2331
2345
2347
3301
3304
3308
3309
3312
3321
3331
3332
3336
3339
3340
3521
3529
3539

 

Futures Symbol Changes

In an effort to maintain consistency among CSI platforms, the following futures markets have changed symbols as of April 12, 2016.  Please adjust your software accordingly. If you must use the old symbol, it is possible to modify the symbols in your UA factsheet. Contact CSI customer support if you need assistance.

 

Csinum IsActive? Old Symbol New Symbol Name
55 N LW LWS Sugar #4-CASH-(LCE)-EURONEXT
81 N PE PE9 Euro Bond-(MATIF)-EURONEXT
85 N RD RD? Deutsche Mark Spot Rolling-CME
109 N UD YE mini Eurodollar(3Mth)-CBT(MACE)
118 N HA HAU Gold-Hong Kong-(HKFE)-HKEX
122 N SA SAU Gold-(SIMEX)-SGX
155 N YL YLC Cattle-Live-SFE
163 N ZD PZD Deutsche Mark-PBOT
164 N ZE PZE EuroCurrUnit-PBOT
175 N FS FSE Eurodollar(3Mth)-EURONEXT(LIFFE)
225 Y YT2 YT1 10-Year Australian Govt Bond (6%)-(rounded #381)-SFE
256 N SJ SJ9 Japanese Yen-SGX(SIMEX)
267 N JF JFY Euroyen-1 Yr-TFOREX-(TIFFE)
273 N AP APT Potatoes-EOE
286 N LA LAM Lambs-EURONEXT(LCE)
313 N JC JCT Cotton-TCE
325 N KP KPK Palm Kernel Oil-MDEX
334 N FM? MF? French Medium Govt Bond(3/5Yr)-(MATIF)-EURONEXT
335 N PO POM Potatoes-EURONEXT(MATIF)
358 Y COX COM Rapeseed-EURONEXT(MATIF)
397 N FO FOX FOX Index-HEX
406 Y KLI FKL KLSE Comp Index-MDEX
424 N EV EV9 Electricity-Palo Verde-NYMEX
425 N YW YWH Wheat-SFE
432 Y NP9 NP Henry Hub Natural Gas Penultimate-NYMEX
434 N WH WHE Wheat-EOE
436 N BL BLE Wheat-Milling-(MATIF)-EURONEXT
449 Y SP10 SP0 S&P 500 Index (Divided by 10) -CME
467 N GL GLD JSE All Gold Index-SAFEX
495 N YV YVE Electricity-Victoria-SFE
516 N JD JDT Cocoons-Dried-CCX
535 N ME MFT Govt Bond-Spanish 30 Yr-MEFF
547 N FL FLI Euro LIBOR-3 Mth-EUREX
555 N EB EBJ Euro German Pfand
571 N OC OCU Euro LIBOR-3 M-EURONEXT(LIFFE)
574 N OS OSS Sterling Rate-3 Mth-EURONEXT(LIFFE)
593 N DE DE2 Dow Jones Composite Average-CBT
614 Y YBA2 YB2 90 Day Australian Bank Bills -SFE
615 Y YTT2 YT2 3-Year Australian Govt Bond (6%) -SFE
616 Y YTC2 YT3 10-Year Australian Govt Bond (6%) -SFE
631 N YB YBR Barley-SFE
632 N YC YCN Rapeseed(Canola)-SFE
648 Y SSI2 SS2 Nikkei 225 Index -SGX(SIMEX)
664 N JP JPO Potatoes-YCE
665 N JS JST S&P/Topix 150 Index-TSE
687 N EG EGT Sunflower Seeds-EURONEXT(MATIF)
705 Y F0B FBM Phelix Electricity Base Load-EEX
706 Y F0P FPM Phelix Electricity Peak Load-EEX
707 Y F0C FBQ Phelix Electricity Base Load Qtr-EEX
708 Y F0Q FPQ Phelix Electricity Peak Load Qtr-EEX
709 Y F0D FBY Phelix Electricity Base Load Year-EEX
710 Y F0R FPY Phelix Electricity Peak Load Year-EEX
728 Y YAP2 YA2 SPI 200 Index -SFE
885 Y SP1 SP3 S&P 500 Index-CME
888 N RL1 RL2 Russell 2000 Index -CME
905 N TM TMI Dow Jones Total Market Index-CBT
971 N FA FAP Potatoes-EURONEXT(LIFFE)
977 N TT TTB T-bills (91 Day)-TDE
983 Y WSA WEA Wheat-SAFEX
1056 N AXJ AXJO mini S&P/ASX 200 Index-ASX
1093 N WEI WWR Wheat-RMX
1102 Y GOC QOC miNY Gold-COMEX
1630 Y DJ0 DJO DJS 600 Food & Beverage-EUREX
1631 Y DE0 DEO DJ Stoxx Food & Beverage-EUREX
1651 Y RS0 RSO Refined Soy Oil-NCDEX
1854 Y EDL IED Eurodollar

Option Strike Changes for UA

Option strikes now have an extra 1/2 tick for the following markets:

CSI # Symbol Market
44 US US T-Bond
74 FF 30 Day Federal Funds
150 TY 10 Tear US T-Note
251 FV 5 Year US T-Note
382 TU 2 Year US T-Note
1507 UL2 Ultra T-Bond
1910 UT1 Ultra Bond Week 1
1911 UT2 Ultra Bond Week 2
1912 UT3 Ultra Bond Week 3
1913 UT4 Ultra Bond Week 4
1914 UT5 Ultra Bond Week 5
1915 CG1 30 Year T-Bond Week 1
1916 CG2 30 Year T-Bond Week 2
1917 CG3 30 Year T-Bond Week 3
1918 CG4 30 Year T-Bond Week 4
1919 CG5 30 Year T-Bond Week 5

You will need to refresh your databases.
To refresh, click the Refresh Symbol Database button, and then Copy/Paste the following text into the Select Market tab box:

44(FO),74(FO),150(FO),251(FO),382(FO),1507(FO),
1910(FO),1911(FO),1912(FO),1913(FO),1914(FO),
1915(FO),1916(FO),1917(FO),1918(FO),1919(FO)

(Exclude those you are not interested in)

Then click Download. ( Refer to image below for guidance )

HTML5 Icon

If you’re using the Portfolio Manager to manage your options, you will have to delete all your strikes and re-enter them. I would recommend that instead of re-entering them, that you use the new options export utility which is much more user friendly and much less time consuming.

From within the Export Options Data tool ( Ctrl-O ):

  • Click the Clear Selections button to temporarily clear the list of option markets that you’re tracking
  • Check ALL the items from the above table that you’re interested in tracking
  • Click the Build Selected Option Files button
  • When this process has completed, click the Restore button to reselect your markets
  • Keep your files updated with the Auto Update feature

( Refer to image below for guidance )

HTML5 Icon

HTML5 Icon

HTML5 Icon