CN113159954A - International currency exchange rate risk management method based on time series - Google Patents
International currency exchange rate risk management method based on time series Download PDFInfo
- Publication number
- CN113159954A CN113159954A CN202110505727.5A CN202110505727A CN113159954A CN 113159954 A CN113159954 A CN 113159954A CN 202110505727 A CN202110505727 A CN 202110505727A CN 113159954 A CN113159954 A CN 113159954A
- Authority
- CN
- China
- Prior art keywords
- transaction
- exchange rate
- time
- fluctuation
- rate
- 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.)
- Pending
Links
- 238000007726 management method Methods 0.000 title claims abstract description 28
- 238000000034 method Methods 0.000 claims abstract description 7
- 238000000611 regression analysis Methods 0.000 claims abstract description 4
- 238000012954 risk control Methods 0.000 claims description 7
- 238000004364 calculation method Methods 0.000 claims description 3
- 238000012216 screening Methods 0.000 claims description 3
- 230000009286 beneficial effect Effects 0.000 description 2
- 238000006467 substitution reaction Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION 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/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/04—Trading; Exchange, e.g. stocks, commodities, derivatives or currency exchange
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION 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
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0635—Risk analysis of enterprise or organisation activities
Landscapes
- Business, Economics & Management (AREA)
- Engineering & Computer Science (AREA)
- Human Resources & Organizations (AREA)
- Strategic Management (AREA)
- Economics (AREA)
- Entrepreneurship & Innovation (AREA)
- General Business, Economics & Management (AREA)
- Finance (AREA)
- Development Economics (AREA)
- Marketing (AREA)
- Accounting & Taxation (AREA)
- Theoretical Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- Educational Administration (AREA)
- Tourism & Hospitality (AREA)
- Quality & Reliability (AREA)
- Operations Research (AREA)
- Game Theory and Decision Science (AREA)
- Technology Law (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The invention discloses a time-series-based international currency exchange rate risk management method, which specifically comprises the following steps: acquiring a transaction record with large historical exchange rate fluctuation and a transaction record with small historical exchange rate fluctuation; extracting characteristic factors based on the transaction records with large exchange rate fluctuation and the transaction records with small exchange rate fluctuation; carrying out regression analysis on the characteristic variables and searching the internal relation of each variable; establishing an exchange rate fluctuation risk management model by using the relation among the characteristic variables; and controlling transaction risk according to the exchange rate fluctuation risk management model. According to the method, the model can be used for judging whether the current-day exchange rate fluctuation is in the safety interval or not by acquiring the current-day offshore real-time exchange rate and the current-day onshore real-time exchange rate, and the problem that manual adjustment of the transaction basic exchange rate is inconvenient in value in the prior art is solved.
Description
Technical Field
The invention relates to the technical field of information, in particular to a time-series-based international currency exchange rate risk management method.
Background
In the foreign card receipt business mode, the settlement exchange rate of the transaction charged by foreign currency is different from the exchange rate used when the transaction occurs, so that each transaction is exposed to the risk caused by the change of the exchange rate. The transaction risk mainly comes from two factors, currency and time, different currency and time, and different direction and amplitude of exchange rate change. The traditional transaction risk control mode is to set currency floating exchange rate in a management system and manually carry out parametric management, and the traditional transaction risk control mode has the problems of untimely adjustment and inaccurate adjustment amplitude.
Disclosure of Invention
The invention aims to solve the technical problem that the international currency exchange rate risk management method based on the time sequence can judge whether the fluctuation of the exchange rate of the day is in a safety interval by using a model by acquiring the real-time exchange rate of off shore and on shore on the day, thereby solving the problem of inconvenient addition of the exchange rate of the transaction foundation manually in the prior art.
The invention is realized by the following technical scheme: a time-series-based international currency exchange rate risk management method specifically comprises the following steps:
s1, acquiring the transaction records with large historical exchange rate fluctuation and the transaction records with small historical exchange rate fluctuation;
s2, extracting characteristic factors based on the transaction record with large exchange rate fluctuation and the transaction record with small exchange rate fluctuation;
s3, carrying out regression analysis on the characteristic variables and searching the internal relation of each variable;
s4, establishing an exchange rate fluctuation risk management model by using the relation among the characteristic variables;
and S5, performing transaction risk control according to the exchange rate fluctuation risk management model.
As a preferred technical solution, in S1, the historical transaction record includes information: the system comprises an issuer, a transaction currency, a transaction basic exchange rate addition value, transaction time, transaction types, an onshore real-time exchange rate and an offshore real-time exchange rate.
Preferably, in S1, the definition range with large fluctuation is that the absolute value of the fluctuation of the exchange rate is greater than or equal to 0.6%, and the definition range with small fluctuation is that the absolute value of the fluctuation of the exchange rate is less than 0.6%.
As a preferred technical solution, in S2, the extracted feature factors include:
(1-1) respectively extracting fields in the transaction records with large historical exchange rate fluctuation and the transaction records with small historical exchange rate fluctuation;
(1-2) screening out a characteristic variable which can be used as a characteristic factor from fields common to both; setting one or more values in the characteristic variables as characteristic factors;
(1-3) the characteristic variables include: the system comprises an issuer, a transaction currency, a transaction basic exchange rate addition value, transaction time, an onshore exchange rate in the transaction time and an offshore exchange rate in the transaction time.
As a preferred technical solution, in S3, the step of analyzing includes:
(2-1) calculating the correlation between the transaction exchange rate and the daily transaction basic exchange rate, the bank exchange rate in the transaction time and the bank exchange rate in the transaction time, and calculating a correlation coefficient;
(2-2) calculating the correlation between the added value of the transaction exchange rate and the transaction basic exchange rate of the day before the transaction date, the bank exchange rate in the transaction time and the bank exchange rate in the transaction time, and calculating a correlation coefficient;
(2-3) calculating the correlation between the added value of the transaction exchange rate and the one-day transaction basic exchange rate after the transaction date, the shore exchange rate in the transaction time and the shore exchange rate in the transaction time, and calculating a correlation coefficient;
(2-4) comparing the calculation results of the three conditions, and judging the condition with the strongest error correlation through statistics such as R-squared, residual sum of squares, T value and P value and the like;
and (2-5) classifying the data according to different card issuers and different transaction currencies, and repeating the steps to establish the correlation between the transaction exchange rates of the different transaction currencies of the different card issuers and other characteristic variables.
As a preferred technical scheme, in S4, an exchange rate fluctuation risk model is established according to the correlation of characteristic variables, and after the date, the characteristic variable 1 and the characteristic variable 2 are determined, the model can output an expected exchange rate, and when the transaction basic exchange rate of a transaction is lower than the expected exchange rate/the transaction basic exchange rate added value, the transaction will face a greater exchange rate fluctuation risk;
the model formula is as follows: the expected rate is the correlation coefficient 1+ the characteristic variable 1+ the correlation coefficient 2+ C, where C is a constant.
As a preferred technical solution, in S5, the risk control process is as follows:
(3-1) after a transaction is generated, judging an exchange rate fluctuation risk management model applicable to the transaction according to a transaction card issuing mechanism and a transaction currency;
(3-2) judging whether the basic exchange rate to be used by the transaction is in a safety interval given by the model;
(3-3) if the system is in the safety interval, the system completes the transaction by using the basic exchange rate;
and (3-4) if the transaction rate is not in the safety interval, the system adjusts the transaction basic rate addition value for the transaction, so that the final transaction rate is in the safety interval given by the model, and the transaction is completed.
The invention has the beneficial effects that: according to the method, the model can be used for judging whether the current-day exchange rate fluctuation is in the safety interval or not by acquiring the current-day offshore real-time exchange rate and the current-day onshore real-time exchange rate, and the problem that manual adjustment of the transaction basic exchange rate is inconvenient in value in the prior art is solved.
Detailed Description
All of the features disclosed in this specification, or all of the steps in any method or process so disclosed, may be combined in any combination, except combinations of features and/or steps that are mutually exclusive.
The invention relates to a time-series-based international currency exchange rate risk management method, which specifically comprises the following steps: acquiring a transaction record with large historical exchange rate fluctuation and a transaction record with small historical exchange rate fluctuation; extracting characteristic factors based on the transaction records with large exchange rate fluctuation and the transaction records with small exchange rate fluctuation; carrying out regression analysis on the characteristic variables and searching the internal relation of each variable; establishing an exchange rate fluctuation risk management model by using the relation among the characteristic variables; and controlling transaction risk according to the exchange rate fluctuation risk management model.
The historical transaction record includes information such as: the system comprises an issuer, a transaction currency, a transaction basic exchange rate addition value, transaction time, transaction types, an onshore real-time exchange rate and an offshore real-time exchange rate.
The definition range with larger fluctuation is that the absolute value of the fluctuation of the exchange rate is more than or equal to 0.6 percent, and the definition range with smaller fluctuation is that the absolute value of the fluctuation of the exchange rate is less than 0.6 percent.
The extracted feature factors include: respectively extracting fields in the transaction records with large historical exchange rate fluctuation and the transaction records with small historical exchange rate fluctuation; screening out characteristic variables which can be used as characteristic factors from fields shared by the two; setting one or more values in the characteristic variables as characteristic factors; the characteristic variables include: the system comprises an issuer, a transaction currency, a transaction basic exchange rate addition value, transaction time, an onshore exchange rate in the transaction time and an offshore exchange rate in the transaction time.
The step of analyzing comprises: calculating the correlation between the transaction exchange rate and the daily transaction basic exchange rate addition value of the transaction date, the bank exchange rate in the transaction time and the bank exchange rate in the transaction time, and calculating a correlation coefficient; calculating the correlation between the added value of the transaction exchange rate and the transaction basic exchange rate of the day before the transaction date, the bank exchange rate in the transaction time and the bank exchange rate in the transaction time, and calculating a correlation coefficient; calculating the correlation between the transaction exchange rate and the sum of the one-day transaction basic exchange rate after the transaction date, the shore exchange rate in the transaction time and the shore exchange rate in the transaction time, and calculating a correlation coefficient; comparing the calculation results of the three conditions, and judging the condition with the strongest minimum error correlation through statistics such as R-squared, residual sum of squares, T value and P value and the like; and (4) classifying the data according to different card issuing institutions and different transaction currencies, and repeating the steps to establish the correlation between the transaction exchange rates of the different transaction currencies of the different card issuing institutions and other characteristic variables.
Establishing an exchange rate fluctuation risk model according to the correlation of the characteristic variables, wherein after the date, the characteristic variable 1 and the characteristic variable 2 are determined, the model can output an expected exchange rate, and when the transaction basic exchange rate of a transaction is lower than the sum of the expected exchange rate and the transaction basic exchange rate, the transaction is subjected to a larger exchange rate fluctuation risk; the model formula is as follows: the expected rate is the correlation coefficient 1+ the characteristic variable 1+ the correlation coefficient 2+ C, where C is a constant.
The risk control process is as follows: after a transaction is generated, judging an exchange rate fluctuation risk management model applicable to the transaction according to a transaction card issuing mechanism and a transaction currency; judging whether the basic exchange rate to be used by the transaction is in a safety interval given by the model or not; if the transaction is in the safe interval, the system uses the basic exchange rate to complete the transaction; if the transaction rate is not in the safety interval, the system adjusts the transaction basic exchange rate for the transaction and adds the value to the transaction basic exchange rate, so that the final transaction exchange rate is in the safety interval given by the model, and the transaction is completed.
The specific embodiment of the invention is as follows:
(1) after a transaction is generated, judging an exchange rate fluctuation risk management model applicable to the transaction according to a transaction card issuing mechanism and a transaction currency;
(2) judging whether the basic exchange rate to be used by the transaction is in a safety interval given by the model or not;
(3) if the transaction is in the safe interval, the system uses the basic exchange rate to complete the transaction;
(4) if the transaction rate is not in the safety interval, the system adjusts the transaction basic exchange rate to the transaction and adds the value, so that the final transaction exchange rate is in the safety interval given by the model, and the transaction is finished.
The invention has the beneficial effects that: according to the invention, by acquiring the current offshore real-time exchange rate and the current case real-time exchange rate, whether the current day exchange rate fluctuation is in a safe interval can be judged by using the model, and the problem that the value added by manually adjusting the transaction basic exchange rate is inconvenient in the prior art is solved.
The above description is only an embodiment of the present invention, but the scope of the present invention is not limited thereto, and any changes or substitutions that are not thought of through the inventive work should be included in the scope of the present invention. Therefore, the protection scope of the present invention shall be subject to the protection scope defined by the claims.
Claims (7)
1. A time-series-based international currency exchange rate risk management method is characterized by specifically comprising the following steps:
s1, acquiring the transaction records with large historical exchange rate fluctuation and the transaction records with small historical exchange rate fluctuation;
s2, extracting characteristic factors based on the transaction record with large exchange rate fluctuation and the transaction record with small exchange rate fluctuation;
s3, carrying out regression analysis on the characteristic variables and searching the internal relation of each variable;
s4, establishing an exchange rate fluctuation risk management model by using the relation among the characteristic variables;
and S5, performing transaction risk control according to the exchange rate fluctuation risk management model.
2. The time-series based international currency exchange rate risk management method of claim 1, wherein: in S1, the historical transaction record includes information of: the system comprises an issuer, a transaction currency, a transaction basic exchange rate addition value, transaction time, transaction types, an onshore real-time exchange rate and an offshore real-time exchange rate.
3. The time-series based international currency exchange rate risk management method of claim 1, wherein: in S1, the definition range in which the fluctuation is large is that the absolute value of the fluctuation of the exchange rate is 0.6% or more, and the definition range in which the fluctuation is small is that the absolute value of the fluctuation of the exchange rate is less than 0.6%.
4. The time-series based international currency exchange rate risk management method of claim 1, wherein: in S2, the extracted feature factors include:
(1-1) respectively extracting fields in the transaction records with large historical exchange rate fluctuation and the transaction records with small historical exchange rate fluctuation;
(1-2) screening out a characteristic variable which can be used as a characteristic factor from fields common to both; setting one or more values in the characteristic variables as characteristic factors;
(1-3) the characteristic variables include: the system comprises an issuer, a transaction currency, a transaction basic exchange rate addition value, transaction time, an onshore exchange rate in the transaction time and an offshore exchange rate in the transaction time.
5. The time-series based international currency exchange rate risk management method of claim 1, wherein: in S3, the step of analyzing includes:
(2-1) calculating the correlation between the transaction exchange rate and the daily transaction basic exchange rate, the bank exchange rate in the transaction time and the bank exchange rate in the transaction time, and calculating a correlation coefficient;
(2-2) calculating the correlation between the added value of the transaction exchange rate and the transaction basic exchange rate of the day before the transaction date, the bank exchange rate in the transaction time and the bank exchange rate in the transaction time, and calculating a correlation coefficient;
(2-3) calculating the correlation between the added value of the transaction exchange rate and the one-day transaction basic exchange rate after the transaction date, the shore exchange rate in the transaction time and the shore exchange rate in the transaction time, and calculating a correlation coefficient;
(2-4) comparing the calculation results of the three conditions, and judging the condition with the strongest error correlation through statistics such as R-squared, residual sum of squares, T value and P value and the like;
and (2-5) classifying the data according to different card issuers and different transaction currencies, and repeating the steps to establish the correlation between the transaction exchange rates of the different transaction currencies of the different card issuers and other characteristic variables.
6. The time-series based international currency exchange rate risk management method of claim 1, wherein: in S4, establishing a rate fluctuation risk model according to the correlation of the characteristic variables, wherein after the date, the characteristic variable 1 and the characteristic variable 2 are determined, the model can output an expected rate, and when the transaction basic rate of a transaction is lower than the expected rate/the transaction basic rate added value, the transaction is subjected to a larger rate fluctuation risk;
the model formula is as follows: the expected rate is the correlation coefficient 1+ the characteristic variable 1+ the correlation coefficient 2+ C, where C is a constant.
7. The time-series based international currency exchange rate risk management method of claim 1, wherein: in S5, the risk control process is as follows:
(3-1) after a transaction is generated, judging an exchange rate fluctuation risk management model applicable to the transaction according to a transaction card issuing mechanism and a transaction currency;
(3-2) judging whether the basic exchange rate to be used by the transaction is in a safety interval given by the model;
(3-3) if the system is in the safety interval, the system completes the transaction by using the basic exchange rate;
and (3-4) if the transaction rate is not in the safety interval, the system adjusts the transaction basic rate addition value for the transaction, so that the final transaction rate is in the safety interval given by the model, and the transaction is completed.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202110505727.5A CN113159954A (en) | 2021-05-10 | 2021-05-10 | International currency exchange rate risk management method based on time series |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202110505727.5A CN113159954A (en) | 2021-05-10 | 2021-05-10 | International currency exchange rate risk management method based on time series |
Publications (1)
Publication Number | Publication Date |
---|---|
CN113159954A true CN113159954A (en) | 2021-07-23 |
Family
ID=76874164
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202110505727.5A Pending CN113159954A (en) | 2021-05-10 | 2021-05-10 | International currency exchange rate risk management method based on time series |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN113159954A (en) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN114266572A (en) * | 2021-12-23 | 2022-04-01 | 百果园技术(新加坡)有限公司 | Collection method, collection device, collection equipment and collection equipment of exchange rate data |
-
2021
- 2021-05-10 CN CN202110505727.5A patent/CN113159954A/en active Pending
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN114266572A (en) * | 2021-12-23 | 2022-04-01 | 百果园技术(新加坡)有限公司 | Collection method, collection device, collection equipment and collection equipment of exchange rate data |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
TW201941120A (en) | Transaction volume prediction method and device | |
Ehikioya et al. | Commercial bank credit accessibility and sectoral output performance in a deregulated financial market economy: Empirical evidence from Nigeria | |
CN106384288A (en) | Decision system and method based on multiple-factor quantization time selection model | |
CN113159954A (en) | International currency exchange rate risk management method based on time series | |
Detken et al. | Determinants of the effective real exchange rate of the synthetic euro: alternative methodological approaches | |
Fatima et al. | The relative effectiveness of monetary and fiscal policies: An econometric study | |
Edo | Capital market development in an emerging economy and the challenge of fostering foreign participation | |
CN114240647A (en) | ETF quantitative transaction method and system based on ESG index | |
Brzeszczynski et al. | Are there benefits from trading strategy based on the returns spillovers to the emerging Stock markets?: evidence from Poland | |
Asab et al. | The Credibility of a Soft Pegged Exchange Rate in Emerging Market Economies: Evidence from a Panel Data Study. | |
Chen et al. | The impact of us monetary policy and other external shocks on the hong kong economy: A factor-augmented var approach | |
Bratsiotis et al. | Unit total costs: An alternative marginal cost proxy for inflation dynamics | |
CN112613687A (en) | Debt chain recording system based on block chain technology | |
Canakci | Financial liberalization in the Middle East and North Africa: a case study of experiences in Egypt, Jordan and Tunisia | |
Sharma | The study of co-integration and direction of causality among International trade, GDP and foreign exchange rate in India | |
Simpson et al. | Commodity exporting countries and exchange rates: Australian evidence | |
Glass et al. | Efficiency in Irish banking: theory and evidence | |
Bati et al. | Determinants of Inflation in Ethiopia: An Autoregressive Distributed Lag Approach | |
Zhang et al. | Optimal Transaction Model Based on Venture Capital | |
Angelini | Value at Risk of a Lehman Bond | |
Sarpphaitoon | The Nexus of the Nikkei 225, Gold, and Crude Oil. Do They Have a Co-movement in the Long Run? New Evidence for Cointegration from the Autoregressive Distributed Lag Bounds Test | |
Puk | The impact of the COVID-19 pandemic on the assets and reserves of the banking sector | |
Arouri et al. | Synchronization and nonlinear interdependence of short-term interest rates | |
Ong | Net foreign assets dynamics: the persistence and sources of shocks to net foreign assets in 12 EU countries | |
Yu et al. | A dynamic stochastic programming model for bond portfolio management |
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 | ||
RJ01 | Rejection of invention patent application after publication | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20210723 |