Information services Paid services management Settings

Menu

List of services

Profile

Information services Paid services management Settings
Securities Market

Securities Market

Equities market
    Bonds market
      Instruments
        Organization of trading
        Sponsored Market Access
        Admission to trading
        Client Segregation
        Market Making
        Trading Members
        Fees
          Documents
          Interactive Trading Calendar
          Trading schedule
          Individual Investment Account
          Trade Locally
            1. Home
            2. Markets
            3. Securities Market
            4. Organization of trading
            5. Trading XML reports
            Subscription Print version

            Equity & Bond Market Trading XML reports

            Converting XML Reports in Linux-based OS

            To convert XML reports to HTML in Linux-based OS use the xsltproc utility.

            Command: xsltproc <stylesheet>.xslt <report>.xml -o <output>.html


            Comments on working with XML-reports

            MS Excel is recommended for viewing XML reports. Reports can also be opened in MS Word.

            For easier viewing and management, each XML report is accompanied by its own XSD schema and XSLT stylesheet. When opened in MS Excel or MS Word, these files can be downloaded from the MOEX website or loaded from a local computer. If using local files, you must first place all XSD schemas in the             C:\MICEX\XSD folder and all XSLT stylesheets in the C:\MICEX\XSLT folder.

            Links for downloading schemas and stylesheets are provided above. To download all files (schemas or stylesheets) at once, get the             allfiles.zip archive and extract its contents into the appropriate folder.

            Open reports in MS Excel or MS Word by selecting the transformation file (XSLT), which can be local or network-based. Network paths are only available if the computer has Internet access.

            For security reasons, Windows may block XML, XSD, and XSLT files downloaded from the network. If this happens, open the file properties in File Explorer and check the             "Unblock" box.

            When opening a report in MS Word, a list of available XSLT files appears. To trace the file origin, hover the cursor over it; the path will be displayed in a tooltip.

            When opening a report in MS Excel, an XML Import dialog appears. Select the             "Open this XML data source by applying the following stylesheet:" option and verify that the correct XSLT file is specified.

            To prepare a report for printing, in MS Excel go to the             "Page Layout" tab, and in MS Word go to the "Layout" tab. Under "Page Setup", configure the following:

            • Orientation: "Landscape";
            • Margins: Reduce them (this allows the program to automatically increase the font size when scaling).


            In MS Excel, under "Scale to Fit", you can also specify that the report should span no more than one page in width. To do this, set "Width" to "1 page" and "Height" to "Auto".

            Alternatively, access page setup via:             "File" > "Print" > "Page Setup".

            All clearing and main trading reports are available with both Russian and English stylesheets. MS Excel and MS Word will prompt you to choose the appropriate stylesheet upon opening. When using custom XSLT processors, you can apply either stylesheet by passing the             Language parameter with the value 'R' (Russian) or 'E' (English).

            Opening Large Reports

            If opening a large report in MS Excel or MS Word results in a blank page, it is recommended to convert them to HTML format first using the msxsl.exe utility.

            Command: msxsl.exe <report>.xml <stylesheet>.xslt -o <output>.html

            Open the resulting .html file in MS Excel or MS Word 2007 or later. Be aware of the following limits: MS Excel supports up to 1,048,576 rows, and MS Word supports up to 512 MB.