SMM DatabaseMy Data & API
Cobalt Lithium
Cobalt Lithium
Contact Us

E-mail：service.en@smm.cn

Phone：+86 - (021)5155 0306

SMM Data Excel Plug-in

Updata SMM data in Excel by downloading SMM Data Excel Plug-in

OS: Win 7/8/9/10

Excel: Ver.07 and above

DOWNLOAD

Home>Database>Tin>Refined Tin>Import & Export>Profits,losses of IMP,EXP>
Profits,losses of IMP,EXP
MonthlyDATAAPI
Service
Data & API
Starting Date
Mar 07, 2017
Catagory
Tin > Refined Tin > Import & Export
DataAPI
Sample code
URL
https://dataapi.smm.cn/GetDataEn/tin_import_and_export_profit_and_loss
Supported Formats
JSON
HTTP Request Method
POST
Request Parameters
Names
Requires
Types of Range
Descriptions
tokenTrueStringThis parameter is required when using OAuth.You will get the access_token after oauth authorization.token
sdatetimeFalseStringStart Date,The default value is A Year ago, e.g.,2018-01-01
edatetimeFalseStringEnd Date,The default value is Today, e.g.,2018-08-13
Response
    • 200
    • "OK"
    • ▶
      {} 3 keys
      • 0
      • ▶
        [] 13 items
        • ▶
          {} 3 keys
          • "Date"
          • ""
          • ""
        • ▶
          {} 3 keys
          • "LME tin"
          • "$/mt"
          • ""
        • ▶
          {} 3 keys
          • "0-3（swap fee）"
          • "$/mt"
          • ""
        • ▶
          {} 3 keys
          • "Premium"
          • "$/mt"
          • ""
        • ▶
          {} 3 keys
          • "Exchange rate"
          • ""
          • ""
        • ▶
          {} 3 keys
          • "Premium in Taiwan"
          • "$/mt"
          • ""
        • ▶
          {} 3 keys
          • "Spot prices based on LME tin prices"
          • "yuan/mt"
          • ""
        • ▶
          {} 3 keys
          • "SMM tin price"
          • "yuan/mt"
          • ""
        • ▶
          {} 3 keys
          • "Taiwan local price"
          • "yuan/mt"
          • ""
        • ▶
          {} 3 keys
          • "Shipping rates (Taiwan)"
          • "yuan/mt"
          • ""
        • ▶
          {} 3 keys
          • "SHFE/LME tin price ratio"
          • ""
          • ""
        • ▶
          {} 3 keys
          • "Import profits/losses "
          • "yuan/mt"
          • ""
        • ▶
          {} 3 keys
          • "Export profits/losses "
          • "yuan/mt"
          • ""
      • ▶
        [] 2 items
        • ▶
          [] 4 items
          • "2016-05-27"
          • "97.5"
          • "9.8"
          • "……"
        • ▶
          [] 4 items
          • "2016-05-27"
          • "97.5"
          • "9.8"
          • "……"
Returned Parameters Description
Type
Status
Descriptions
CodeRequest Status “200” means normal, other status codes are shown in schedule 1
MsgReturn Description“OK” indicates normal. Other states are shown in schedule 1
DataReturn ResultReturn the corresponding data according to the requested parameters
Data.StatusPermission Status“0” means no permission,” 1” means permission
Data.Field1D Structure ArrayReturn data header description
Data.Field.NameNameIndicates the name corresponding to the column data
Data.Field.UnitUnitThe unit corresponding to the column data
Data.Field.InfoDescriptionDescription of the column data
Content2D dataReturn all eligible data
Returned Field Description
Field Name
Fied Type
Unit
Descriptions
Datedatetime
LME tininteger$/mt
0-3（swap fee）integer$/mt
Premiuminteger$/mt
Exchange ratefloat
Premium in Taiwaninteger$/mt
Spot prices based on LME tin pricesfloatyuan/mt
SMM tin priceintegeryuan/mt
Taiwan local pricefloatyuan/mt
Shipping rates (Taiwan)floatyuan/mt
SHFE/LME tin price ratiofloat
Import profits/losses floatyuan/mt
Export profits/losses floatyuan/mt
How to get token
URL
https://platform.smm.cn/usercenter/auth
HTTP Request Method
POST
Request Parameters
Requires
Types of Range
Descriptions
user_nameTrueStringEamil Address
passwordTrueStringMD5 password
sourceTrueStringSource,The default value is dataapi
Response
    • 0
    • ""
    • ▶
      {} 1 key
      • "eyJhbGciOiJIUjZWxLCJjb21wYW55X3N0YXR1cyI6MCwiY3JlYXRlbWFpbCI6Inh1lIjmNCdWc…"
Notes

All interfaces require authorization, and each interface has a start date. A new authorization is required after expiration.

Phone：+86 - (021)5155 0306

Schedule 1
Status
Descriptions
200SUCCESS
400INVALID REQUEST
401NOT CERTIFIED
403REJECT A REQUEST
404PAGE LOSS
422UNPROCESSABLE ENTITY
500SERVER ERROR
Profits,losses of IMP,EXP
MonthlyDATAAPI
Catagory
Tin > Refined Tin > Import & Export
Service
Data & API
Starting Date
Mar 07, 2017
Copyright © 2024 SMM Information & Technology Co, Ltd. All rights reserved.
In common with most websites, we use cookies to carry out various tasks including improving our user's experience. Read more about how we use cookies here.