Market Data Unfair Advantage Posting Status Robert 2016

NCDEX futures price, volume, and open interest scaling

Please be advised that effective January 14, 2019, CSI will amend quotations of certain NCDEX products in order to provide more accurate price and volume precision.

OHLC prices disseminated in points format will be increased by a factor of 10 for the following product to accommodate the full precision quoted by the exchange. Only prices disseminated in points format will be increased. Prices disseminated in decimal format will not have their values increased.

CSI#

Name

Old min tick

New min tick

100650

Cotton Seed Oilcake

1

0.5

 

Additionally, the following NCDEX products will be adjusted to provide volume and open interest in contracts rather than in units. Volume and open interest will be divided by the divisors listed below.

CSI#

Name

Divisor

100650

Cotton Seed Oilcake

10

100651

Refined Soy Oil

10

100652

Soy Bean

10

100653

Rapeseed-Mustard Seed

10

100657

Sugar (M Grade)

10

100658

Coriander

10

100660

Jeera

3

100662

Maize – Feed/Industrial Grade

10

 

UA users may need to refresh the database history for the affected data sets.
Click here for instructions.

FX PRECISION CHANGE – 2018 NOV 6

Effective Monday, November 6, 2018 certain cross-rate quotes will gain an additional digit of precision.
UA users may 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 40 4 5 AUD-CHF AD5 2163
171 42 4 5 AUD-CAD AD7 2165
171 51 4 5 AUD-NZD AD! 2168
390 39 4 5 USD-CAD QE2 2252
390 44 4 5 USD-HKD QE7 2257
390 46 2 3 USD-JPY QE9 2259
390 52 4 5 USD-SGD QE{ 2265
390 53 4 5 USD-CHF QE} 2266
590 37 4 5 GBP-AUD DR1 2310
590 39 4 5 GBP-CAD DRC 2312
590 49 3 4 GBP-NOK DR# 2322
590 53 4 5 GBP-CHF DR^ 2326
591 37 4 5 EUR-AUD EU1 2341
591 39 4 5 EUR-CAD EU2 2342
591 41 4 5 EUR-DKK EU4 2344
591 53 4 5 EUR-CHF EU6 2346
591 58 4 5 EUR-SEK EU8 2348
690 59 4 5 USD-DKK QE4 2254
691 54 1 2 EUR-VEF EUR 3341
775 43 4 6 JPY-HUF JPYX4 3507
985 52 4 5 NZD-CAD CAD9 3555

 

 

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

 

2163
2165
2168
2252
2257
2259
2265
2266
2310
2312
2322
2326
2341
2342
2344
2304
2346
2348
2254
3341
3507
3555

 

Unfair Advantage Version 2.10.8 Upgrade Available

Release Date: April 18, 2018
Last Updated: January 16th, 2018 (Release 2.10.8.552 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.552 BETA RELEASE upgrade, then install over your current version.

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

Features include:
Build 550-552:

  • Support for markets trading in 32nds and quarters of 32nds.
  • A chart Invert shortcut button [ INV ] has been placed on lower charting toolbar.
  • A newly designed spread chart feature has been added, with a shortcut button placed in lower right section of charting toolbar, next to the new [ INV ] Invert button. Newly created Spread pairs can then be added to your portfolio for future charting reference, and for exporting the spread results.
  • Selection list is sorted by symbol.
  • Ability to chart spreads of Price vs an applied Indicator is functional.
  • Ability to chart an Indicator applied to spreads of 2 Price series is functional.
  • Spread description now includes instructions.
  • Other minor interface improvements.

Build 547:

  • Option Export Manager now updates nearest contract strikes properly when formatting file data By Contract.

Build 545:

  • UA now allows you to apply a chart Indicator Template ( which can contain up to 32 indicators ) to your portfolio symbol entries, so that all indicator results can be exported along with
    symbol data. This will work with ASCII and Excel formats only. This new feature can be found by clicking the [ I ] button located in the lower right-hand corner of the Select Data Series dialog interface. Access this dialog by Editing or Adding symbols. Your selection here can now also be applied to all symbols within your portfolio(s) by selecting: Assign This Indicator to Portfolio.(Optional).
  • To learn how to create a chart Indicator Template, view the following instructional video which provides a demonstration around the 8:00 minute mark: UA Charting Demonstration
  • This feature requires an * to be present at the end of your portfolios ASCII/Excel Field specification, as the last field to be exported, as there will be multiple fields, each of which will use enumeration related to each indicators name, parameter(s), and position within the table. You will also want to select the Include Header… option on the ASCII/Excel portfolio settings page when using this feature.

Build 538:

  • Floor spec has changed to (RTH), Electronic to (ETH). Appropriate filtering has been accounted for when viewing Market Specs, when building Historical Portfolios using the Wizard, and when transferring RTH Opens and Settlements to ETH symbols, when configured to do so.

Build 536:

  • Market Scanner multi-selection of multiple pages within the symbol list is now functioning properly.

Build 531-532:

  • Column layouts in UA chart’s Data Table can now be customized using the new feature located off the table view’s right-click menu [ Customize Column Layout ].

Build 530:

  • A new fractional delineator decimal point option has been added, a “,” comma, to represent the decimal point in order to comply with international conventions where it’s used. This is available in the ASCII and Excel formats only, and made available to select in the Data Display sections of Edit portfolio and Preferences interfaces.

Build 528:

  • Stop date setting within each data series is no longer ignored if used to override current setting of As Available.
  • 0 is caught and warned against usage when entered within Days From setting within the Data Series Selection Dialog.
  • Weekly series are updated, rather than rebuilt from scratch, for up to a month, if your data has not been updated within that time frame.

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