Steps:
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. Input Physical Trades Data
The New Physical Trade function allows users from different departments/teams to access the designated pages to input their data, ensuring a consistent operational workflow and clear delegation of responsibilities for different teams.
Alternatively, you may choose to use the old methods to input your data: 1. Manually input physical trades, please access: Input Physical Trades Manually 2. Bulk upload physical trades, please access: |
a. Input Basic Physical Trades Data in New Physical Trade (Trade)
i. Please click on Trade, followed by New Physical Trade from the navigation sidebar on the left to enter the physical trade page,
ii. Please click on + New Trade and a new row will be added for you to input your data. Please refer to below guide and input the details as necessary.
Trade ID:不需录入,系统会自动产生
Trade Date*:Trade date of the contract
Product*:Product name, for example Corn
Specification:Product specification, you may fill in for your reference if necessary, eg Product is Rubber and specification is XX1
Entity of Contract*:Name of your company (can be input in Settings>Company>Company Profile page)
Counterparty*:Counterparty name
Contract No.:Every purchase and sale contract should have its own contract number
Purchase/Sale*:Purchase/Buy or Sale/Sell
Match No.: Assign the same match number to the corresponding purchase and sale contracts for your reference
Contract Delivery Date: Contract delivery date
Trader:Name of trader
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:
Offshore companies purchase from suppliers - Offshore
Offshore companies sell to domestic companies (exported by offshore companies) - Import/Export
Domestic companies purchase from offshore companies (imported by domestic companies) - Import/Export
Quantity*:Contract quantity
Unit*:Unit of contract/product eg metric ton
Contract Pricing Date: Contract pricing date
Margin: Collateral value deposited with the counterparty
Provisional Price: Temporary price, will be used to calculate P/L if Estimated Price or 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
Pricing Date:Pricing Date
Execution Status: Status of contract eg settled, pending etc
Stock Date: The latest stock in/stock out date recorded in Stock Management Function
WH Name & Status: Name of warehouse and Stock Type recorded in Stock Management Function will be automatically reflected here
Stock Qty: Stock In/Out quantity that has been recorded in Stock Management Function
Unstock Qty: Stock In/Out quantity that has not been recorded in Stock Management Function, Un-stocked Quantity = Quantity - Stock Quantity
PSL Amt: PS Ledger amount with PSL Type: Payment recorded in PS Ledger will be automatically reflected here
PSL Date: PS Ledger date with PSL Type: Payment recorded in PS Ledger will be automatically reflected here
Bal Amount: Balance Amount = Trade value - PS Ledger Amount will be automatically reflected here
Inv Qty: Invoice quantity with PSL Type: Invoice recorded in PS Ledger will be automatically reflected here
Inv Amt: Invoice amount with PSL Type: Invoice recorded in PS Ledger will be automatically reflected here
Un Inv Qty: Un-Invoiced Quantity = Quantity - Invoice Quantity will be automatically reflected here
Un Inv Amt: Un-Invoiced Amount = Trade Value - Invoice Amount will be automatically reflected here
Remarks:Remarks
Once done, please click on Save Changes to save your data.
b. Input Pricing Data in New Physical Trade (Settlement)
Once done, please click on Save Changes to save your data.
c. Input Stock/Inventory Data in Stock Management
Please refer to Stock Management Function for the user guide.
Once stock data has been input, the following columns for each trade in the New Physical Trade table will be reflected automatically.
Stock Date: The latest stock in/stock out date recorded in Stock Management Function
WH Name & Status: Name of warehouse and Stock Type recorded in Stock Management Function will be automatically reflected here
Stock Qty: Stock In/Out quantity that has been recorded in Stock Management Function
Unstock Qty: Stock In/Out quantity that has not been recorded in Stock Management Function, Un-stocked Quantity = Quantity - Stock Quantity
d. Input Payment and Invoice Data in PS Ledger
Please refer to Managing Physical Trades for the user guide.
Once PS Ledger data has been input, the following columns for each trade in the New Physical Trade table will be reflected automatically.
PSL Amt: PS Ledger amount with PSL Type: Payment recorded in PS Ledger will be automatically reflected here
PSL Date: PS Ledger date with PSL Type: Payment recorded in PS Ledger will be automatically reflected here
Bal Amount: Balance Amount = Trade value - PS Ledger Amount will be automatically reflected here
Inv Qty: Invoice quantity with PSL Type: Invoice recorded in PS Ledger will be automatically reflected here
Inv Amt: Invoice amount with PSL Type: Invoice recorded in PS Ledger will be automatically reflected here
Un Inv Qty: Un-Invoiced Quantity = Quantity - Invoice Quantity will be automatically reflected here
Un Inv Amt: Un-Invoiced Amount = Trade Value - Invoice Amount will be automatically reflected here
3. 创建量化模型/报表
仪表盘-我的仪表盘
如果以下内容(盈亏数据和初始资金/资金进出数据)已录入系统里,您选择的量化模型/报表会根据您的数据自动计算。不同的模型/报表需要不同的数据(有些不需要录入盈亏或资金)。 a. 盈亏(P/L):通过期货交易 101 产生的总盈亏(包括任何手续费): 请在保存数据之前在表格里分配好相应的交易组合。 b. 资金:需要录入在总分类账 页面:
请在保存数据之前在表格里分配好相应的交易组合。 |
a. 把期货(和现货)匹配到交易组合后,您可以创建量化模型/报表来查看您的交易组合/交易的表现。请点击左侧导航侧栏中的仪表盘>我的仪表盘。
b. 在仪表盘里可以创建和展示各种量化模型/报表,如您有需要定制任何模型/报表,请通知我们。您可以在下拉列表中选择一个模型/报表,点击‘创建’来创建一个新的模型/报表。
刚创建的模型在窗口中还没有任何内容,您需要通过‘设置’输入参数,然后就会有相应的输出。请点右上角的齿轮按钮进行设置。
大多数的模型都有相同的步骤。请选择单个或多个交易组合,确认其他信息再点”提交“。
您可以对列/行/组进行过滤、排列和分类,也可以根据需要分享模型/报表。
公共/专属行情数据:
公共 PUB MARKET PRICE:选择用系统从各个交易所获取的结算价
专属 PTY MARKET PRICE:选择用自己上传的结算价
自动更新日期:
勾选:结束日会自动显示昨天的日期
不勾选:您选择的结束日会保留
现货管理的APP报表例子
现货库存管理的APP报表例子
请参阅现货部门的APP - 仪表板模型/报告总结 了解更多。
Add Comment