Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Next »

步骤:


1. 录入公司信息(或通知MAF团队协助录入)

设置-公司-公司资料

因为现货合同需要和公司的名称挂钩,所以在输入现货合同之前,您需要先把贵公司旗下的所有公司信息输入。

用户可以设置公司,可以多个公司,因为贸易公司通常会有几个公司,第一个公司在系统里为“主公司”。一个主公司下面可以设置很多群组(组别),每个群组下面可以邀请很多组员,每个群组的信息是可以共享的,不同群组的信息是不可以共享,除非选择了特殊群组,他们可以查看公司旗下所有的信息。一般群组就只能查看本组的数据。

您也可以通知MAF团队协助录入,只需填写这个文件并发给MAF团队

 

a. 请选择一位成员当贵公司的“公司资料管理员“(Company Profile Creator)来设置公司的信息 (公司内部自己决定)。

公司资料管理员登录之后,请点击左侧导航侧栏中的 设置>公司>公司资料

b. 请设置贵公司的资料再点“保存资料”(有星号是必填的)。在这里填写的公司名称将会出现在现货合同功能的“公司名称”。如果成员都加到公司资料管理员的组别,成员的公司信息页面就会跟着公司资料管理员设置的内容自动填充。成员就不需要重新录入。

 

 如想了解更多关于群组设置,请查阅https://mafint.atlassian.net/wiki/spaces/MCUGC/pages/1858174992#%E8%AE%BE%E7%AB%8B%E7%BE%A4%E7%BB%84


2. 录入现货交易数据

新现货合同页面为用户提供了一个多部门协作录入的环境并且与各职能单位的工作流程相匹配。

Please note that all data input in New Physical Trade will appear in the old Physical Trade page, and vice versa. Trades created in the New Physical Trade page will have their Actions column button disabled, which disallows editing of the trades in the old Physical Trade page.

同时,您也可以选择旧方法来录入数据:

1. 手动录入现货交易,请前往:手动录入现货合同

2. 批量上传现货交易,请前往:现货合同 101

a. 在新现货合同页面中录入基本交易信息 (现货合同)

i. 请在左侧导航栏中选择成交明细,在下拉菜单中点击新现货合同。

The From Date is 1 week before today's date and To Date is today’s date by default. Please feel free to change the dates accordingly. The dates will remain according to your settings until you log out.

To delete the trades, tick the checkbox of the row and click on Delete Row at the top right corner of the page.

To reset the filter, click on the Reset Filter button or right-click in the table and click on Reset Filter.

ii. 请点击+新交易,您可以在新添加的一行里录入您的数据。录入数据的细节请参考以下指南:

  • 交易ID:非必需录入,当您保存完您的交易数据后,系统会自动生成交易ID。

  • 交易日*:合同上注明的交易日。

  • 产品*:产品名称,例如 玉米。

  • 产品规格:产品规格,如有需要您可以根据您的参考依据来录入, 例如 产品 橡胶,产品规格 XX1。

  • 公司名称*:贵公司名称(可以在设置>公司>公司资料中录入)

  • 客户名称*:买/卖客户名称

  • 合同编号.:每一笔买/卖合同都需要有专属的合同编号。

  • Main Contract No.: Main contract number of individual contract number, you may input as necessary

  • 买/卖*:采购或是销售合同

  • 匹配号.: 根据相同的匹配号来来一一对应每笔采购和销售合同。

  • 提货日: 合同约定的货权转移日。

  • 交易员:交易员名称。

  • 交易模式 *:

    • 离岸 -对应离岸合同 - 无法录入税率、汇率以及海关税。

    • 内贸 - 可以录入税率,无法录入汇率及海关税。

    • 交割 - 可以录入税率,无法录入汇率及海关税。

    • 进出口 -对应进出口合同-可以录入税率、汇率(当交易币种与产品币种不同时)以及海关税。

    • 基差 - 可以录入税率,无法录入汇率和海关税。

当离岸公司发生进出口贸易时,将会包含以下三种交易合同:

  1. 离岸公司从供应商处买入—离岸

  2. 离岸公司卖给境内公司 (由离岸公司出口) -进出口

  3. 境内公司从离岸公司处买入 (由境内公司进口) - 进出口

  • 数量*:合同采购数量。

  • Actual Qty: Actual quantity transacted

  • 单位*:合同/产品的交易单位 例如 metric ton

  • 约定点价日: 合同约定的点价日。

  • 保证金比例: 保证金占采购金额的比例

  • 临时价格: 暂定价格。当预估价和实际价格不可用时将会被用来计算盈亏。系统使用各项价格数据来计算盈亏的优先级:实际价格>预估价>临时价格。

  • Actual Price: Actual price transacted, will be used as priority to calculate P/L

  • 点价日:实际的点价日。

  • 采/销执行状态: 合同执行的实时状态,例如 执行完毕。

  • 库存单据日期: 库存管理 101 中记录的最新出入库日期。

  • 仓储名称/状态: 库存管理 101 中录入的仓库名称和货物状态会在此自动填充。

  • 出入库数量: 库存管理 101 中录入的总出入库数量会在此自动填充

  • 未收货/出库数量: 采/销数量 - 出入库数量

  • 款项总额:采销资金 录入的总收付款金额会在此自动填充。

  • 款项日期:采销资金 录入的实际收付款日期会在此自动填充。

  • 款项余额: 尾款= 采/销总额 - 款项总额,会在此自动填充。

  • 发票数量:采销资金 录入的总发票数量会在此自动填充。

  • 发票金额:采销资金 录入的总发票金额会在此自动填充。

  • 未开票数量: 采/销数量 - 发票数量,会在此自动填充。

  • 未开票金额: 采/销金额 - 发票金额,会在此自动填充。

  • 备注:

录入完毕后,请点击保存来保存您的数据。


b. 在新现货合同中录入价格数据(结算价)

If this step is not required yet, please proceed to the next step and return to complete this step when necessary.

All the basic trades data input in Step a (Trades tab) above will be reflected automatically in the table.

The From Date is 1 week before today's date and To Date is today’s date by default. Please feel free to change the dates accordingly. The dates will remain according to your settings until you log out.

To reset the filter, click on the Reset Filter button or right-click in the table and click on Reset Filter.


Please fill in the settlement data as necessary, only fields in red are compulsory to be filled.

  • Trade ID:Input is not required, once you save your trade data, the Trade ID will be generated automatically

  • Execution ID: Input is not required, Execution ID is generated automatically

  • Trade Date*:Trade date of the contract

  • Contract No.:Every purchase and sale contract should have its own contract number

  • Trade Mode *:

    • Offshore refers to offshore contracts - Cannot input for Tax Rate, Exchange Rate and Custom Tax Rate

    • Domestic China - Can input Tax Rate, cannot input Exchange Rate and Custom Tax Rate

    • Delivery China - Can input Tax Rate, cannot input Exchange Rate and Custom Tax Rate

    • Import/Export refers to import/export contracts - Can input Tax Rate, Exchange Rate (If Deal Currency and Product Currency are different) and Custom Tax Rate

    • Basis Trade China - Can input Tax Rate, cannot input Exchange Rate and Custom Tax Rate

If an offshore company imports/exports, there are 3 trades contracts involved:

  1. Offshore companies purchase from suppliers - Offshore

  2. Offshore companies sell to domestic companies (exported by offshore companies) - Import/Export

  3. Domestic companies purchase from offshore companies (imported by domestic companies) - Import/Export

  • Deal ID: Input is not required, once you save your Deal Number, the Deal ID will be generated automatically

  • Deal No.: Deal number of the trade. Please note that if a deal number is an existing deal number, the MTM pricing will follow that of the deal number and so it will not be fillable. If the deal number input is new, you will be able to input the MTM pricing

    • If select existing Deal No., Deal ID and Deal Currency will automatically appear and are uneditable

    • If select new Deal No., Deal Currency is compulsory field and will be editable. Deal ID will be empty but will be autofilled once data is saved

  • Cat: Category of product

  • Contract Qty*:Contract quantity

  • Unit*:Unit of contract/product eg metric ton

  • Deal Ccy: Deal currency

  • Title Transfer Date: Title transfer date will be auto filled according to the Trade Date of the trade if AUTO TTD is auto ticked (by default). You may untick AUTO TTD and fill in the title transfer date as necessary. It cannot be earlier than physical trade date and cannot be after today's date

  • BM Pricing: Benchmark Pricing - Benchmark PRICING CODE of your product which has been pre-set in the physical pricing setting tab. The pricing index code selected will be used to benchmark the pricing of your trade. Please note that to set the pricing for each trade, you can only choose either benchmark pricing or fixed price. Fixed price will be empty if you select benchmark pricing. Tax rate for benchmark pricing has already been pre-set in physical pricing setting tab

  • Premium: Premium of your benchmark pricing index

  • Fixed Price: Fixed price of trade. Please note that to set the pricing for each trade, you can only choose either benchmark pricing or fixed price. Benchmark pricing will be empty if you select fixed pricing.

  • Fixed Pricing CCY: Currency for fixed price trade

  • Tax Rate (%): Tax rate for fixed price trade. Tax rate for benchmark pricing has already been pre-set in physical pricing setting tab so this field cannot be used if benchmark pricing has been used instead of fixed pricing. This will only be applicable if your trade mode is not OFFSHORE

  • MTM Pricing: MTM PRICING CODE of your product which has been pre-set in the physical pricing setting tab. The pricing index code selected will be used to benchmark the MTM of your trade. Tax rate for MTM pricing has already been pre-set in physical pricing setting tab. You do not need to select this if your deal number is an existing deal number with its own MTM pricing

  • Actual Qty: Actual quantity of trade

  • Estd Price: Estimated price of trade, will be used to calculate P/L if Actual Price is not available yet. The system will follow this order of priority to calculate P/L if the price is available: Actual Price > Estimated Price > Provisional Price

  • Actual Price: Actual price transacted, will be used as priority to calculate P/L. The system will follow this order of priority to calculate P/L if the price is available: Actual Price > Estimated Price > Provisional Price

  • Exchange Rate: Exchange rate used for the trade. This will only be applicable if your trade mode is IMPORT/EXPORT

  • Exchange Conversion Date: Date of exchange rate conversion. This is only supported in New Physical Trade page and not Old Physical Trade page. This will only be applicable if your trade mode is IMPORT/EXPORT

  • Custom Tax Amount: Custom tax amount applicable for the trade. This will only be applicable if your trade mode is IMPORT/EXPORT

Once done, please tick the checkbox of the trades you want to save and click on Save Changes to save your data. If you do not tick the checkbox of the rows before clicking Save Changes, no data will be saved.

All saved data will be transferred to the Updated Settlement table, please refer to Step c.


c. Update Pricing Data in New Physical Trade (Updated Settlement Tab)

If this step is not required yet, please proceed to the next step and return to complete this step when necessary.

All the settlement data updated and saved in Step b (Settlement tab) above will be reflected automatically in the table.

The From Date is 1 week before today's date and To Date is today’s date by default. Please feel free to change the dates accordingly. The dates will remain according to your settings until you log out.

To reset the filter, click on the Reset Filter button or right-click in the table and click on Reset Filter.


Please fill in the settlement data as necessary, only fields in red are compulsory to be filled.

  • Trade ID:Input is not required, once you save your trade data, the Trade ID will be generated automatically

  • Execution ID: Input is not required, Execution ID is generated automatically

  • Contract No.:Every purchase and sale contract should have its own contract number

  • Pricing Mode: Indicate as WMA, FLOAT or SPOT according to the BM Pricing set up in Step b above. If Fixed Price is used instead, it will indicate as FIX.

  • Quantity*:Contract quantity

  • Trader:Name of trader

  • Cat: Category of product

  • Title Transfer Date: Title transfer date, cannot be earlier than physical trade date and cannot be after today's date

  • Actual Qty: Actual quantity of trade

  • Estd Price: Estimated price of trade, will be used to calculate P/L if Actual Price is not available yet. The system will follow this order of priority to calculate P/L if the price is available: Actual Price > Estimated Price > Provisional Price

  • Actual Price: Actual price transacted, will be used as priority to calculate P/L. The system will follow this order of priority to calculate P/L if the price is available: Actual Price > Estimated Price > Provisional Price

  • Premium: Premium of your benchmark pricing index (WMA, FLOAT or SPOT only). This will not be applicable for pricing mode (FIX)

  • Exchange Rate: Exchange rate used for the trade. This will only be applicable if your trade mode is IMPORT/EXPORT

  • Exchange Conversion Date: Date of exchange rate conversion. This is only supported in New Physical Trade page and not Old Physical Trade page. This will only be applicable if your trade mode is IMPORT/EXPORT

  • Custom Tax Amount: Custom tax amount applicable for the trade. This will only be applicable if your trade mode is IMPORT/EXPORT

Once done, please click on Save Changes to save your data.

If this step is not required yet, please proceed to the next step and return to complete this step when necessary.

录入完毕后,请点击保存来保存您的数据。


d. 在库存管理中录入库存数据

If this step is not required yet, please proceed to the next step and return to complete this step when necessary.

请参考 库存管理 101

If Actual Quantity has been input, the system will capture actual quantity as the Qty in Stock Management table; otherwise, it will capture Contract Quantity as the Qty.

当出入库数据被录入后,以下的条目会在新现货合同页面中自动填充。

  • 库存单据日期: 库存管理 101 中记录的最新出入库日期。

  • 仓储名称/状态: 库存管理 101 中录入的仓库名称和货物状态会在此自动填充。

  • 出入库数量: 库存管理 101 中录入的总出入库数量会在此自动填充

  • 未收货/出库数量: 采/销数量 - 出入库数量


e. 在采销金额中录入收付款、发票数据。

If this step is not required yet, please proceed to the next step and return to complete this step when necessary.

请参考 采销资金

Contract No. of trades input in New Physical Trade table can be selected from the Contract No. column in PS Ledger.

当收付款、发票数据录入后,以下的条目会在新现货合同页面中自动填充。

  • 款项总额:采销资金 录入的总收付款金额会在此自动填充。

  • 款项日期:采销资金 录入的实际收付款日期会在此自动填充。

  • 款项余额: 尾款= 采/销总额 - 款项总额,会在此自动填充。

  • 发票数量:采销资金 录入的总发票数量会在此自动填充。

  • 发票金额:采销资金 录入的总发票金额会在此自动填充。

  • 未开票数量: 采/销数量 - 发票数量,会在此自动填充。

  • 未开票金额: 采/销金额 - 发票金额,会在此自动填充。


3. 创建量化模型/报表

仪表盘-我的仪表盘

如果以下内容(盈亏数据和初始资金/资金进出数据)已录入系统里,您选择的量化模型/报表会根据您的数据自动计算。不同的模型/报表需要不同的数据(有些不需要录入盈亏或资金)。

a. 盈亏(P/L):通过期货交易 101 产生的总盈亏(包括任何手续费):

  • 需要录入头寸,价格和手续费在期货交易 101 页面

  • 需要录入其他成本,支出于收入在总分类账 页面,请在“类型”选择EXP/INC:

    • 成本/支出:负数例如 -100

    • 收入:正数例如 100

请在保存数据之前在表格里分配好相应的交易组合。

b. 资金:需要录入在总分类账 页面:

  • 初始资金:请在“类型”选择 INIT FUND 。

  • 资金进出:请在“类型”选择FUND IN/OUT。

请在保存数据之前在表格里分配好相应的交易组合。

 

a. 把期货(和现货)匹配到交易组合后,您可以创建量化模型/报表来查看您的交易组合/交易的表现。请点击左侧导航侧栏中的仪表盘>我的仪表盘

 

b. 在仪表盘里可以创建和展示各种量化模型/报表,如您有需要定制任何模型/报表,请通知我们。您可以在下拉列表中选择一个模型/报表,点击‘创建’来创建一个新的模型/报表。

 

刚创建的模型在窗口中还没有任何内容,您需要通过‘设置’输入参数,然后就会有相应的输出。请点右上角的齿轮按钮进行设置。

 

 

大多数的模型都有相同的步骤。请选择单个或多个交易组合,确认其他信息再点”提交“。

您可以对列/行/组进行过滤、排列和分类,也可以根据需要分享模型/报表。

公共/专属行情数据:

公共 PUB MARKET PRICE:选择用系统从各个交易所获取的结算价

专属 PTY MARKET PRICE:选择用自己上传的结算价

 

自动更新日期:

  • 勾选:结束日会自动显示昨天的日期

  • 不勾选:您选择的结束日会保留


现货管理的APP报表例子

 

现货库存管理的APP报表例子

请参阅现货部门的APP - 仪表板模型/报告总结 了解更多。

  • No labels

0 Comments

You are not logged in. Any changes you make will be marked as anonymous. You may want to Log In if you already have an account.