CN113837883A - Noble metal transaction data management method and device, computer equipment and storage medium - Google Patents

Noble metal transaction data management method and device, computer equipment and storage medium Download PDF

Info

Publication number
CN113837883A
CN113837883A CN202111317606.4A CN202111317606A CN113837883A CN 113837883 A CN113837883 A CN 113837883A CN 202111317606 A CN202111317606 A CN 202111317606A CN 113837883 A CN113837883 A CN 113837883A
Authority
CN
China
Prior art keywords
target
transaction
precious metal
data
currency
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CN202111317606.4A
Other languages
Chinese (zh)
Other versions
CN113837883B (en
Inventor
曹折波
徐浩
李伟
张楠楠
杨琳
田圃森
杜水华
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
China Construction Bank Corp
Original Assignee
China Construction Bank Corp
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by China Construction Bank Corp filed Critical China Construction Bank Corp
Priority to CN202111317606.4A priority Critical patent/CN113837883B/en
Publication of CN113837883A publication Critical patent/CN113837883A/en
Application granted granted Critical
Publication of CN113837883B publication Critical patent/CN113837883B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q40/00Finance; Insurance; Tax strategies; Processing of corporate or income taxes
    • G06Q40/04Trading; Exchange, e.g. stocks, commodities, derivatives or currency exchange
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F18/00Pattern recognition
    • G06F18/20Analysing
    • G06F18/24Classification techniques
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q30/00Commerce
    • G06Q30/02Marketing; Price estimation or determination; Fundraising
    • G06Q30/0201Market modelling; Market analysis; Collecting market data
    • G06Q30/0206Price or cost determination based on market factors

Abstract

The application relates to the technical field of data analysis, in particular to a precious metal transaction data management method, a precious metal transaction data management device, a computer device and a storage medium, and aims to solve the problem that convenience in a precious metal transaction process cannot be guaranteed. The method comprises the following steps: acquiring to-be-processed precious metal transaction data, and extracting an initial precious metal currency pair corresponding to the to-be-processed precious metal transaction data; if the initial noble metal currency pair is not matched with a preset reference noble metal currency pair, carrying out data splitting processing on the to-be-processed noble metal transaction data based on a prestored data splitting strategy to obtain target noble metal exposure data and target currency exposure data; and in the transaction record set, the obtained target noble metal exposure data and the target currency exposure data are stored as newly added transaction records.

Description

Noble metal transaction data management method and device, computer equipment and storage medium
Technical Field
The present application relates to the field of data analysis technologies, and in particular, to a noble metal transaction data management method and apparatus, a computer device, and a storage medium.
Background
With the continuous development of financial technology, more and more financial platforms can provide precious metal transaction services. Due to the diversification of culture, the currency types are rich and diverse, and the financial platform cannot comprehensively provide the precious metal data corresponding to all the currency types, and generally only provides the precious metal data corresponding to one currency type, for example, the unit price of the precious metal provided in the form of dollars on the financial platform.
However, since the currency types of the respective regions are different from those provided on the financial platform, when the historical data management of precious metal transaction is performed in the respective regions, the data management is usually performed in the form of the local currency types, and then, when the precious metal transaction is performed each time, a series of conversion processes such as currency conversion and the like are performed according to the historical data of the precious metal transaction, and then a new transaction plan of the precious metal is prepared, so that the precious metal transaction can be performed on the financial platform. Therefore, the conventional precious metal transaction management method cannot ensure the convenience of the precious metal transaction process.
Disclosure of Invention
The embodiment of the application provides a noble metal transaction data management method and device, computer equipment and a storage medium, which are used for solving the problem that convenience in a noble metal transaction process cannot be guaranteed.
In a first aspect, a precious metal transaction data management method is provided, including:
acquiring to-be-processed precious metal transaction data, and extracting an initial precious metal currency pair corresponding to the to-be-processed precious metal transaction data, wherein the initial precious metal currency pair is used for representing an initial metering unit of initial precious metal and an initial currency type of initial currency contained in the to-be-processed precious metal transaction data;
if the initial precious metal currency pair is not matched with a preset reference precious metal currency pair, performing data splitting processing on the to-be-processed precious metal transaction data based on a prestored data splitting strategy to obtain target precious metal exposure data and target currency exposure data, wherein the target precious metal exposure data at least comprise target precious metals and target currencies, the target precious metals and the target currencies respectively represent the initial precious metals and the initial currencies by reference metering units and reference currency types contained in the reference precious metal currency pair, and the target currency exposure data is used for representing data conversion relations between the initial currencies and the target currencies;
and in the transaction record set, the obtained target noble metal exposure data and the target currency exposure data are stored as newly added transaction records.
Optionally, if the initial precious metal currency pair is not matched with a preset reference precious metal currency pair, based on a pre-stored data splitting policy, performing data splitting processing on the to-be-processed precious metal transaction data to obtain target precious metal exposure data and target currency exposure data, including:
determining a first conversion factor between the initial measurement unit and the reference measurement unit, and a second conversion factor between the initial currency type and the reference currency type, based on the initial measurement unit and the initial currency type, and the reference measurement unit and the reference currency type;
performing data conversion processing on the initial precious metal and the initial currency respectively based on the first conversion coefficient and the second conversion coefficient to obtain target precious metal and the target currency respectively;
updating the to-be-processed precious metal transaction data based on the reference precious metal currency pair, the target precious metal and the target currency to obtain target precious metal exposure data;
obtaining the target currency exposure data based on the second conversion factor, the initial currency, and the target currency.
Optionally, after adding a new transaction record in the transaction record set based on the obtained target precious metal exposure data and target currency exposure data, the method further includes:
in response to a withdrawal operation triggered by the target precious metal exposure data and the target currency exposure data, determining precious metal exposure withdrawal data and currency exposure withdrawal data based on the values of the target precious metals with opposite signs and the values of the target currency with opposite signs, and adding a transaction record in the transaction record set based on the obtained precious metal exposure withdrawal data and the obtained currency exposure withdrawal data;
and responding to a modification operation triggered by the target precious metal exposure data and the target currency exposure data, obtaining modified target precious metal exposure data and modified target currency exposure data, and adding a transaction record in the transaction record set based on the modified target precious metal exposure data and the modified target currency exposure data.
Optionally, after adding a new transaction record in the transaction record set based on the obtained target precious metal exposure data and target currency exposure data, the method further includes:
responding to editing operation triggered by a monitoring interface, and acquiring a target monitoring range and a target monitoring standard, wherein the target monitoring range is used for indicating a screening condition for a transaction record, and the target monitoring standard is used for indicating a data calculation target for the transaction record;
determining whether the newly added transaction records meet the target monitoring range or not when the transaction records are newly added in the transaction record set, and acquiring each target transaction record meeting the target monitoring range in a first preset time interval when the first preset time interval passes;
based on a pre-stored data calculation strategy, performing data calculation on data contained in each obtained target transaction record to obtain a data calculation result meeting the target monitoring standard;
and calculating a result based on the obtained data, generating a target monitoring result, and presenting the obtained target monitoring result in the monitoring interface.
Optionally, for each transaction record included in the transaction record set, a transaction classification and a transaction account triggering precious metal transaction are respectively recorded, and the target monitoring range includes a target transaction classification and a target transaction account;
determining whether the newly added transaction record meets the target monitoring range each time a new transaction record is added to the transaction record set, and obtaining each target transaction record meeting the target monitoring range within a first preset time interval each time the first preset time interval passes, including:
respectively determining whether the transaction classification of the newly added transaction record is the same as the target transaction classification, and whether the transaction account of the newly added transaction record is the same as the target transaction account;
if the transaction classification of the newly added transaction record is the same as the target transaction classification and the transaction account of the newly added transaction record is the same as the target transaction account, determining that the newly added transaction record meets the target monitoring range;
and each time a first preset time interval passes, acquiring each target transaction record based on each newly-added transaction record meeting the target monitoring range in the first preset time interval.
Optionally, the target monitoring criteria include a target net position, a target net amount, a target average price and a target profit and loss for each precious metal currency pair;
then, based on the pre-stored data calculation strategy, performing data calculation on the data included in each obtained target transaction record to obtain a data calculation result meeting the target monitoring standard, including:
respectively counting the total amount of the target precious metals and the total amount of the target currency aiming at the target transaction records of the same precious metal currency pair in each target transaction record, and respectively obtaining the target net position and the target net amount corresponding to each precious metal currency pair;
obtaining target average prices of the various precious metal currency pairs respectively based on the ratio of the target currency total amount and the target precious metal total amount of the various precious metal currency pairs respectively;
acquiring the market price of the precious metal corresponding to each precious metal currency pair;
obtaining target profit and loss corresponding to each precious metal currency pair based on the target currency total amount corresponding to each precious metal currency pair and the sum of the product of the target precious metal total amount and the precious metal market price;
and taking the target net position, the target net amount, the target average price and the target profit and loss of each noble metal currency pair as data calculation results meeting the target monitoring standard.
Optionally, for each transaction record, a transaction time is recorded, where the transaction time is used to characterize a generation time of the corresponding transaction record, and the method further includes:
every time a second preset time interval passes, acquiring each transaction record to be reevaluated with the transaction time within the second preset time interval from each transaction record;
based on the data calculation strategy, performing data calculation on the transaction records of the same noble metal currency pair in each transaction record to be reevaluated to obtain a target reevaluation result;
and presenting the target reevaluation result in the monitoring interface in response to reevaluation monitoring operation triggered by the monitoring interface.
Optionally, an interface state and a display time are recorded for the monitoring interface, where the interface state is used to represent whether the monitoring interface is displayed, and the display time is used to represent a time when the monitoring state of the monitoring interface recorded last time is a display state;
after the target monitoring range and the target monitoring standard are obtained in response to the editing operation triggered by the monitoring interface, the method further includes:
updating the interface state of the monitoring interface to a display state, and updating the display time of the monitoring interface based on the current time;
and if a display signal aiming at the monitoring interface is received within a preset time length taking the display time as an initial time, updating the display time based on the current time, otherwise, updating the interface state to a closed state, wherein the display signal is used for representing that the monitoring interface is displaying.
Optionally, before presenting the obtained target monitoring result in the monitoring interface, the method further includes:
acquiring the interface state of the monitoring interface;
and if the interface state represents that the monitoring interface is in a display state, presenting an obtained target monitoring result in the monitoring interface.
In a second aspect, there is provided a precious metal transaction data management apparatus including:
an acquisition module: the system comprises a data processing module, a data processing module and a data processing module, wherein the data processing module is used for acquiring to-be-processed precious metal transaction data and extracting an initial precious metal currency pair corresponding to the to-be-processed precious metal transaction data, and the initial precious metal currency pair is used for representing an initial metering unit of initial precious metal and an initial currency type of initial currency contained in the to-be-processed precious metal transaction data;
a processing module: if the initial precious metal currency pair is not matched with a preset reference precious metal currency pair, performing data splitting processing on the to-be-processed precious metal transaction data based on a prestored data splitting strategy to obtain target precious metal exposure data and target currency exposure data, wherein the target precious metal exposure data at least comprise target precious metals and target currencies, the target precious metals and the target currencies respectively represent the initial precious metals and the initial currencies in reference metering units and reference currency types contained in the reference precious metal currency pair, and the target currency exposure data is used for representing data conversion relations between the initial currencies and the target currencies;
the processing module is further configured to: and in the transaction record set, the obtained target noble metal exposure data and the target currency exposure data are stored as newly added transaction records.
Optionally, the processing module is specifically configured to:
determining a first conversion factor between the initial measurement unit and the reference measurement unit, and a second conversion factor between the initial currency type and the reference currency type, based on the initial measurement unit and the initial currency type, and the reference measurement unit and the reference currency type;
performing data conversion processing on the initial precious metal and the initial currency respectively based on the first conversion coefficient and the second conversion coefficient to obtain target precious metal and the target currency respectively;
updating the to-be-processed precious metal transaction data based on the reference precious metal currency pair, the target precious metal and the target currency to obtain target precious metal exposure data;
obtaining the target currency exposure data based on the second conversion factor, the initial currency, and the target currency.
Optionally, the processing module is further configured to:
after adding a new transaction record in a transaction record set based on the obtained target precious metal exposure data and target currency exposure data, determining precious metal exposure cancellation data and currency exposure cancellation data based on the values of the target precious metals with opposite signs and the values of the target currency with opposite signs in response to a cancellation operation triggered on the target precious metal exposure data and the target currency exposure data, and adding a new transaction record in the transaction record set based on the obtained precious metal exposure cancellation data and the currency exposure cancellation data;
and responding to a modification operation triggered by the target precious metal exposure data and the target currency exposure data, obtaining modified target precious metal exposure data and modified target currency exposure data, and adding a transaction record in the transaction record set based on the modified target precious metal exposure data and the modified target currency exposure data.
Optionally, the processing module is further configured to:
after transaction records are newly added in a transaction record set based on the obtained target precious metal exposure data and the target currency exposure data, a target monitoring range and a target monitoring standard are obtained in response to an editing operation triggered aiming at a monitoring interface, wherein the target monitoring range is used for indicating a screening condition aiming at the transaction records, and the target monitoring standard is used for indicating a data calculation target aiming at the transaction records;
determining whether the newly added transaction records meet the target monitoring range or not when the transaction records are newly added in the transaction record set, and acquiring each target transaction record meeting the target monitoring range in a first preset time interval when the first preset time interval passes;
based on a pre-stored data calculation strategy, performing data calculation on data contained in each obtained target transaction record to obtain a data calculation result meeting the target monitoring standard;
and calculating a result based on the obtained data, generating a target monitoring result, and presenting the obtained target monitoring result in the monitoring interface.
Optionally, for each transaction record included in the transaction record set, a transaction classification and a transaction account triggering precious metal transaction are respectively recorded, and the target monitoring range includes a target transaction classification and a target transaction account;
the processing module is specifically configured to:
respectively determining whether the transaction classification of the newly added transaction record is the same as the target transaction classification, and whether the transaction account of the newly added transaction record is the same as the target transaction account;
if the transaction classification of the newly added transaction record is the same as the target transaction classification and the transaction account of the newly added transaction record is the same as the target transaction account, determining that the newly added transaction record meets the target monitoring range;
and each time a first preset time interval passes, acquiring each target transaction record based on each newly-added transaction record meeting the target monitoring range in the first preset time interval.
Optionally, the target monitoring criteria include a target net position, a target net amount, a target average price and a target profit and loss for each precious metal currency pair;
the processing module is specifically configured to:
respectively counting the total amount of the target precious metals and the total amount of the target currency aiming at the target transaction records of the same precious metal currency pair in each target transaction record, and respectively obtaining the target net position and the target net amount corresponding to each precious metal currency pair;
obtaining target average prices of the various precious metal currency pairs respectively based on the ratio of the target currency total amount and the target precious metal total amount of the various precious metal currency pairs respectively;
acquiring the market price of the precious metal corresponding to each precious metal currency pair;
obtaining target profit and loss corresponding to each precious metal currency pair based on the target currency total amount corresponding to each precious metal currency pair and the sum of the product of the target precious metal total amount and the precious metal market price;
and taking the target net position, the target net amount, the target average price and the target profit and loss of each noble metal currency pair as data calculation results meeting the target monitoring standard.
Optionally, for each transaction record, transaction time is recorded, where the transaction time is used to characterize a generation time of the corresponding transaction record, and the processing module is further configured to:
every time a second preset time interval passes, acquiring each transaction record to be reevaluated with the transaction time within the second preset time interval from each transaction record;
based on the data calculation strategy, performing data calculation on the transaction records of the same noble metal currency pair in each transaction record to be reevaluated to obtain a target reevaluation result;
and presenting the target reevaluation result in the monitoring interface in response to reevaluation monitoring operation triggered by the monitoring interface.
Optionally, an interface state and a display time are recorded for the monitoring interface, where the interface state is used to represent whether the monitoring interface is displayed, and the display time is used to represent a time when the monitoring state of the monitoring interface recorded last time is a display state;
the processing module is further configured to:
after a target monitoring range and a target monitoring standard are obtained in response to editing operation triggered by a monitoring interface, updating the interface state of the monitoring interface to a display state, and updating the display time of the monitoring interface based on the current time;
and if a display signal aiming at the monitoring interface is received within a preset time length taking the display time as an initial time, updating the display time based on the current time, otherwise, updating the interface state to a closed state, wherein the display signal is used for representing that the monitoring interface is displaying.
Optionally, the processing module is further configured to:
acquiring the interface state of the monitoring interface before presenting the obtained target monitoring result in the monitoring interface;
and if the interface state represents that the monitoring interface is in a display state, presenting an obtained target monitoring result in the monitoring interface.
In a third aspect, a computer device is provided, comprising:
a memory for storing program instructions;
a processor for calling the program instructions stored in the memory and executing the method according to the first aspect according to the obtained program instructions.
In a fourth aspect, there is provided a computer-readable storage medium having stored thereon computer-executable instructions for causing a computer to perform the method of the first aspect.
In the embodiment of the application, after the to-be-processed precious metal transaction data is obtained, whether data splitting processing needs to be performed on the to-be-processed precious metal transaction data or not can be judged according to the initial precious metal currency pair corresponding to the to-be-processed precious metal transaction data, and target precious metal exposure data and target currency exposure data are obtained. Thus, pending precious metal transaction data may be saved in the transaction record set in the form of a reference precious metal currency pair when the initial precious metal currency pair does not match the reference precious metal currency pair. When transaction data analysis is carried out on each transaction record according to the transaction record set subsequently, data conversion does not need to be carried out on the transaction data stored in the transaction record first, the convenience of transaction data analysis is improved, and the transaction convenience is higher when noble metal transaction is carried out continuously according to the transaction data analysis result.
Furthermore, the target noble metal exposure data represents the initial noble metal and the initial currency contained in the to-be-processed noble metal transaction data respectively according to the reference metering unit and the reference currency contained in the reference noble metal currency pair, so that when historical noble metal transaction data management is performed, transaction data analysis and transaction data management can be performed according to the target noble metal and the target currency contained in the target noble metal exposure data, and transaction is directly performed on a financial platform according to the transaction data analysis and transaction data management results, so that the convenience of the noble metal transaction process is improved, and the data conversion process caused by the difference between the initial noble metal and the initial currency contained in each to-be-processed noble metal transaction data is avoided.
The target currency exposure data represents the initial currency and the data conversion relation between the target currency, so that the initial currency can be directly obtained when the initial currency is needed to be used for transaction data management, and convenience of a precious metal transaction process is improved.
Drawings
Fig. 1 is an application scenario of a precious metal transaction data management method according to an embodiment of the present application;
fig. 2 is a schematic flowchart of a precious metal transaction data management method according to an embodiment of the present disclosure;
fig. 3 is a schematic diagram illustrating a first principle of a precious metal transaction data management method according to an embodiment of the present application;
fig. 4 is a schematic diagram illustrating a second principle of a precious metal transaction data management method according to an embodiment of the present application;
fig. 5 is a schematic diagram illustrating a third principle of a precious metal transaction data management method according to an embodiment of the present application;
fig. 6 is a schematic diagram illustrating a principle of a precious metal transaction data management method according to an embodiment of the present application;
fig. 7 is a schematic diagram illustrating a principle of a precious metal transaction data management method according to an embodiment of the present application;
fig. 8 is a schematic structural diagram of a precious metal transaction data management device according to an embodiment of the present application;
fig. 9 is a schematic structural diagram of a precious metal transaction data management device according to an embodiment of the present application.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present application clearer, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application.
Some terms in the embodiments of the present application are explained below to facilitate understanding by those skilled in the art.
(1) Opening the noble metal:
the noble metal exposure refers to the holding position of the transaction generated by the formation of the noble metal transaction. Generally, a buy transaction is marked as a positive exposure and a sell transaction is marked as a negative exposure.
(2) And (3) carrying out on-demand transaction on the precious metals:
the noble metal spot transaction refers to spot transaction in which two transaction parties deal with each other immediately or in two business days. Including the following types of transactions: the method comprises the following steps of precious metal spot transaction, precious metal futures transaction, personal real object gold trading transaction, account precious metal bidirectional transaction, precious metal consignment buying transaction, place swap transaction, deposit-to-customer transaction and gold exchange postponed delivery transaction.
The following briefly introduces the application field of the precious metal transaction data management method provided by the embodiment of the present application.
With the continuous development of financial technology, more and more financial platforms can provide precious metal transaction services. Due to the diversification of culture, the currency types are rich and diverse, and the financial platform cannot comprehensively provide the precious metal data corresponding to all the currency types, and generally only provides the precious metal data corresponding to one currency type, for example, the unit price of the precious metal provided in the form of dollars on the financial platform.
However, since the currency types of the respective regions are different from those provided on the financial platform, when the historical data management of precious metal transaction is performed in the respective regions, the data management is usually performed in the form of the local currency types, and then, when the precious metal transaction is performed each time, a series of conversion processes such as currency conversion and the like are performed according to the historical data of the precious metal transaction, and then a new transaction plan of the precious metal is prepared, so that the precious metal transaction can be performed on the financial platform. Therefore, the conventional precious metal transaction management method cannot ensure the convenience of the precious metal transaction process.
In order to solve the problem that convenience of a noble metal transaction process cannot be guaranteed, the application provides a noble metal transaction data management method. After obtaining the to-be-processed precious metal transaction data, extracting an initial precious metal currency pair corresponding to the to-be-processed precious metal transaction data, wherein the initial precious metal currency pair is used for representing an initial metering unit of initial precious metal and an initial currency type of initial currency contained in the to-be-processed precious metal transaction data.
And if the initial noble metal currency pair is not matched with the preset reference noble metal currency pair, carrying out data splitting processing on the to-be-processed noble metal transaction data based on a prestored data splitting strategy to obtain target noble metal exposure data and target currency exposure data, and storing the obtained target noble metal exposure data and the target currency exposure data as new transaction records in the transaction record set.
The target noble metal exposure data at least comprises target noble metals and target currencies, the target noble metals and the target currencies respectively represent the initial noble metals and the initial currencies by reference metering units and reference currency types contained in the reference noble metal currency pair, and the target currency exposure data is used for representing the data conversion relationship between the initial currencies and the target currencies.
In the embodiment of the application, after the to-be-processed precious metal transaction data is obtained, whether data splitting processing needs to be performed on the to-be-processed precious metal transaction data or not can be judged according to the initial precious metal currency pair corresponding to the to-be-processed precious metal transaction data, and target precious metal exposure data and target currency exposure data are obtained. Thus, pending precious metal transaction data may be saved in the transaction record set in the form of a reference precious metal currency pair when the initial precious metal currency pair does not match the reference precious metal currency pair. When transaction data analysis is carried out on each transaction record according to the transaction record set subsequently, data conversion does not need to be carried out on the transaction data stored in the transaction record first, the convenience of transaction data analysis is improved, and the transaction convenience is higher when noble metal transaction is carried out continuously according to the transaction data analysis result.
Furthermore, the target noble metal exposure data represents the initial noble metal and the initial currency contained in the to-be-processed noble metal transaction data respectively according to the reference metering unit and the reference currency contained in the reference noble metal currency pair, so that when historical noble metal transaction data management is performed, transaction data analysis and transaction data management can be performed according to the target noble metal and the target currency contained in the target noble metal exposure data, and transaction is directly performed on a financial platform according to the transaction data analysis and transaction data management results, so that the convenience of the noble metal transaction process is improved, and the data conversion process caused by the difference between the initial noble metal and the initial currency contained in each to-be-processed noble metal transaction data is avoided.
The target currency exposure data represents the initial currency and the data conversion relation between the target currency, so that the initial currency can be directly obtained when the initial currency is needed to be used for transaction data management, and convenience of a precious metal transaction process is improved.
An application scenario of the precious metal transaction data management method provided by the present application is described below.
Please refer to fig. 1, which is an application scenario of the precious metal transaction data management method according to the embodiment of the present application. The application scenario includes a client 101 and a server 102. The client 101 and the server 102 may communicate with each other, and the communication may be performed by using a wired communication technology, for example, by using a connection network or a serial port; the communication may also be performed by using a wireless communication technology, for example, communication may be performed by using technologies such as bluetooth or wireless fidelity (WIFI), and the like, which is not limited specifically.
The client 101 generally refers to a device that can provide the server 102 with the to-be-processed precious metal transaction data, for example, a terminal device, a third-party application accessible by the terminal device, or a web page accessible by the terminal device. The terminal devices include, but are not limited to, mobile phones, computers, intelligent medical devices, intelligent electrical appliances, and the like.
The server 102 generally refers to a device, such as a terminal device or a server, which can manage the precious metal transaction data to be processed. Servers include, but are not limited to, cloud servers, local servers, or associated third party servers, etc. The client 101 and the server 102 can both adopt cloud computing to reduce the occupation of local computing resources; cloud storage can also be adopted to reduce the occupation of local storage resources.
As an embodiment, the client 101 and the server 102 may be the same device, and in this embodiment, the client 101 and the server 102 are respectively different devices for example.
Referring to fig. 1, a detailed description is given of the precious metal transaction data management method according to an embodiment of the present application, taking a client 101 as a client and a server 102 as a server as an example.
Please refer to fig. 2, which is a flowchart illustrating a precious metal transaction data management method according to an embodiment of the present disclosure.
S201, obtaining to-be-processed precious metal transaction data, and extracting an initial precious metal currency pair corresponding to the to-be-processed precious metal transaction data.
The server can obtain initial transaction data, and then extract the key field data contained in the initial transaction data to obtain the to-be-processed precious metal transaction data; the server may also use the obtained initial transaction data as the to-be-processed precious metal transaction data, and the like, which is not limited specifically.
For example, the client obtains initial transaction data in response to a transaction operation triggered by a transaction object. In the initial transaction data, a variety of field data is contained. According to preset field requirement information, for example, the field requirement information comprises a transaction number, a transaction classification, a transaction state, a position holding direction, initial precious metals, initial currency, precious metal unit price, an initial precious metal currency pair, an account number, a transaction object number and the like, the server extracts key field data which meet the field requirement information in the initial transaction data, and generates to-be-processed precious metal transaction data.
After obtaining the pending precious metal transaction data, the server may extract an initial precious metal currency pair corresponding to the pending precious metal transaction data. The server can extract corresponding field data according to fields contained in the to-be-processed precious metal transaction data, namely initial precious metal currency pair fields, and obtain initial precious metal currency pairs corresponding to the to-be-processed precious metal transaction data; the server may also identify an initial metering unit of the initial precious metal and a currency type of the initial currency included in the to-be-processed precious metal transaction data according to the to-be-processed precious metal transaction data, and obtain an initial precious metal currency equivalent corresponding to the to-be-processed precious metal transaction data, which is not limited specifically.
As an embodiment, the to-be-processed precious metal transaction data is mainly divided into three categories, namely a first category, for guest transactions, the transactions between a branch bank and a guest are mainly referred to, and the method comprises the following steps: the method comprises the following steps of personal real object gold transaction, account precious metal two-way transaction, deposited fund to guest transaction, and the transaction mode is recorded as system input transaction; the second kind, self-service or flat-plate trade, mainly refers to the trade between the head office and the trade opponent, including: the method comprises the following steps of carrying out precious metal spot transaction, precious metal futures transaction, precious metal consignment purchase transaction, place swap transaction, gold exchange delayed delivery transaction and foreign exchange spot transaction, wherein the transaction mode is recorded as manual input transaction; and in the third category, the noble metal which is separated from the noble metal forward transaction is subjected to immediate transaction, the transaction type is the noble metal spot transaction, and the transaction mode is recorded as the system separation transaction.
S202, if the initial noble metal currency pair is not matched with the preset reference noble metal currency pair, carrying out data splitting processing on the to-be-processed noble metal transaction data based on a pre-stored data splitting strategy to obtain target noble metal exposure data and target currency exposure data.
After obtaining the pending precious metal transaction data, and the initial precious metal currency pair, the server may match the initial precious metal currency pair with a pre-set reference precious metal currency pair. The reference noble metal currency pair may be a pre-configured noble metal currency pair that may be used in a data format for noble metal data that characterizes various noble metals provided in a financial platform. For example, in an international financial platform, the precious metal data provided includes gold at a unit price of $ 100 per 1 ounce, and then gold in the reference precious metal currency pair corresponds to gold ounces/dollars. The reference precious metal currency pair may also be other precious metal currency pairs for uniformly managing precious metal transaction data, and is not particularly limited.
If the initial noble metal currency pair is matched with the preset reference noble metal currency pair, the to-be-processed noble metal transaction data is in the form of the reference noble metal currency pair, and the data does not need to be processed, the to-be-processed noble metal transaction data can be directly stored in the transaction record set.
If the initial noble metal currency pair is not matched with the preset reference noble metal currency pair, the to-be-processed noble metal transaction data needs to be processed into a form of the reference noble metal currency pair, so that unified management is facilitated, subsequent direct data analysis is facilitated, and then subsequent noble metal transaction is performed, the server can perform data splitting processing on the to-be-processed noble metal transaction data based on a pre-stored data splitting strategy, and target noble metal exposure data and target currency exposure data are obtained.
The following describes a process of performing data splitting processing on the to-be-processed precious metal transaction data based on a pre-stored data splitting strategy.
After obtaining the initial precious metal currency pair, the server may determine a first conversion factor between the initial metering unit and the reference metering unit, and a second conversion factor between the initial currency type and the reference currency type based on the initial metering unit and the initial currency type included in the initial precious metal currency pair, and the reference metering unit and the reference currency type included in the reference precious metal currency pair.
The server may determine an association relationship between the initial metering unit and the reference metering unit in a first mapping relationship between pre-stored precious metal metering units, so as to obtain a first conversion coefficient between the initial metering unit and the reference metering unit. For example, the initial measurement unit is grams and the reference measurement unit is ounces, then in the first mapping, the relationship between grams and ounces is 1 ounce-31.1034768 grams, and the first conversion factor can be expressed as ounces/gram-1/31.1034768.
The server may determine an association between the initial currency type and the reference currency type in a second mapping relationship between pre-stored currency ratios yellow total to obtain a second conversion factor between the initial currency type and the reference currency type. For example, if the initial currency type is rmb and the reference currency type is U.S. dollars, then in the second mapping relationship, the relationship between rmb and U.S. dollars is 1 U.S. dollar to 7.036, and the second conversion factor can be expressed as U.S. dollar/rmb $ 1/7.036.
After obtaining the first conversion coefficient and the second conversion coefficient, the server may perform data conversion processing on the initial precious metal and the initial currency, respectively, based on the first conversion coefficient and the second conversion coefficient, to obtain the target precious metal and the target currency, respectively.
For example, if the first conversion factor is 1/31.1034768 ounces/gram and the initial precious metal is 100 grams, then after data conversion, the target precious metal is 100/31.1034768 ounces. The second conversion factor is $ 1/7.036 for the initial currency of 100 RMB, then after data conversion the target currency is 100/7.034.
After obtaining the target precious metal and the target currency, the server may update the pending precious metal transaction data based on the reference precious metal currency pair, the target precious metal, and the target currency to obtain target precious metal exposure data. For example, the server updates the initial currency in the pending precious metal transaction data to the target currency, updates the initial precious metal to the target precious metal, updates the initial precious metal currency pair to the reference precious metal currency pair, and generates the target precious metal exposure data based on the updated pending precious metal transaction data.
The server may obtain target currency exposure data based on the second conversion factor, the initial currency, and the target currency. The target currency exposure data is used to characterize the initial currency and the target currency, and a second conversion factor between the initial currency and the target currency at the current transaction time.
In the following, a process of performing data splitting processing on to-be-processed precious metal transaction data based on a pre-stored data splitting policy is described as an example according to a specific embodiment.
For example, the data of the to-be-processed precious metal transaction is that 185365 yuan RMB is adopted to buy 500 g of gold, and the unit price of the precious metal corresponding to the current gold is 370.73 yuan/g, please refer to Table 1.
TABLE 1
Figure BDA0003344301130000161
AUB/CNY represents an initial noble metal currency pair corresponding to the to-be-processed noble metal transaction data, namely gold gram/RMB; XAU/USD denotes a reference noble metal currency pair, gold ounces/dollars; USD/CNY represents a currency pair of the target currency and the initial currency, i.e., USD/RMB.
After obtaining the pending precious metal transaction data, an initial precious metal currency pair is obtained as gold grams/renminbi, an initial measurement unit is determined as grams, and the initial currency type is renminbi. The reference precious metal currency pair is gold ounces/dollars, the reference unit of measurement is determined to be ounces, and the reference currency is dollars. The server may determine the first conversion factor, i.e., ounces/gram, as 1/31.1034768 based on the initial unit of measure, i.e., grams, and the reference unit of measure, i.e., ounces. The server may determine the second conversion factor, i.e., dollar/rmb, to be 1/7.034 based on the initial currency, i.e., rmb, and the reference currency, i.e., dollar.
The unit price of the precious metal gold is 370.73 yuan/g, before data splitting processing, the to-be-processed precious metal transaction data comprises 500 g of initial precious metal, the initial currency is-185365.00 yuan RMB, the symbol of the initial currency indicates that the user buys or sells, the buys are negative numbers, and the sells are positive numbers. That is, the pending precious metal transaction data is indicative of the cost of 185365.00 yuan, buying 500 grams of gold at a gold price of 370.73 yuan/gram.
In the data splitting process, the server may perform a data conversion process on the initial precious metal to convert to the target precious metal, i.e., 500 grams to 16.0745 ounces, based on a first conversion factor. The server may perform a data conversion process on the initial currency into the target currency, i.e., -185365.00 yuan, into-26352.72 dollars, based on the second conversion coefficient.
After the data splitting process, the server may obtain the precious metal gold unit price in the form of a reference precious metal currency pair, i.e., $ 1639.32/ounce.
The server may update the pending precious metal transaction data based on the reference precious metal currency pair, the target precious metal, and the target currency to obtain target precious metal exposure data. The server may obtain target currency exposure data based on the second conversion factor, the initial currency, and the target currency.
For another example, the data of the to-be-processed precious metal transaction is to buy 1000 grams of gold, 371230.00 yuan renowned folk is obtained, and the current precious metal unit price corresponding to gold is 371.23 yuan/gram, please refer to table 2.
TABLE 2
Figure BDA0003344301130000171
Figure BDA0003344301130000181
AUB/CNY represents an initial noble metal currency pair corresponding to the to-be-processed noble metal transaction data, namely gold gram/RMB; XAU/USD denotes a reference noble metal currency pair, gold ounces/dollars; USD/CNY represents a currency pair of the target currency and the initial currency, i.e., USD/RMB.
After obtaining the pending precious metal transaction data, an initial precious metal currency pair is obtained as gold grams/renminbi, an initial measurement unit is determined as grams, and the initial currency type is renminbi. The reference precious metal currency pair is gold ounces/dollars, the reference unit of measurement is determined to be ounces, and the reference currency is dollars. The server may determine the first conversion factor, i.e., ounces/gram, as 1/31.1034768 based on the initial unit of measure, i.e., grams, and the reference unit of measure, i.e., ounces. The server may determine the second conversion factor, i.e., dollar/rmb, to be 1/7.036 based on the initial currency, i.e., rmb, and the reference currency, i.e., dollar.
The unit price of the precious metal gold is 371.23 yuan/g, before data splitting processing, the to-be-processed precious metal transaction data comprises-1000 g of initial precious metal, the initial currency is 371230.00 yuan RMB, the symbol of the initial precious metal indicates that the user buys or sells, the user buys a positive number, and the user sells a negative number. That is, the data of the noble metal transaction to be processed is characterized in that 1000 grams of gold is bought at the gold unit price of 371.23 yuan/gram, and 371230.00 yuan of RMB is obtained.
In performing the data splitting process, the server may perform a data conversion process on the initial precious metal to convert to the target precious metal, i.e., -1000 grams to-32.1507 ounces, based on the first conversion factor. The server may perform a data conversion process on the initial currency into the target currency, i.e., 371230.00 meta-renowned currency into $ 52761.51, based on the second conversion coefficient.
After the data splitting process, the server may obtain the precious metal gold unit price in the form of a reference precious metal currency pair, i.e., $ 1641.07/ounce.
The server may update the pending precious metal transaction data based on the reference precious metal currency pair, the target precious metal, and the target currency to obtain target precious metal exposure data. The server may obtain target currency exposure data based on the second conversion factor, the initial currency, and the target currency.
And S203, in the transaction record set, storing the obtained target noble metal exposure data and the target currency exposure data as newly added transaction records.
After obtaining the target noble metal exposure data and the target currency exposure data, the server may store the obtained target noble metal exposure data and the target currency exposure data as new transaction records in the transaction record set.
The transaction record set user records transaction data, which may include to-be-processed precious metal transaction data that does not need to be subjected to data splitting processing, and may also include target precious metal exposure data and target currency exposure data that are subjected to data splitting processing, and the like, and is not limited specifically.
As an embodiment, in order to ensure that the obtained to-be-processed precious metal transaction data is recorded when the precious metal transaction is completed, the client may send the transaction state to the server when the precious metal transaction is completed, or the client may feed back the transaction state to the server every time a preset time period elapses, which is not limited specifically.
The server can be used for feeding back the transaction state for the to-be-processed precious metal transaction data by the client, and when the transaction state is determined to be 'new', the obtained target precious metal exposure data and the target currency exposure data are stored as new transaction records in the transaction record set.
Referring to table 3, after receiving the transaction state fed back by the client for the to-be-processed precious metal transaction data, the server determines that the transaction state is "new", and if the to-be-processed precious metal transaction data does not need to be subjected to data splitting processing, stores the to-be-processed precious metal transaction data as a new transaction record in the transaction record set.
TABLE 3
Noble metal currency pair Status of transaction Noble metal Noble metal unit price Currency unit
AUB/CNY Adding new -1000.00 371.23 371230.00
Wherein AUB/CNY represents that the precious metal currency pair corresponding to the to-be-processed precious metal transaction data is gold gram/RMB; the data of the noble metal transaction to be processed comprises-1000.00 g of noble metal gold, 371230.00 yuan for the RMB currency, and 371.23 yuan/g of noble metal gold during transaction.
As an embodiment, the transaction status may also be "withdrawn" or "hedge", for example, when the target object withdraws the transaction data corresponding to a certain transaction record, the transaction status fed back from the client to the server may be "withdrawn". For another example, when the target object modifies the transaction data corresponding to a certain transaction record, the transaction state fed back to the server by the client may be "just.
As an embodiment, after the obtained target precious metal exposure data and the target currency exposure data are saved as the newly added transaction records in the transaction record set, if a withdrawal operation triggered for the target precious metal exposure data and the target currency exposure data is responded, the precious metal exposure withdrawal data and the currency exposure withdrawal data are determined based on the value of the target precious metal with opposite signs and the value of the target currency with opposite signs, and the transaction records are newly added in the transaction record set based on the obtained precious metal exposure withdrawal data and the currency exposure withdrawal data.
For example, referring to table 4, in response to the withdrawal operation triggered for the target precious metal exposure data, then the value of the target precious metal with the opposite sign, i.e., 1000.00, and the value of the target currency with the opposite sign, i.e., -371230.00, determine the precious metal exposure withdrawal data, and save the obtained precious metal exposure withdrawal data as the new added transaction record in the transaction record set. The modification process of the target currency exposure data is similar and will not be described in detail herein.
TABLE 4
Noble metal currency pair Status of transaction Noble metal Noble metal unit price Currency unit
AUB/CNY Adding new -1000.00 371.23 371230.00
AUB/CNY Revocation 1000.00 371.23 -371230.00
And if the modification operation triggered by the target precious metal exposure data and the target currency exposure data is responded, obtaining the modified target precious metal exposure data and the modified target currency exposure data, and adding a transaction record in the transaction record set based on the modified target precious metal exposure data and the modified target currency exposure data.
For another example, referring to table 5, if a modification operation is triggered in response to the targeted precious metal exposure data, modified targeted precious metal exposure data is obtained. The modified target precious metal exposure data contained precious metal-800.00 grams, currency 296984.00 dollars. The server determines noble metal exposure revocation data based on the value with the opposite sign of the target noble metal and the value with the opposite sign of the target currency, adds a transaction record in the transaction record set, and then adds a transaction record in the transaction record set based on the modified target noble metal exposure data. The modification process of the target currency exposure data is similar and will not be described in detail herein.
TABLE 5
Noble metal currency pair Status of transaction Noble metal Noble metal unit price Currency unit
AUB/CNY Adding new -1000.00 371.23 371230.00
AUB/CNY Revocation 1000.00 371.23 -371230.00
AUB/CNY Modifying -800.00 371.23 296984.00
As an example, after obtaining the target precious metal exposure data and the target currency exposure data, the server may present different data on the monitoring interface according to each transaction data recorded in the transaction record set.
And responding to an editing operation triggered by the monitoring interface, and acquiring a target monitoring range and a target monitoring standard, wherein the target monitoring range is used for indicating the screening condition aiming at the transaction record, and the target monitoring standard is used for indicating the data calculation target aiming at the transaction record.
For example, the target monitoring range includes a monitoring range for transaction classification, and a monitoring range for transaction objects, the transaction classification represents classification of transaction data corresponding to the transaction record, and the transaction object represents an object triggering the transaction corresponding to the transaction record. The server can respond to the selection operation of the target object on the client side aiming at the transaction classification and the transaction object displayed in the monitoring interface, determine at least one transaction classification or at least one transaction object, and obtain a target monitoring range. Therefore, the server can screen out the transaction record corresponding to the transaction classification in at least one transaction classification; the server can also screen out the transaction object as a transaction record corresponding to the transaction object in at least one transaction object.
Referring to fig. 3, the monitoring interface includes a selection area of transaction classifications and transaction objects, which includes a plurality of selectable transaction classifications and a plurality of selectable transaction classification sets, and the number of the transaction classifications or the transaction classifications included in each transaction classification set is different correspondingly; the monitoring interface further comprises a plurality of selectable transaction objects and a plurality of selectable transaction object sets, and the number of the transaction objects or the number of the transaction objects contained in each transaction object set are different correspondingly.
The monitoring interface can also comprise a query area of the transaction classification or the transaction object, and the transaction classification or the transaction object queried by the target object in the query area can only appear in the selection area. The monitoring interface can also comprise a 'confirm' key and a 'cancel' key, wherein the 'confirm' key is triggered to determine that the selected transaction classification or transaction object is used for screening, and the 'cancel' key is triggered to cancel the selection of the transaction classification or transaction object.
For another example, the target monitoring range includes a monitoring range for a transaction source, and a monitoring range for a transaction mode, the transaction source represents a type of a transaction corresponding to the transaction record, and the transaction mode represents a form of triggering record transaction data. The server can respond to the selection operation of the target object on the client for the transaction source and the transaction mode displayed in the monitoring interface, determine at least one transaction source or at least one transaction mode, and obtain the target monitoring range. Therefore, the server can screen the transaction records of which the transaction sources are the transaction sources in at least one transaction source; the server can also screen out transaction records corresponding to the transaction modes in at least one transaction mode.
Referring to fig. 4, the monitoring interface may include a selection area of transaction sources and transaction modes, which includes a plurality of selectable transaction sources and a plurality of selectable transaction modes. The transaction sources may include "precious metal spot transaction", "precious metal futures transaction", "personal real-object gold transaction", "account precious metal two-way transaction", "precious metal consignment purchase transaction", "location swap transaction", "deposited-money-to-customer transaction", "gold-to-exchange deferred delivery transaction", and "forex spot trade", etc. The transaction modes can comprise manual entry transaction, system split transaction and the like.
The monitoring interface can also comprise a selection area aiming at the screening dimension, wherein the selection area comprises a detail dimension used for presenting each transaction data and a summarization dimension used for presenting the statistical results of all transaction data. The monitoring interface can also comprise a 'confirm' key and a 'cancel' key, the 'confirm' key is triggered to determine that the selected transaction source and the selected transaction mode are selected, and the 'cancel' key is triggered to cancel the selection of the transaction source and the transaction mode.
For another example, the target monitoring criteria include a monitoring criterion for net position and a monitoring criterion for net amount, and then after screening out each transaction record, the server may perform data calculation on data included in each transaction record based on a pre-stored data calculation policy to obtain net position and net amount, and present the obtained net position and net amount in the monitoring interface.
Referring to fig. 5, the monitoring interface includes fields and a selection area of currency pairs, which includes various selectable fields, such as net position, net amount, average price, precious metal market price, profit and loss, multiple average price, multiple amount, empty average price, empty amount, bid average price, bid amount, sell average price, and sell amount.
The coin pair can be a pair between precious metal and coin or a pair between the coin and the coin. For example, XAU/USD, XAG/USD, XPT/USD, AUA/CNY, AUB/CNY, AGA/CNY, PTA/CNY, au2106/CNY and ag2108/CNY, etc.
The monitoring interface can also comprise an 'confirm' button and a 'cancel' button, the 'confirm' button can be triggered to confirm that the selected field and currency pair is screened, and the 'cancel' button can be triggered to cancel the selection of the field and currency pair.
As an embodiment, the server may present, after the target monitoring range, all transaction records in the transaction record set that satisfy the target monitoring range on the monitoring interface; the server can also perform data calculation on all transaction records in the transaction record set based on a pre-stored data calculation strategy after obtaining the target monitoring standard, generate a target monitoring result based on the data calculation result, and present the obtained target monitoring result in a monitoring interface; the server can also screen out the transaction records meeting the target monitoring range in the transaction record set after obtaining the target monitoring range and the target monitoring standard, then perform data calculation on the screened transaction records based on a pre-stored data calculation strategy, generate a target monitoring result based on the data calculation result, and place the target monitoring result in a monitoring interface.
As an embodiment, after the server obtains the target monitoring range, the target monitoring standard, or the target monitoring range and the target monitoring standard, the server may also monitor a newly added transaction record in the transaction record set in real time. Taking the example that the server obtains the target monitoring range and the target monitoring standard, the server determines whether the newly added transaction record meets the target monitoring range every time the transaction record is newly added in the transaction record set, and obtains each target transaction record meeting the target monitoring range within a first preset time interval every time the first preset time interval passes.
For example, a transaction source and a transaction mode are recorded for each transaction record included in the transaction record set, and the target monitoring range includes a target transaction source and a target transaction mode. Then, after the client obtains the target monitoring range, the client can push the target monitoring range and the TOPIC of the monitoring interface to the server, and the server stores the received target monitoring range in the memory. And the server determines a target monitoring result according to the screening dimension.
For the case where the screening dimension is "detail," the server may query for transaction records generated on the day that have not been reevaluated and whose pushed status is "not pushed. And the server screens the obtained transaction records according to the transaction source type and the transaction mode to obtain each target transaction record. The server can take the data contained in the target transaction record as a target monitoring result and push the data to a monitoring interface in the client end one by one according to TOPIC for presentation. And after the data corresponding to the target transaction record is pushed successfully, updating the pushing state of the corresponding target transaction record to be pushed. The server can also perform data calculation on the data contained in each obtained target transaction record based on a pre-stored data calculation strategy to obtain data calculation results meeting the target monitoring standard, and the data calculation results are used as target monitoring results and are pushed to a monitoring interface in the client end one by one according to TOPIC to be presented.
Please refer to table 6, which shows the target monitoring result when the screening dimension is "detail".
TABLE 6
Currency pair Position of target net Net amount of target Market price of noble metals Transaction time Transaction source
XAU/USD 10 -18691.5 1869.15 09:12:50 Precious metal spot transaction
XAG/USD -20 555.6 27.78 09:20:32 Account precious metal transactions
AUA/CNY -100 38785 388.36 10:15:06 Precious metal spot transaction
AUB/CNY 50 -19425 388.50 10:42:02 Precious metal spot transaction
au2106/CNY -5 1946550 390.28 10:50:26 Precious metal futures trading
For the condition that the screening dimension is 'summary', the server can inquire transaction records which are generated on the same day and are not re-evaluated and transferred, summarize and count target precious metals according to transaction source types aiming at each currency pair, then push summarized data serving as target monitoring results to the client according to TOPIC, and display the data through a monitoring interface.
Please refer to table 7, which shows the target monitoring result when the screening dimension is "summary".
TABLE 7
Figure BDA0003344301130000241
Figure BDA0003344301130000251
For another example, for each transaction record included in the transaction record set, a transaction classification and a transaction account triggering precious metal transaction are respectively recorded, and the target monitoring range includes a target transaction classification and a target transaction account. The server determines whether the transaction classification of the newly added transaction record is the same as the target transaction classification and whether the transaction account of the newly added transaction record is the same as the target transaction account, respectively. And if the transaction classification of the newly added transaction record is the same as the target transaction classification and the transaction account of the newly added transaction record is the same as the target transaction account, determining that the newly added transaction record meets the target monitoring range. And each target transaction record is obtained based on each newly-added transaction record meeting the target monitoring range in the first preset time interval when the first preset time interval passes.
And the server performs data calculation on the data contained in each obtained target transaction record based on a pre-stored data calculation strategy to obtain a data calculation result meeting the target monitoring standard. And the server generates a target monitoring result based on the obtained data calculation result and presents the obtained target monitoring result in the monitoring interface.
Please refer to table 8, which is a pre-stored form of pre-stored data calculation strategies, taking real-time monitoring as an example, each calculation strategy is for the same precious metal currency pair, and may also be for other data, which is not limited specifically, and the embodiment of the present application takes the same precious metal currency pair as an example.
TABLE 8
Figure BDA0003344301130000252
Figure BDA0003344301130000261
Taking the target monitoring standard including the target net position, the target net amount, the target average price and the target profit and loss for each precious metal currency pair as an example, the process of carrying out data calculation on the data contained in each obtained target transaction record based on the pre-stored data calculation strategy and obtaining the data calculation result meeting the target monitoring standard is introduced.
Aiming at the target transaction records of the same precious metal currency pair in each target transaction record, the server respectively counts the target precious metal total amount and the target currency total amount to respectively obtain the target net position and the target net amount corresponding to each precious metal currency pair. And the server obtains the target average price of each precious metal currency pair based on the ratio of the target currency total amount and the target precious metal total amount of each precious metal currency pair.
After acquiring the precious metal market prices corresponding to the various precious metal currency pairs, the server acquires the target profit and loss corresponding to the various precious metal currency pairs based on the target currency total amount corresponding to the various precious metal currency pairs and the sum of the product of the target precious metal total amount and the precious metal market prices. And the server takes the target net position, the target net amount, the target average price and the target profit and loss of each noble metal currency pair as data calculation results meeting the target monitoring standard.
Please refer to table 9, which is a form of the target monitoring result generated by calculating the result according to the data satisfying the target monitoring standard.
TABLE 9
Currency pair Position of target net Target average price Net amount of target Market price of noble metals Target profit and loss
XAU/USD 10 1869.15 -18691.5 1872.39 32.4
XAG/USD -20 27.78 555.6 27.66 2.4
AUA/CNY -100 387.95 38785 388.78 -83
AUB/CNY 100 388.36 -38836 389.26 90
USD/CNY 10000 6.45 -64500 6.44 -100
au2106/CNY -5 389.31 1946550 390.28 -4850
As an embodiment, in order to ensure that the server still displays the monitoring interface in the client when obtaining the target monitoring result and presenting the target monitoring result through the client, and avoid the problem of abnormal data display and the like caused by the fact that the client does not display the monitoring interface when the server presents the target monitoring result through the client, the server may update the interface state of the monitoring interface to the display state after obtaining the target monitoring range and the target monitoring standard in response to the editing operation triggered by the monitoring interface, and update the display time of the monitoring interface based on the current time. And the server continuously judges whether a display signal aiming at the monitoring interface is received within a preset time length taking the display time as the starting time. If the display time is taken as the starting time within the preset duration, the display signal aiming at the monitoring interface is received, the display time is updated based on the current time, otherwise, the interface state is updated to be the closing state, wherein the display signal is used for representing that the monitoring interface is displaying, for example, when the target object triggers any operation in the monitoring interface, the display signal can be obtained, and the like.
Therefore, the server can obtain the interface state of the monitoring interface before presenting the obtained target monitoring result in the monitoring interface, and present the obtained target monitoring result in the monitoring interface if the interface state represents that the monitoring interface is in the display state. And if the interface state represents that the monitoring interface is in a closed state, not presenting the target monitoring result.
For example, after the client obtains the target monitoring range and the target monitoring standard in response to the editing operation of the target object, the client pushes the TOPIC of the target monitoring range and the target monitoring standard to the server, the server stores the target monitoring range in the memory, and if the target monitoring range contains the transaction classification set or the transaction object set, the server can obtain each transaction classification in the transaction classification set or each transaction object in the transaction object set, and convert each transaction classification or each transaction object into a transaction classification list or a transaction object list. And the server can record whether the target monitoring range is valid or not and the synchronization time of the client while the target monitoring range is saved. If the monitoring interface in the client is closed, the client pushes the TOPIC of the monitoring interface and the target monitoring range failed mark to the server. Meanwhile, the client also has a heartbeat mechanism, heartbeat information of the monitoring interface is pushed to the server at intervals, the server updates the synchronization time of the client, and if the synchronization time of the client is not updated after exceeding 4 hours, the target monitoring range corresponding to the TOPIC is set to be invalid.
As an example, after obtaining the target monitoring range, the server may filter out the filtering conditions characterizing the same range. The server may obtain, according to the target monitoring range, each target transaction record including a target transaction record that has not been reevaluated and is generated on the current day and a current latest target reevaluation result, where the target reevaluation result is the target transaction record that has been reevaluated and has been reevaluated.
As an embodiment, the reevaluation transfer is realized by carrying out valuation measurement on the precious metal by reevaluation price, calculating the profit and loss amount after the reevaluation transfer, and storing data after the reevaluation transfer as historical data for analyzing and inquiring the profit and loss condition. The currency recorded in the transaction record can be updated by the reevaluated and transferred currency, and the updated transaction record is used as the basis for subsequent monitoring. The process of reassessing carry out is described below.
In the transaction record set, transaction time is recorded for each transaction record, and the transaction time is used for representing the generation moment of the corresponding transaction record. Then, every time a second preset time interval passes, obtaining each transaction record of the transaction time within the second preset time interval from each transaction record, and using each transaction record as each transaction record to be reevaluated. The server can continue to perform data calculation on the transaction records of the same precious metal currency pair in each transaction record to be reevaluated based on the data calculation strategy to obtain a target reevaluation result.
When the server responds to the reassessment monitoring operation triggered by the monitoring interface, the target reassessment result can be read, and the target reassessment result is presented in the monitoring interface. Please refer to fig. 6, which is a monitoring interface for presenting the target reevaluation result. In the monitoring interface, the target monitoring range can be determined through editing operation, so that a target reevaluation result meeting the target monitoring range can be presented in the monitoring interface. For example, the target monitoring range includes a range for a transaction category, a transaction object, a currency pair, or a transaction time, and the like.
As an embodiment, taking the second preset time interval as one day as an example, the server may query the transaction records generated on the same day and not yet being reevaluated, and the current latest target reevaluation result, as each transaction record to be reevaluated. The transaction record generated on the current day and not subjected to the revaluation can be a transaction record newly generated on the current day, and the current latest target revaluation result can be a target revaluation result obtained after the revaluation of the previous day.
The data calculation policy may be the same as or different from the data calculation policy introduced above for obtaining the target monitoring result, or the data calculation policy may include both the data calculation policy introduced above and the data calculation policy for reevaluation transfer, and when monitoring is performed, the data calculation policy introduced above is invoked, and when reevaluation transfer is performed, the data calculation policy introduced below is invoked, which is not limited specifically.
Please refer to table 10, which is a pre-stored form of data calculation strategies, each calculation strategy is for the same precious metal currency pair, and may also be for other data, which is not limited specifically, and the embodiment of the present application takes the same precious metal currency pair as an example.
Watch 10
Figure BDA0003344301130000301
Figure BDA0003344301130000311
As an embodiment, each time a target reestimation result is obtained, an identifier is added to the currently obtained target reestimation result, and the target reestimation result is characterized as a newly obtained target reestimation result. Meanwhile, the transaction record which is generated on the current day and is not reevaluated to be carried out is marked as the transaction record which is reevaluationd to be carried out, the reevaluation time of carrying out the running can be recorded, and the reevaluation time of carrying out the running can be used as the mark which is reevaluationd to be carried out, and the like.
As an embodiment, the monitoring interface may further display a precious metal capital cost calculation result, where the precious metal capital cost calculation result is used to characterize that, according to the capital occupation amount, interest-receiving calculation is performed at the end of each third time interval, for example, at the end of each day, according to the borrowing rate of the financial platform. The server can take the calculation result of the capital cost of the precious metal as the final net profit and loss measurement result of the corresponding transaction object, and the calculation result is used for evaluating the transaction capacity of the transaction object. The fund cost measurement result of the corresponding transaction object can be stored as historical data for analysis and query aiming at the fund occupation and profit and loss conditions.
The process of determining the capital cost calculation for the precious metal is described below.
The precious metal capital cost calculations may include capital occupancy measurements and capital cost/benefit calculations, among others. And the fund occupation amount measurement result comprises a common mode fund occupation amount measurement result and a guarantee fund mode fund occupation amount measurement result. The common mode fund occupation amount measurement result is suitable for the transaction of non-guaranteed funds, such as: the method comprises the following steps of precious metal spot transaction, personal real object gold transaction, account precious metal transaction, precious metal consignment purchase transaction and the like. The fund occupation amount measurement result in the deposit guarantee mode is suitable for the transaction of deposit, such as: noble metal futures trading and gold exchange postponed delivery trading.
For the ordinary-mode fund occupancy measurement result, the ordinary-mode fund occupancy measurement result may count the bought initial currency and the sold initial currency for the same initial precious metal currency pair according to the initial precious metal currency pair before the data splitting process, where the bought initial currency is a positive number and the sold initial currency is a negative number. The common-mode fund occupancy amount measurement result can also be obtained by counting the buying target currency and the selling target currency and the like for the same precious metal currency pair according to the reference precious metal currency pair after the data splitting processing.
For example, two transaction records are included for the same initial precious metal currency pair, the first transaction record is that the transaction source is an account precious metal transaction, the initial precious metal currency pair is AUB/CNY, the initial precious metal is-1000 grams, the initial currency is 371230 yuan, the target precious metal is-32.1507 ounces and the target currency is 52761.51 dollars after data splitting processing is performed on XAU/USD according to the reference precious metal currency pair.
The second transaction record is that the transaction source is the precious metal spot transaction, the initial precious metal currency pair is AUB/CNY, the initial precious metal is 200 grams, the initial currency is-74592 YuanRenminbi, and the transaction record is not split.
Then the normal mode funds occupancy measurement is the initial currency of the first transaction record minus the initial currency of the second transaction record, i.e., 371230 yuan-74592 yuan-296638 yuan.
For the guaranteed-fund mode fund occupancy measurement result, counting multiple precious metals and empty precious metals aiming at the same precious metal currency pair. The server can count the multi-head noble metal and the empty-head noble metal according to the initial noble metal before the data splitting processing, and can also count the multi-head noble metal and the empty-head noble metal and the like according to the target noble metal after the data splitting processing.
For example, two transaction records are included for the same precious metal currency pair, the first transaction record is that the transaction source is a precious metal futures transaction, the precious metal currency pair is au2106/CNY, the position holding direction is multi-head, the precious metal is 10 grams, the currency is-3890000 yuan RMB, and the unit price of the precious metal is 389 yuan/gram.
The second record is that the transaction source is the noble metal futures transaction, the noble metal currency pair is au2106/CNY, the position holding direction is empty, the noble metal is-6 g, the currency is 2328000 Yuanren Min Bin, and the noble metal unit price is 388 Yuan/g.
When the fund occupation amount measurement result in the deposit mode is calculated, the server can obtain that the real-time au2106/CNY settlement price is 390 yuan/g, and the proportion of the deposit is 10%. Then, the server may calculate the cumulative profit-and-loss amount as (settlement price-buy precious metal unit price) × buy precious metal + (settlement price-sell precious metal unit price) × sell precious metal, i.e., (390-.
The server may recalculate the current day's guaranteed cost as (buy precious metals + sell precious metals) × settlement price × guaranteed cost ratio, i.e., (10- (-6)) × 390 × 0.1 ═ 624.
Thus, the server can obtain the fund occupancy measurement result in the deposit mode as the sum of the accumulated profit amount and the daily deposit occupancy, i.e. 624+ (-2) 622.
For the capital cost/income calculation result, the server can obtain the overnight borrowing rate of the financial platform in real time when calculating the capital cost/income calculation result, and determine the capital cost/income calculation result according to the capital occupation amount measurement result and the overnight borrowing rate of the financial platform.
As an embodiment, the client may present the precious metal capital cost calculation result in the monitoring interface in response to a query operation for the monitoring interface, the client may send a query request to the server in response to the query operation for the monitoring interface, the server obtains the precious metal capital cost calculation result and sends the precious metal capital cost calculation result to the client, and the client presents the precious metal capital cost calculation result in the monitoring interface after receiving the precious metal capital cost calculation result.
The server can send the calculation result of the capital cost of the precious metal to the client after calculating the calculation result of the capital cost of the precious metal, and can present the calculation result of the capital cost of the precious metal on the monitoring interface when the monitoring interface is displayed on the client; the calculation result of the capital cost of the precious metal can also be presented on a monitoring interface when responding to the query operation of the client, and the like, and is not limited specifically.
As an example, please refer to FIG. 7, which is a monitoring interface showing the calculation result of capital cost of precious metal. In the monitoring interface, the target monitoring range can be determined through editing operation, so that the capital cost calculation result of the precious metal meeting the target monitoring range can be presented in the monitoring interface. For example, the target monitoring range includes a range for a transaction category, a transaction object, a currency pair, or a transaction time, and the like.
In the embodiment of the present application, the data splitting process may be to convert the precious metal transaction data in the form of, for example, renminbi into precious metal transaction data in the form of U.S. dollars, so that the transaction object can be leveled directly on the international market according to the precious metals contained in the precious metal transaction data. And the target noble metal exposure data and the target currency exposure data after the data splitting processing are brought into the category of noble metal transaction data management and are displayed in real time in a monitoring interface.
Further, the monitoring interface provides functions of inquiring, monitoring and managing the noble metal transaction data in real time, including real-time monitoring and incremental monitoring. And real-time monitoring and counting the opening of bought precious metals, the opening of bought money, the opening of sold precious metals and the sale of the sold money according to the money pairs in a real-time gathering manner, and summarizing the net opening and net sum of the precious metals according to the rolling difference, and calculating the unit price of the precious metals of each money pair according to the net opening and net sum. And the summarized and calculated data are screened according to the target monitoring range, then are pushed to the client in real time, and are finally displayed by the client.
The increment monitoring comprises increment detail monitoring and increment summarizing monitoring, wherein the increment detail monitoring is used for screening newly generated transaction data generated by noble metal transaction through selected service classification, transaction modes and the like, then pushing the transaction data to a client in real time in a stroke-by-stroke detail data mode, and finally displaying the transaction data by the client. And the increment summarizing monitor summarizes and counts the transaction data generated by the noble metal transaction occurring on the day according to the currency pair and the transaction type, and the transaction data is pushed to the client side in real time and finally displayed by the client side.
The noble metal re-estimation and settlement is automatically executed by batch processing at the end of every day without manual intervention, the estimation and measurement of the noble metal transaction data are realized by the re-estimated noble metal market price, the profit and loss amount after re-estimation and settlement is calculated, and the profit and loss data are saved as historical data for the analysis and inquiry of the daily profit and loss condition. The re-estimation of precious metal exposure requires the introduction of real-time precious metal market prices, including road penetration international market prices, real-time market prices at gold exchanges, market prices at futures exchanges at home and abroad, and the like.
The precious metal fund cost measurement is automatically executed by batch processing at the end of every day without manual intervention, the situation of calculating the fund occupation amount by aiming at the currency is realized, then interest collection and payment calculation is carried out at the end of every day according to the borrowing and lending rate, and the interest collection and payment calculation is included in the final net profit and loss measurement of a transaction object. And the capital cost measurement result is saved as historical data for analyzing and inquiring daily capital occupation and cost income conditions.
The embodiment of the application realizes a unified noble metal transaction data management function, improves the management efficiency through centralized management and ensures the integrity of noble metal transaction data management. Meanwhile, multidimensional management such as transaction object, trader object combination, transaction classification and exchange classification set is provided, and the noble metal transaction data management capability is improved. Through data splitting processing, the target noble metal exposure data and the target currency exposure data after the data splitting processing can be directly sent to an international market flat disc without manual conversion of a trading object.
Based on the same inventive concept, the embodiment of the present application provides a precious metal transaction data management device, which is equivalent to the server discussed above and can implement the corresponding function of the precious metal transaction data management method described above. Referring to fig. 8, the apparatus includes an obtaining module 801 and a processing module 802, wherein:
the acquisition module 801: the system comprises a data processing module, a data processing module and a data processing module, wherein the data processing module is used for acquiring to-be-processed precious metal transaction data and extracting an initial precious metal currency pair corresponding to the to-be-processed precious metal transaction data, and the initial precious metal currency pair is used for representing an initial metering unit of initial precious metal and an initial currency type of initial currency contained in the to-be-processed precious metal transaction data;
the processing module 802: the data splitting processing is carried out on the to-be-processed precious metal transaction data based on a pre-stored data splitting strategy if the initial precious metal currency pair is not matched with a preset reference precious metal currency pair, and target precious metal exposure data and target currency exposure data are obtained, wherein the target precious metal exposure data at least comprise target precious metals and target currencies, the target precious metals and the target currencies respectively represent the initial precious metals and the initial currencies according to reference metering units and reference currency types contained in the reference precious metal currency pair, and the target currency exposure data are used for representing the data conversion relationship between the initial currencies and the target currencies;
the processing module 802 is further configured to: and in the transaction record set, the obtained target noble metal exposure data and the target currency exposure data are stored as newly added transaction records.
In a possible embodiment, the processing module 802 is specifically configured to:
determining a first conversion factor between the initial measurement unit and the reference measurement unit, and a second conversion factor between the initial currency type and the reference currency type, based on the initial measurement unit and the initial currency type, and the reference measurement unit and the reference currency type;
respectively carrying out data conversion processing on the initial precious metal and the initial currency based on the first conversion coefficient and the second conversion coefficient to respectively obtain target precious metal and target currency;
updating the to-be-processed precious metal transaction data based on the reference precious metal currency pair, the target precious metal and the target currency to obtain target precious metal exposure data;
target currency exposure data is obtained based on the second conversion factor, the initial currency, and the target currency.
In one possible embodiment, the processing module 802 is further configured to:
after adding a new transaction record in the transaction record set based on the obtained target precious metal exposure data and the target currency exposure data, determining precious metal exposure cancellation data and currency exposure cancellation data based on the values with opposite signs of the target precious metals and the values with opposite signs of the target currency in response to a cancellation operation triggered on the target precious metal exposure data and the target currency exposure data, and adding a new transaction record in the transaction record set based on the obtained precious metal exposure cancellation data and the currency exposure cancellation data;
and responding to modification operation triggered by the target precious metal exposure data and the target currency exposure data, obtaining modified target precious metal exposure data and modified target currency exposure data, and adding a transaction record in the transaction record set based on the modified target precious metal exposure data and the modified target currency exposure data.
In one possible embodiment, the processing module 802 is further configured to:
after transaction records are newly added in a transaction record set based on the obtained target noble metal exposure data and the target currency exposure data, responding to an editing operation triggered aiming at a monitoring interface, and obtaining a target monitoring range and a target monitoring standard, wherein the target monitoring range is used for indicating a screening condition aiming at the transaction records, and the target monitoring standard is used for indicating a data calculation target aiming at the transaction records;
when transaction records are newly added in the transaction record set, whether the newly added transaction records meet a target monitoring range is determined, and each target transaction record meeting the target monitoring range in a first preset time interval is obtained when the first preset time interval passes;
based on a pre-stored data calculation strategy, performing data calculation on data contained in each obtained target transaction record to obtain a data calculation result meeting a target monitoring standard;
and calculating a result based on the obtained data, generating a target monitoring result, and presenting the obtained target monitoring result in a monitoring interface.
In a possible embodiment, transaction classification and transaction accounts triggering precious metal transactions are respectively recorded aiming at each transaction record contained in a transaction record set, and a target monitoring range comprises a target transaction classification and a target transaction account;
the processing module 802 is specifically configured to:
respectively determining whether the transaction classification of the newly added transaction record is the same as the target transaction classification, and whether the transaction account of the newly added transaction record is the same as the target transaction account;
if the transaction classification of the newly added transaction record is the same as the target transaction classification and the transaction account of the newly added transaction record is the same as the target transaction account, determining that the newly added transaction record meets the target monitoring range;
and each target transaction record is obtained based on each newly-added transaction record meeting the target monitoring range in the first preset time interval when the first preset time interval passes.
In one possible embodiment, the target monitoring criteria include a target net position, a target net amount, a target mean price, and a target profit and loss for each precious metal currency pair;
the processing module 802 is specifically configured to:
respectively counting the total amount of the target precious metals and the total amount of the target currency aiming at the target transaction records of the same precious metal currency pair in each target transaction record, and respectively obtaining the target net position and the target net amount corresponding to each precious metal currency pair;
obtaining respective corresponding target average prices of the various precious metal currencies based on the respective corresponding target currency total amounts of the various precious metal currencies and the target precious metal total amounts;
acquiring the market price of each noble metal corresponding to each noble metal currency;
obtaining target profit and loss corresponding to each noble metal currency pair based on the target currency total amount corresponding to each noble metal currency pair and the sum of the product of the target noble metal total amount and the noble metal market price;
and taking the target net position, the target net amount, the target average price and the target profit and loss of each noble metal currency pair as data calculation results meeting the target monitoring standard.
In a possible embodiment, for each transaction record, a transaction time is recorded, where the transaction time is used to characterize a generation time of the corresponding transaction record, and the processing module 802 is further configured to:
every time a second preset time interval passes, acquiring each transaction record to be reevaluated with the transaction time within the second preset time interval from each transaction record;
based on a data calculation strategy, performing data calculation on the transaction records of the same noble metal currency pair in each transaction record to be reevaluated to obtain a target reevaluation result;
and presenting a target reevaluation result in the monitoring interface in response to reevaluation monitoring operation triggered by the monitoring interface.
In a possible embodiment, an interface state and a display time are recorded for a monitoring interface, wherein the interface state is used for representing whether the monitoring interface is displayed, and the display time is used for representing the time when the monitoring state of the monitoring interface recorded last time is the display state;
the processing module 802 is further configured to:
after a target monitoring range and a target monitoring standard are obtained in response to editing operation triggered by a monitoring interface, updating the interface state of the monitoring interface to a display state, and updating the display time of the monitoring interface based on the current time;
and if the display signal aiming at the monitoring interface is received within a preset time length taking the display time as the starting time, updating the display time based on the current time, otherwise, updating the interface state to a closed state, wherein the display signal is used for representing that the monitoring interface is displaying.
In one possible embodiment, the processing module 802 is further configured to:
in a monitoring interface, acquiring the interface state of the monitoring interface before presenting the obtained target monitoring result;
and if the interface state represents that the monitoring interface is in a display state, presenting the obtained target monitoring result in the monitoring interface.
Based on the same inventive concept, the embodiment of the present application provides a computer device, and the computer device 900 is described below.
Referring to fig. 9, the precious metal transaction data management apparatus may be run on a computer device 900, and a current version and a historical version of a data storage program and application software corresponding to the data storage program may be installed on the computer device 900, where the computer device 900 includes a display unit 940, a processor 980 and a memory 920, where the display unit 940 includes a display panel 941 for displaying an interface interacted by a user, and the like.
In one possible embodiment, the Display panel 941 may be configured in the form of a Liquid Crystal Display (LCD) or an Organic Light-Emitting Diode (OLED) or the like.
The processor 980 is configured to read the computer program and then execute a method defined by the computer program, for example, the processor 980 reads a data storage program or a file, etc., so as to run the data storage program on the computer device 900 and display a corresponding interface on the display unit 940. The Processor 980 may include one or more general-purpose processors and may further include one or more DSPs (Digital Signal processors) for performing relevant operations to implement the solutions provided by the embodiments of the present application.
Memory 920 typically includes both internal and external memory, which may be Random Access Memory (RAM), Read Only Memory (ROM), and CACHE memory (CACHE). The external memory can be a hard disk, an optical disk, a USB disk, a floppy disk or a tape drive. The memory 920 is used for storing a computer program including an application program corresponding to each client and other data, which may include data generated after an operating system or the application program is executed, including system data (e.g., configuration parameters of the operating system) and user data. Program instructions stored in the memory 920 and executed by the processor 980 in the memory 920 in the embodiments of the present application implement any of the methods for noble metal transaction data management discussed in the previous figures.
The display unit 940 is used to receive input digital information, character information, or touch operation/non-touch gesture, and generate signal input related to user setting and function control of the computer apparatus 900, and the like. Specifically, in the embodiment of the present application, the display unit 940 may include a display panel 941. The display panel 941, for example, a touch screen, can collect touch operations by a user (for example, operations of the user on the display panel 941 or on the display panel 941 by using a finger, a stylus pen, or any other suitable object or attachment), and drive a corresponding connection device according to a preset program.
In one possible embodiment, the display panel 941 may include two portions of a touch detection device and a touch controller. The touch detection device detects the touch direction of a player, detects a signal brought by touch operation and transmits the signal to the touch controller; the touch controller receives touch information from the touch sensing device, converts the touch information into touch point coordinates, sends the touch point coordinates to the processor 980, and can receive and execute commands sent by the processor 980.
The display panel 941 may be implemented by a plurality of types, such as a resistive type, a capacitive type, an infrared ray, and a surface acoustic wave. In addition to the display unit 940, the computer device 900 may also include an input unit 930, which input unit 930 may include a graphical input device 931 and other input devices 932, wherein the other input devices may include, but are not limited to, one or more of a physical keyboard, function keys (such as volume control keys, switch keys, etc.), a trackball, a mouse, a joystick, and the like.
In addition to the above, the computer device 900 may also include a power supply 990 for powering the other modules, an audio circuit 960, a near field communication module 970, and an RF circuit 910. The computer device 900 may also include one or more sensors 950, such as acceleration sensors, light sensors, pressure sensors, and the like. The audio circuit 960 specifically includes a speaker 961 and a microphone 962, and the computer device 900 may collect the user's voice through the microphone 962, perform corresponding operations, and so on.
For one embodiment, the number of the processors 980 may be one or more, and the processors 980 and the memories 920 may be coupled or relatively independent.
As an example, the processor 980 in fig. 9 may be used to implement the functionality of the acquisition module 801 and the processing module 802 in fig. 8.
As an example, the processor 980 of fig. 9 may be configured to implement the corresponding functionality of the server discussed above.
Those of ordinary skill in the art will understand that: all or part of the steps for implementing the method embodiments may be implemented by hardware related to program instructions, and the program may be stored in a computer readable storage medium, and when executed, the program performs the steps including the method embodiments; and the aforementioned storage medium includes: a mobile storage device, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and other various media capable of storing program codes.
Alternatively, the integrated unit of the present invention may be stored in a computer-readable storage medium if it is implemented in the form of a software functional module and sold or used as a separate product. Based on such understanding, the technical solutions of the embodiments of the present invention may be essentially implemented or a part contributing to the prior art may be embodied in the form of a software product, which is stored in a storage medium and includes several instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the methods described in the embodiments of the present invention. And the aforementioned storage medium includes: a removable storage device, a ROM, a RAM, a magnetic or optical disk, or various other media that can store program code.
It will be apparent to those skilled in the art that various changes and modifications may be made in the present application without departing from the spirit and scope of the application. Thus, if such modifications and variations of the present application fall within the scope of the claims of the present application and their equivalents, the present application is intended to include such modifications and variations as well.

Claims (12)

1. A precious metal transaction data management method, comprising:
acquiring to-be-processed precious metal transaction data, and extracting an initial precious metal currency pair corresponding to the to-be-processed precious metal transaction data, wherein the initial precious metal currency pair is used for representing an initial metering unit of initial precious metal and an initial currency type of initial currency contained in the to-be-processed precious metal transaction data;
if the initial precious metal currency pair is not matched with a preset reference precious metal currency pair, performing data splitting processing on the to-be-processed precious metal transaction data based on a prestored data splitting strategy to obtain target precious metal exposure data and target currency exposure data, wherein the target precious metal exposure data at least comprise target precious metals and target currencies, the target precious metals and the target currencies respectively represent the initial precious metals and the initial currencies by reference metering units and reference currency types contained in the reference precious metal currency pair, and the target currency exposure data is used for representing data conversion relations between the initial currencies and the target currencies;
and in the transaction record set, the obtained target noble metal exposure data and the target currency exposure data are stored as newly added transaction records.
2. The method according to claim 1, wherein if the initial precious metal currency pair does not match a preset reference precious metal currency pair, performing data splitting processing on the to-be-processed precious metal transaction data based on a pre-stored data splitting strategy to obtain target precious metal exposure data and target currency exposure data, including:
determining a first conversion factor between the initial measurement unit and the reference measurement unit, and a second conversion factor between the initial currency type and the reference currency type, based on the initial measurement unit and the initial currency type, and the reference measurement unit and the reference currency type;
performing data conversion processing on the initial precious metal and the initial currency respectively based on the first conversion coefficient and the second conversion coefficient to obtain target precious metal and the target currency respectively;
updating the to-be-processed precious metal transaction data based on the reference precious metal currency pair, the target precious metal and the target currency to obtain target precious metal exposure data;
obtaining the target currency exposure data based on the second conversion factor, the initial currency, and the target currency.
3. The method of claim 1, further comprising, after adding a new transaction record in the set of transaction records based on the obtained target precious metal exposure data and target currency exposure data:
in response to a withdrawal operation triggered by the target precious metal exposure data and the target currency exposure data, determining precious metal exposure withdrawal data and currency exposure withdrawal data based on the values of the target precious metals with opposite signs and the values of the target currency with opposite signs, and adding a transaction record in the transaction record set based on the obtained precious metal exposure withdrawal data and the obtained currency exposure withdrawal data;
and responding to a modification operation triggered by the target precious metal exposure data and the target currency exposure data, obtaining modified target precious metal exposure data and modified target currency exposure data, and adding a transaction record in the transaction record set based on the modified target precious metal exposure data and the modified target currency exposure data.
4. The method according to any one of claims 1 to 3, further comprising, after adding a new transaction record in the transaction record set based on the obtained target precious metal exposure data and target currency exposure data:
responding to editing operation triggered by a monitoring interface, and acquiring a target monitoring range and a target monitoring standard, wherein the target monitoring range is used for indicating a screening condition for a transaction record, and the target monitoring standard is used for indicating a data calculation target for the transaction record;
determining whether the newly added transaction records meet the target monitoring range or not when the transaction records are newly added in the transaction record set, and acquiring each target transaction record meeting the target monitoring range in a first preset time interval when the first preset time interval passes;
based on a pre-stored data calculation strategy, performing data calculation on data contained in each obtained target transaction record to obtain a data calculation result meeting the target monitoring standard;
and calculating a result based on the obtained data, generating a target monitoring result, and presenting the obtained target monitoring result in the monitoring interface.
5. The method according to claim 4, wherein for each transaction record contained in the transaction record set, a transaction classification and a transaction account triggering precious metal transaction are respectively recorded, and the target monitoring range comprises a target transaction classification and a target transaction account;
determining whether the newly added transaction record meets the target monitoring range each time a new transaction record is added to the transaction record set, and obtaining each target transaction record meeting the target monitoring range within a first preset time interval each time the first preset time interval passes, including:
respectively determining whether the transaction classification of the newly added transaction record is the same as the target transaction classification, and whether the transaction account of the newly added transaction record is the same as the target transaction account;
if the transaction classification of the newly added transaction record is the same as the target transaction classification and the transaction account of the newly added transaction record is the same as the target transaction account, determining that the newly added transaction record meets the target monitoring range;
and each time a first preset time interval passes, acquiring each target transaction record based on each newly-added transaction record meeting the target monitoring range in the first preset time interval.
6. The method of claim 4, wherein the target monitoring criteria include a target net position, a target net amount, a target mean price, and a target profit and loss for each precious metal currency pair;
then, based on the pre-stored data calculation strategy, performing data calculation on the data included in each obtained target transaction record to obtain a data calculation result meeting the target monitoring standard, including:
respectively counting the total amount of the target precious metals and the total amount of the target currency aiming at the target transaction records of the same precious metal currency pair in each target transaction record, and respectively obtaining the target net position and the target net amount corresponding to each precious metal currency pair;
obtaining target average prices of the various precious metal currency pairs respectively based on the ratio of the target currency total amount and the target precious metal total amount of the various precious metal currency pairs respectively;
acquiring the market price of the precious metal corresponding to each precious metal currency pair;
obtaining target profit and loss corresponding to each precious metal currency pair based on the target currency total amount corresponding to each precious metal currency pair and the sum of the product of the target precious metal total amount and the precious metal market price;
and taking the target net position, the target net amount, the target average price and the target profit and loss of each noble metal currency pair as data calculation results meeting the target monitoring standard.
7. The method of claim 4, wherein for each transaction record, a transaction time is recorded, the transaction time being used to characterize a generation time of the corresponding transaction record, the method further comprising:
every time a second preset time interval passes, acquiring each transaction record to be reevaluated with the transaction time within the second preset time interval from each transaction record;
based on the data calculation strategy, performing data calculation on the transaction records of the same noble metal currency pair in each transaction record to be reevaluated to obtain a target reevaluation result;
and presenting the target reevaluation result in the monitoring interface in response to reevaluation monitoring operation triggered by the monitoring interface.
8. The method according to claim 4, characterized in that an interface state and a display time are recorded for the monitoring interface, the interface state is used for representing whether the monitoring interface is displayed, and the display time is used for representing the time when the last recorded monitoring state of the monitoring interface is a display state;
after the target monitoring range and the target monitoring standard are obtained in response to the editing operation triggered by the monitoring interface, the method further includes:
updating the interface state of the monitoring interface to a display state, and updating the display time of the monitoring interface based on the current time;
and if a display signal aiming at the monitoring interface is received within a preset time length taking the display time as an initial time, updating the display time based on the current time, otherwise, updating the interface state to a closed state, wherein the display signal is used for representing that the monitoring interface is displaying.
9. The method according to claim 8, wherein before presenting the obtained target monitoring result in the monitoring interface, the method further comprises:
acquiring the interface state of the monitoring interface;
and if the interface state represents that the monitoring interface is in a display state, presenting an obtained target monitoring result in the monitoring interface.
10. A precious metal transaction data management apparatus, comprising:
an acquisition module: the system comprises a data processing module, a data processing module and a data processing module, wherein the data processing module is used for acquiring to-be-processed precious metal transaction data and extracting an initial precious metal currency pair corresponding to the to-be-processed precious metal transaction data, and the initial precious metal currency pair is used for representing an initial metering unit of initial precious metal and an initial currency type of initial currency contained in the to-be-processed precious metal transaction data;
a processing module: if the initial precious metal currency pair is not matched with a preset reference precious metal currency pair, performing data splitting processing on the to-be-processed precious metal transaction data based on a prestored data splitting strategy to obtain target precious metal exposure data and target currency exposure data, wherein the target precious metal exposure data at least comprise target precious metals and target currencies, the target precious metals and the target currencies respectively represent the initial precious metals and the initial currencies in reference metering units and reference currency types contained in the reference precious metal currency pair, and the target currency exposure data is used for representing data conversion relations between the initial currencies and the target currencies;
the processing module is further configured to: and in the transaction record set, the obtained target noble metal exposure data and the target currency exposure data are stored as newly added transaction records.
11. A computer device, comprising:
a memory for storing program instructions;
a processor for calling the program instructions stored in the memory and executing the method according to any one of claims 1 to 9 according to the obtained program instructions.
12. A computer-readable storage medium having stored thereon computer-executable instructions for causing a computer to perform the method of any one of claims 1 to 9.
CN202111317606.4A 2021-11-09 2021-11-09 Precious metal transaction data management method, precious metal transaction data management device, computer equipment and storage medium Active CN113837883B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202111317606.4A CN113837883B (en) 2021-11-09 2021-11-09 Precious metal transaction data management method, precious metal transaction data management device, computer equipment and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202111317606.4A CN113837883B (en) 2021-11-09 2021-11-09 Precious metal transaction data management method, precious metal transaction data management device, computer equipment and storage medium

Publications (2)

Publication Number Publication Date
CN113837883A true CN113837883A (en) 2021-12-24
CN113837883B CN113837883B (en) 2023-12-22

Family

ID=78971286

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202111317606.4A Active CN113837883B (en) 2021-11-09 2021-11-09 Precious metal transaction data management method, precious metal transaction data management device, computer equipment and storage medium

Country Status (1)

Country Link
CN (1) CN113837883B (en)

Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2002075619A1 (en) * 2001-03-21 2002-09-26 Gold Corporation Method and system for electronic precious metals transactions
US20120066097A1 (en) * 2006-08-21 2012-03-15 Amos Carl R Uncle Gem V, Universal Automatic Instant Money, Data and Precious Metal & Stone Transfer Machine
US20160148199A1 (en) * 2013-08-12 2016-05-26 Toomas Vitsut Method for Calculating and Converting the Value of Currency During Financial Transactions Using an Account Backed with Precious Metals
CN108269353A (en) * 2018-01-17 2018-07-10 北京网信云服信息科技有限公司 Self-service machine and the self-service system of exchanging of exchanging
CN112540959A (en) * 2020-12-14 2021-03-23 建信金融科技有限责任公司 Data processing method and device
CN113052702A (en) * 2021-04-19 2021-06-29 中国建设银行股份有限公司 Transaction cash flow computing system and working method thereof
CN113298604A (en) * 2020-12-04 2021-08-24 阿里巴巴集团控股有限公司 Commodity object settlement processing method and device and electronic equipment

Patent Citations (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2002075619A1 (en) * 2001-03-21 2002-09-26 Gold Corporation Method and system for electronic precious metals transactions
US20120066097A1 (en) * 2006-08-21 2012-03-15 Amos Carl R Uncle Gem V, Universal Automatic Instant Money, Data and Precious Metal & Stone Transfer Machine
US20160148199A1 (en) * 2013-08-12 2016-05-26 Toomas Vitsut Method for Calculating and Converting the Value of Currency During Financial Transactions Using an Account Backed with Precious Metals
JP2016532201A (en) * 2013-08-12 2016-10-13 トーマス ヴィートシュト How to calculate and convert currency value during financial transactions using precious metal collateral accounts
CN108269353A (en) * 2018-01-17 2018-07-10 北京网信云服信息科技有限公司 Self-service machine and the self-service system of exchanging of exchanging
CN113298604A (en) * 2020-12-04 2021-08-24 阿里巴巴集团控股有限公司 Commodity object settlement processing method and device and electronic equipment
CN112540959A (en) * 2020-12-14 2021-03-23 建信金融科技有限责任公司 Data processing method and device
CN113052702A (en) * 2021-04-19 2021-06-29 中国建设银行股份有限公司 Transaction cash flow computing system and working method thereof

Also Published As

Publication number Publication date
CN113837883B (en) 2023-12-22

Similar Documents

Publication Publication Date Title
US7853493B2 (en) Personal finance integration system and method
WO2018121113A1 (en) Abnormal account transfer detection method and device
WO2020143341A1 (en) Blockchain architecture-based warehouse receipt pledge financing assessment method and device
JP4274286B2 (en) Information processing apparatus, asset management method, and program
GB2418333A (en) Tabbed user interface for stock trading
EP1989674A2 (en) A system and method for placing a trade order for a tradable instrument on an electronic exchange
US20140344143A1 (en) System and method for managing related accounts
CN110659787B (en) Bank data analysis method and system
TWM540337U (en) Mobile financial management secretary system
CN110135984A (en) Exchange management method, device, computer equipment and storage medium
CN109615389A (en) Electronic-payment transaction risk control method, device, server and storage medium
US8099354B2 (en) Financial management system and related methods
CN110084699A (en) Polymerization, device, transaction List Table system and the storage medium of transaction record
US20140279452A1 (en) Vendor propensity analysis component for an electronic invoice payment system
CN110046985A (en) Data processing system, method and terminal device
JP2003114977A (en) Method and system for calculating customer's lifelong value
CN113837883B (en) Precious metal transaction data management method, precious metal transaction data management device, computer equipment and storage medium
TW202044150A (en) Item management method, blockchain analysis method and computer system using the same
JP2017084229A (en) Investment simulation device and method
JP6871469B1 (en) Information processing device that estimates transactions with other companies
CN109087201A (en) Data processing method, server and the storage medium of virtual resource
JPH10214299A (en) Calculating method for deposit interest or the like
CN110766556A (en) Profit notification method, device, equipment and computer readable storage medium
CN111192038B (en) Responsibility insurance information processing method and device based on electronic bill and terminal equipment
TWM646785U (en) Multifunctional fund operation display system

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant