News & Insights

Insights

Back to list

[Case Study] Using and Managing your Own Market Data

12.09.2019

In addition to providing data from multiple exchange sources, brokers and third-party data vendors, MAF Cloud also allows users to upload and manage their own market data. We will be using a case study to demonstrate how you can maximise your MAF Cloud experience by using and managing your own market data!

(This is a short and concise step-to-step guide. Please click here for the full guide.)

Adding your Own Market Data

Creating New Market Data

  1. Click “Create Market Data” under “Market Data” from the navigation list on the left.
  2. Fill in your own “Data Name” (e.g. 螺纹钢:HRB400 20mm:唐山).
  3. Fill in “Exchange”, which refers to the Exchange the product is traded in (e.g. 唐山).
  4. Fill in “Product Code”, which helps you to identify the data easily by its product code (e.g. HRB400_20_TS).
  5. Fill in “Contract Code”, which helps you to identify the data easily by its contract code (e.g. HRB400_20_TS).
  6. Fill in “Data Source”, which refers to the source of data (e.g. Self).
  7. Select the data’s “Product Type“, in which four options are available (e.g. “Fundamental”). Different product types require inputting of different types of data. Click Market Data Structure to find out more.
  8. You are able to fill in “Frequency” (e.g. Daily).

“Frequency”, “Unit” and “Description” are optional fields.

Example:

Figure 1: Dataset & Basic Information

After filling in your market data’s information, you can start to add the market data’s historical information.

Adding your Own Historical Data

You will be able to add your own historical data using any of the following methods:

  • Copying and pasting the data into the table, or
  • Importing the data using a .CSV file, or
  • Manually keying the data into each cell.

For more information, please click here.

Editing Market Data

After saving your market data and information, you will be able to edit it:

  1. Click “View Market Data” under “Market Data” from the navigation list on the left.
  2. Search for the dataset that you wish to edit (e.g. 螺纹钢:HRB400 20mm:唐山).
  3. Click on the edit button under the “Actions” column (represented by a ‘pen and paper’ icon).
  4. After editing the information, click “Save”.

Adding Additional Market Price Information

If you wish to add additional market prices into an already-created market data, you are able to do so:

  1. Click “View Market Data” under “Market Data” from the navigation list on the left.
  2. Search for the dataset that you wish to edit (e.g. 螺纹钢:HRB400 20mm:唐山).
  3. Click on the edit button under the “Actions” column (represented by a ‘pen and paper’ icon).
  4. Under Historical Data, click “Add New Market Prices.”
  5. Add the relevant information into the table to add new market data. Delete the rows if they are not used (highlight the rows by clicking on the header of the row e.g. 1, 2, 3 etc).
  6. Click “Save”.

Deleting Market Data

If you do not require the Market Data anymore, you will be able to delete it:

  1. Click “View Market Data” under “Market Data” from the navigation list on the left.
  2. Search for the dataset that you wish to edit (e.g. 螺纹钢:HRB400 20mm:唐山).
  3. Click on the “delete” button under the “Actions” column (represented by a ‘bin’ icon).
  4. If you want your Market Data to be deleted, click on “Yes, delete!” and it would be deleted. Do note that this is an irreversible action.
  5. If you do not want your Market Data to be deleted, click on “No, cancel!” and it would not be deleted.

Using MAF Cloud’s Quantitative Model

You are able to use MAF Cloud’s quantitative model(s) with the ‘Market Data’ you have just created.

An example would be using the Spread Analysis Model which can be found under “Dashboard” from the navigation list on the left.

Comparing 螺纹钢:HRB400 20mm:唐山 Market Data and Steel Rebar Market Data in the Spread Analysis Model:

Figure 2: Spread Analysis Model

Exporting Data

You would be able to export data from “Historical Data” and from the quantitative models available in MAF Cloud.

Exporting Data from “Historical Data”

  1. Click “View Market Data” under “Market Data” from the navigation list on the left.
  2. Search for the data you wish to export.
  3. Click the “View” button (represented by the ‘eye’ icon).
  4. Click on “Export Data” from the right corner of the page and you would be able to export this as a .CSV file.

Exporting Data from Quantitative Models

  1. Select the model you wish to export from your “Dashboard”.
  2. Click on the export icon (represented by a ‘cloud and arrow’). You will be able to export the data as a .CSV file or as an image.

You are not only able to use the data available in MAF Cloud for quantitative analysis, but will also be able to save and export your own market data for use through this function.

Click here for a detailed step-by-step guide with a sample file for you to try out in MAF Cloud now!


Related Articles


[New Feature] Options Contract is Now Available!

08.09.2021

[New Feature] FX Exposure Report is Now Available!

20.08.2021

[New Feature] Futures Account Report is Now Available!

29.06.2021

[New Feature] Portfolio Performance Chart Model is Now Available!

28.06.2021

Try MAF Cloud For Free!

Get Free Trial

Skip to toolbar