TW202347230A - Method for estimating portfolio by quasi-efficient allocation and non-transitory computer-readable recording medium performing steps of setting a restriction, setting a portfolio, generating an expected payoff data set, and executing quasi-efficient allocation with an executable code - Google Patents

Method for estimating portfolio by quasi-efficient allocation and non-transitory computer-readable recording medium performing steps of setting a restriction, setting a portfolio, generating an expected payoff data set, and executing quasi-efficient allocation with an executable code Download PDF

Info

Publication number
TW202347230A
TW202347230A TW111120011A TW111120011A TW202347230A TW 202347230 A TW202347230 A TW 202347230A TW 111120011 A TW111120011 A TW 111120011A TW 111120011 A TW111120011 A TW 111120011A TW 202347230 A TW202347230 A TW 202347230A
Authority
TW
Taiwan
Prior art keywords
investment
portfolio
estimated
amount
annualized
Prior art date
Application number
TW111120011A
Other languages
Chinese (zh)
Other versions
TWI799281B (en
Inventor
黃適和
石德隆
Original Assignee
商智資訊股份有限公司
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 商智資訊股份有限公司 filed Critical 商智資訊股份有限公司
Priority to TW111120011A priority Critical patent/TWI799281B/en
Application granted granted Critical
Publication of TWI799281B publication Critical patent/TWI799281B/en
Publication of TW202347230A publication Critical patent/TW202347230A/en

Links

Images

Abstract

This invention provides a method of estimating a portfolio by quasi-efficient allocation. An electronic apparatus uses an executable code to perform steps of setting a restriction, setting a portfolio, generating an expected payoff data set, and performing quasi-efficient allocation. A plurality of portfolios are randomly generated by an investment amount of an asset as a set in a case where a restriction condition is met, and an investment portfolio whose estimated annualized Sharpe value in the set meets an estimation condition and which is evaluated as the quasi-efficient allocation is used as a reference basis for selecting the investment portfolios. This invention further provides a non-transitory computer-readable recording medium capable of being read to perform the above method.

Description

類效率配置估測投資組合的方法及非暫態電腦可讀取記錄媒體Method for quasi-efficiency allocation estimation of investment portfolio and non-transitory computer-readable recording medium

本發明係關於一種投資組合的估測方法,尤指一種類效率配置估測投資組合的方法,及能夠執行該方法的非暫態電腦可讀取記錄媒體。The present invention relates to a method for estimating an investment portfolio, in particular to a method for estimating an investment portfolio with efficiency allocation, and a non-transitory computer-readable recording medium capable of executing the method.

習知投資組合的效率配置,在於一投資組合包含多個資產(例如股票、債券…),假定這多個資產的投資比重的總和為1(且不以做空為操作),透過均異最適化(Mean-Variance Optimization)在多個投資組合中找出相同的預期報酬率且風險最小的投資組合,找出的每一個投資組合都有以下兩個特性:1.預期報酬率固定的情況下,使風險(標準差)降到最低。2.在風險(標準差)固定下,能使預期報酬率達到最高。The efficient allocation of a conventional investment portfolio is that an investment portfolio contains multiple assets (such as stocks, bonds...), assuming that the sum of the investment proportions of these multiple assets is 1 (and short selling is not used as an operation), through uniform optimization (Mean-Variance Optimization) Find the investment portfolio with the same expected return rate and the smallest risk among multiple investment portfolios. Each portfolio found has the following two characteristics: 1. When the expected return rate is fixed, Minimize risk (standard deviation). 2. Under the fixed risk (standard deviation), the expected rate of return can be maximized.

然而,所述均異最適化的效率配置,其所獲得各資產的比重可以不是整數(即帶有小數點的奇零數),實務上導致所估測的投資組合有投資金額不符合交易時的遞增金額的交易限制,因而無法將效率配置的投資組合直接投入交易市場中進行申購。However, the proportion of each asset obtained by the uniformly optimized efficient allocation may not be an integer (that is, an odd zero number with a decimal point), which in practice results in the estimated investment amount of the investment portfolio being inconsistent with the transaction time. Due to the transaction restrictions on the incremental amount, it is impossible to directly put the efficiently configured investment portfolio into the trading market for subscription.

此外,由於所述均異最適化的演算過程複雜,故其系統的軟硬體也要符合高規格才能順暢執行。In addition, due to the complexity of the uniform optimization calculation process, the system's software and hardware must also meet high standards in order to execute smoothly.

因此,如何解決上述習知效率配置的問題,即為本發明的重點所在。Therefore, how to solve the above-mentioned problems of conventional efficiency configuration is the focus of the present invention.

為達上述目的,發明人遂竭其心智悉心研究,進而研發出一種類效率配置估測投資組合的方法,及非暫態電腦可讀取記錄媒體,所估測的投資金額能夠符合交易時的遞增金額,使估測後的投資組合能夠直接投入連結的交易市場以進行申購。In order to achieve the above purpose, the inventor devoted his mind to careful research and developed a method of estimating investment portfolios with a kind of efficient allocation and a non-transitory computer-readable recording medium. The estimated investment amount can meet the transaction conditions. The incremental amount allows the estimated investment portfolio to be directly put into the linked trading market for subscription.

本發明提供一種類效率配置估測投資組合的方法,其係由一電子裝置以多個可執行碼所執行,所述方法包括限制條件設定、投資組合設定、產生預期報酬資料、集合以及類效率配置之步驟。首先挑選欲投資的多個資產,並對各該資產設定一符合金額遞增單位的限制條件;再以若干該資產設定一投資組合,該投資組合包括該若干資產的投資金額,該若干資產的投資金額設定為符合該限制條件;並在該投資組合中,該若干資產以個別的投資金額對應自一資料庫擷取的一歷史報酬資料以產生一預期報酬資料,且以該若干資產個別的投資金額佔投資總額的比例計算出投資權重,該預期報酬資料至少包括一預估年化報酬率、一預估年化標準差及一預估年化夏普值;透過一遞增金額的變化而重覆執行該投資組合設定以及該產生預期報酬資料之步驟,而產生包括多個該投資組合的一集合;最後以該集合中的預估年化夏普值符合一估測條件的投資組合,估測為類效率配置者。The present invention provides a method for quasi-efficiency allocation estimation of investment portfolios, which is executed by an electronic device with a plurality of executable codes. The method includes setting constraints, setting investment portfolios, generating expected return data, aggregation and quasi-efficiency Configuration steps. First, select multiple assets that you want to invest in, and set a restriction condition for each asset that meets the incremental unit of amount; then set up an investment portfolio with a number of the assets, and the investment portfolio includes the investment amount of the certain assets, the investment amount of the certain assets The amount is set to comply with the restriction; and in the investment portfolio, the individual investment amounts of the certain assets correspond to a historical return information retrieved from a database to generate an expected return information, and the individual investment amounts of the certain assets are The investment weight is calculated as the proportion of the amount to the total investment. The expected return information includes at least an estimated annualized rate of return, an estimated annualized standard deviation and an estimated annualized Sharpe value; repeated through changes in an incremental amount Execute the steps of setting up the investment portfolio and generating expected return data to generate a set including a plurality of the investment portfolios; finally, the investment portfolio that meets an estimation condition based on the estimated annualized Sharpe value in the set is estimated to be Class efficiency configurator.

本發明並提供一種非暫態電腦可讀取記錄媒體,其儲存多個可執行碼,使一電子裝置於讀取該些可執行碼並執行後,能夠執行上述方法。The invention also provides a non-transitory computer-readable recording medium that stores a plurality of executable codes so that an electronic device can execute the above method after reading and executing the executable codes.

於一實施例中,在該集合之步驟後,更包括一計算斜率之步驟,係按該多個投資組合的預估年化標準差進行大小的排序,以所述預估年化標準差符合一第一條件者的投資組合為一初始基準點,並依其餘投資組合的預估年化報酬率與預估年化標準差與該初始基準點對應之預估年化報酬率與預估年化標準差計算的斜率,再對各該斜率進行大小的排序,以從該多個投資組合中獲得所述斜率符合一第二條件的投資組合,視為符合該估測條件。In one embodiment, after the aggregation step, a step of calculating the slope is further included, which is to sort the multiple investment portfolios according to their estimated annualized standard deviations, so that the estimated annualized standard deviations meet The investment portfolio of the person with the first condition is an initial base point, and the estimated annualized rate of return and the estimated annualized standard deviation of the remaining investment portfolios are compared with the estimated annualized rate of return and the estimated annualized standard deviation corresponding to the initial base point. The slope calculated by normalizing the standard deviation is then sorted by magnitude to obtain an investment portfolio whose slope meets a second condition from the multiple investment portfolios, which is deemed to meet the estimation condition.

於一實施例中,該計算斜率之步驟後,更包括一迴圈運算之步驟,係該多個投資組合中,剔除低於該第二條件之斜率者以更新該集合,並以斜率符合該第二條件者的投資組合為一取代該初始基準點的更新基準點,再回到該計算斜率之步驟,以獲得下一個斜率符合該第二條件的投資組合。In one embodiment, after the step of calculating the slope, a loop operation step is further included, in which the slopes of the multiple investment portfolios that are lower than the second condition are eliminated to update the set, and the slopes are consistent with the second condition. The investment portfolio of the second condition is an updated base point that replaces the initial base point, and then returns to the step of calculating the slope to obtain the next investment portfolio whose slope meets the second condition.

於一實施例中,在該類效率配置之步驟中,將該初始基準點以及至少一該更新基準點所對應的斜率之投組進行高低的排序。並以其中的預估年化夏普值最高者,視為符合該估測條件。於一實施例中,在該類效率配置之步驟中,將所述該初始基準點以及至少一該更新基準點繪製出一類效率前緣曲線,以該類效率前緣曲線中的預估年化夏普值最高者,視為符合該估測條件。In one embodiment, in the efficiency configuration step, the investment groups of the slopes corresponding to the initial reference point and at least one updated reference point are sorted in a high-low order. The one with the highest estimated annualized Sharpe value is deemed to meet the estimation conditions. In one embodiment, in the step of efficiency configuration, the initial reference point and at least one updated reference point are drawn to draw an efficiency frontier curve, and the estimated annualized value in the efficiency frontier curve is The one with the highest Sharpe value is deemed to meet the estimation conditions.

於一實施例中,在該迴圈運算之步驟中,以該預估年化標準差與該預估年化報酬率皆低於所述斜率符合該第二條件者,為從該集合中剔除之投資組合。In one embodiment, in the loop operation step, if both the estimated annualized standard deviation and the estimated annualized rate of return are lower than the slope and meet the second condition, they are removed from the set. investment portfolio.

於一實施例中,該投資金額為各該投資組合內各該資產的一投入金額上限、一投入金額下限,以及一遞增金額。In one embodiment, the investment amount is an upper limit of investment amount, a lower limit of investment amount, and an incremental amount for each asset in the investment portfolio.

於一實施例中,該投入金額上限,是由一輸入介面之輸入而設定;該投入金額下限與該遞增金額,係依各該資產所知的申購限制及交易限制而自動帶出。In one embodiment, the upper limit of the investment amount is set by input from an input interface; the lower limit of the investment amount and the incremental amount are automatically brought out based on the subscription restrictions and transaction restrictions known to each asset.

於一實施例中,該歷史報酬資料是從該資料庫在上市時間重疊的同一時間段中,擷取各該資產個別對應的一歷史報酬率所獲得。In one embodiment, the historical return data is obtained from the database by retrieving a historical return rate corresponding to each asset in the same time period in which listing times overlap.

於一實施例中,各該資產所屬的歷史報酬資料,包括年化報酬率和年化標準差,以及各該資產之間的一相關係數與共變數矩陣。In one embodiment, the historical return data of each asset includes annualized return rate and annualized standard deviation, as well as a correlation coefficient and covariance matrix between each asset.

於一實施例中,在該多個投資組合中,以所述預估年化標準差最低的投資組合為符合該第一條件者,且以所述斜率最高的投資組合為符合該第二條件者。In one embodiment, among the multiple investment portfolios, the investment portfolio with the lowest estimated annualized standard deviation is the one that meets the first condition, and the investment portfolio with the highest slope is the one that meets the second condition. By.

藉此,本發明的類效率配置估測投資組合的方法,及非暫態電腦可讀取記錄媒體,能夠產生類似效率配置的投資組合結果,且由於投資金額符合交易時的遞增金額,所產生的投資組合能夠直接投入交易市場中進行申購,以達到投資組合的估測結果更直覺且有效率之功效。Thus, the method of estimating investment portfolios with efficiency-like allocation and the non-transitory computer-readable recording medium of the present invention can produce investment portfolio results similar to efficiency allocation, and because the investment amount matches the incremental amount at the time of transaction, the resulting The investment portfolio can be directly put into the trading market for subscription, so as to achieve more intuitive and efficient estimation results of the investment portfolio.

為充分瞭解本發明之目的、特徵及功效,茲藉由下述具體之實施例,並配合所附之圖式,對本發明做一詳細說明,說明如後:In order to fully understand the purpose, characteristics and effects of the present invention, the present invention is described in detail through the following specific embodiments and the accompanying drawings, as follows:

本發明提供一種類效率配置估測投資組合的方法100,其係由一電子裝置(圖中未示)以多個可執行碼所執行,並請參考圖1,所述方法100包括限制條件設定101、投資組合設定102、產生預期報酬資料103、集合104、計算斜率105、迴圈運算106,以及類效率配置107之步驟執行,其中:The present invention provides a method 100 for estimating investment portfolios with efficiency allocation, which is executed by an electronic device (not shown in the figure) using multiple executable codes. Please refer to Figure 1. The method 100 includes the setting of restriction conditions. 101. Portfolio setting 102, generating expected return data 103, aggregation 104, calculating slope 105, loop operation 106, and executing the steps of efficiency-like allocation 107, among which:

所述限制條件設定101之步驟,為挑選欲投資的多個資產,並對各該資產設定一符合金額遞增單位的限制條件。所述資產,可以是基金、股票或債券,但不以此為限。所述金額遞增單位,係所述資產之投資金額遞增的金額單位,不需要再經過換算或處理(例如四捨五入,或無條件捨去法等整數化處理),而能夠直接投入市場申購的金額。於本實施例中,欲投資的多個資產,係挑選如表1所示之基金A、基金B以及基金C之三筆基金,但本發明不以此述的基金及為三筆所限。 表1(限制條件設定) 基金名稱 投入金額上限 投入金額下限 遞增金額 基金 A 5000 1000 1000 基金 B 5000 1000 1000 基金 C 5000 1000 1000 計算資料區間  起始日期 2021/01/01 結束日期 2021/12/31 無風險利率 1.5% The step of setting the restriction 101 is to select a plurality of assets to be invested and set a restriction for each asset that meets the incremental unit of amount. The assets mentioned may be funds, stocks or bonds, but are not limited to this. The above-mentioned incremental amount unit refers to the incremental amount unit of the investment amount of the asset, which does not need to be converted or processed (such as rounding, or unconditional rounding or other integer processing), and can be directly invested in the market for subscription. In this embodiment, the multiple assets to be invested are selected from three funds, namely Fund A, Fund B and Fund C as shown in Table 1. However, the present invention is not limited to the above-mentioned funds and three funds. Table 1 (restriction setting) Fund name Maximum investment amount Minimum investment amount incremental amount Fund A 5000 1000 1000 Fund B 5000 1000 1000 Fund C 5000 1000 1000 Calculate data interval start date 2021/01/01 end date 2021/12/31 risk-free rate 1.5%

於一實施例中,該投資金額為各該投資組合內各該資產的一投入金額上限、一投入金額下限,以及一遞增金額。於一實施例中,該投入金額上限,是由一輸入介面之輸入而設定;該投入金額下限與該遞增金額,係依各該資產所知的申購限制及交易限制(例如證券交易單位所公告的限制)而自動帶出。所述投入金額上限,用於決定所產生的各該投資組合中的各資產欲投入交易的最高金額(對應各資產所佔的權重)。In one embodiment, the investment amount is an upper limit of investment amount, a lower limit of investment amount, and an incremental amount for each asset in the investment portfolio. In one embodiment, the upper limit of the investment amount is set by input from an input interface; the lower limit of the investment amount and the incremental amount are based on the subscription restrictions and transaction restrictions known to each asset (such as those announced by the securities exchange unit). restrictions) and automatically brought out. The upper limit of the investment amount is used to determine the maximum amount of each asset in the investment portfolio that is to be invested in the transaction (corresponding to the weight of each asset).

所述投資組合設定102之步驟,為以若干該資產設定一投資組合,該投資組合包括該若干資產的投資金額,各該資產的投資金額設定為符合該限制條件。舉例來說,如表1所示的投資組合為基金A、基金B以及基金C等三檔基金的組合,該投資金額包括投入金額上限皆為5000元(新台幣,下同)、投入金額下限皆為1000元,且遞增金額以1000元(仟元)為單位,而此遞增金額的不同,用以產生滿足所述投入金額下限與投入金額上限的區間之中,包括基金A、基金B及基金C個的多種投資組合,例如一種投資組合中,基金A、基金B及基金C的投入金額分別設為1000元、5000元、3000元,此時投資總額為9000元,以此類推(併參表5的組別1)。The step of setting up the investment portfolio 102 is to set up an investment portfolio with a number of the assets. The investment portfolio includes the investment amount of the certain assets, and the investment amount of each asset is set to comply with the restriction. For example, the investment portfolio shown in Table 1 is a combination of three funds: Fund A, Fund B, and Fund C. The investment amount includes an upper limit of investment amount of 5,000 yuan (NTD, the same below) and a lower limit of investment amount. Both are 1,000 yuan, and the incremental amount is in units of 1,000 yuan (thousand yuan). The difference in the incremental amount is used to generate a range that meets the lower limit of the investment amount and the upper limit of the investment amount, including Fund A, Fund B and Multiple investment portfolios of Fund C. For example, in an investment portfolio, the investment amounts of Fund A, Fund B, and Fund C are set to 1,000 yuan, 5,000 yuan, and 3,000 yuan respectively. At this time, the total investment is 9,000 yuan, and so on (and See group 1) in Table 5.

所述產生預期報酬資料103之步驟,為在該投資組合中,該若干資產以個別的投資金額對應自一資料庫擷取的一歷史報酬資料以產生一預期報酬資料,所述資料庫可以是雲端伺服器,或所述電子裝置之本機伺服器。The step of generating expected return data 103 is to generate an expected return data by corresponding the certain assets in the investment portfolio with individual investment amounts to a historical return data retrieved from a database. The database may be Cloud server, or local server of the electronic device.

於一實施例中,該預期報酬資料如表2所示,包括一預估年化標準差、一預估年化夏普值,以及一預估年化報酬率,其中的預估年化夏普值是依據對應的預估年化標準差和預估年化報酬率所計算獲得,計算過程並考慮無風險利率,於此實施例中預設為1.5%(計算公式:夏普值=(報酬率-無風險利率)/標準差)。於此步驟中,並以該若干資產個別的投資金額佔投資總額的比例計算出投資權重。In one embodiment, the expected return information is as shown in Table 2, including an estimated annualized standard deviation, an estimated annualized Sharpe value, and an estimated annualized rate of return, where the estimated annualized Sharpe value It is calculated based on the corresponding estimated annualized standard deviation and estimated annualized rate of return. The calculation process also takes into account the risk-free interest rate, which is preset to 1.5% in this embodiment (calculation formula: Sharpe value = (rate of return - risk-free rate)/standard deviation). In this step, the investment weight is calculated based on the proportion of the individual investment amount of certain assets to the total investment.

承前例,基金A、基金B及基金C的投資總額為9000元,而基金A、基金B及基金C的投資權重可經計算為11.11%、55.56%、33.33%,所計算出的預估年化標準差為7.323、預估年化報酬率為11.781、預估年化夏普值為1.404 (併參表2的組別1)。 表2(預期報酬資料)   基金 A 基金 B 基金 C 預估年化標準差 預估年化報酬率 預估年化夏普值 組別 投資權重 1 11.11% 55.56% 33.33% 7.323 11.781 1.404 2 22.22% 33.33% 44.44% 5.013 8.362 1.369 3 50.00% 16.67% 33.33% 6.145 6.133 0.754 4 20.00% 40.00% 40.00% 5.739 9.407 1.378 5 45.45% 27.27% 27.27% 7.013 7.778 0.895 6 33.33% 11.11% 55.56% 3.528 4.943 0.976 7 23.08% 38.46% 38.46% 5.846 9.210 1.319 8 33.33% 33.33% 33.33% 6.297 8.553 1.120 9 71.43% 14.29% 14.29% 9.218 6.115 0.501 10 33.33% 44.44% 22.22% 8.134 10.359 1.089 11 9.09% 45.45% 45.45% 5.461 10.105 1.576 12 14.29% 14.29% 71.43% 2.266( 最小標準差) 5.130 1.602 13 71.43% 14.29% 14.29% 9.218 6.115 0.501 14 45.45% 45.45% 9.09% 10.190 10.732 0.906 15 45.45% 9.09% 45.45% 4.645 4.823 0.715 16 14.29% 71.43% 14.29% 10.875 14.415 1.188 17 44.44% 22.22% 33.33% 6.137 6.939 0.886 18 55.56% 33.33% 11.11% 9.614 8.936 0.773 19 33.33% 50.00% 16.67% 9.166 11.262 1.065 20 12.50% 25.00% 62.50% 3.137 6.840 1.702 Following the previous example, the total investment of Fund A, Fund B and Fund C is 9,000 yuan, and the investment weights of Fund A, Fund B and Fund C can be calculated as 11.11%, 55.56% and 33.33%. The calculated estimated annual The standardized deviation is 7.323, the estimated annualized return rate is 11.781, and the estimated annualized Sharpe value is 1.404 (see Group 1 in Table 2). Table 2 (expected return information) Fund A Fund B Fund C Estimated Annualized Standard Deviation Estimated annualized return Estimated Annualized Sharpe Value Group investment weight 1 11.11% 55.56% 33.33% 7.323 11.781 1.404 2 22.22% 33.33% 44.44% 5.013 8.362 1.369 3 50.00% 16.67% 33.33% 6.145 6.133 0.754 4 20.00% 40.00% 40.00% 5.739 9.407 1.378 5 45.45% 27.27% 27.27% 7.013 7.778 0.895 6 33.33% 11.11% 55.56% 3.528 4.943 0.976 7 23.08% 38.46% 38.46% 5.846 9.210 1.319 8 33.33% 33.33% 33.33% 6.297 8.553 1.120 9 71.43% 14.29% 14.29% 9.218 6.115 0.501 10 33.33% 44.44% 22.22% 8.134 10.359 1.089 11 9.09% 45.45% 45.45% 5.461 10.105 1.576 12 14.29% 14.29% 71.43% 2.266 ( minimum standard deviation) 5.130 1.602 13 71.43% 14.29% 14.29% 9.218 6.115 0.501 14 45.45% 45.45% 9.09% 10.190 10.732 0.906 15 45.45% 9.09% 45.45% 4.645 4.823 0.715 16 14.29% 71.43% 14.29% 10.875 14.415 1.188 17 44.44% 22.22% 33.33% 6.137 6.939 0.886 18 55.56% 33.33% 11.11% 9.614 8.936 0.773 19 33.33% 50.00% 16.67% 9.166 11.262 1.065 20 12.50% 25.00% 62.50% 3.137 6.840 1.702

於一實施例中,該歷史報酬資料是從該資料庫在上市時間重疊的同一時間段中,擷取各該資產個別對應的一歷史報酬率所獲得。如表1所示,所述上市時間重疊的同一時間段,係以2021/1/1~2021/12/31為資料計算區間,但不以此例的時間段為限,所述同一時間段可以更長或更短,只要上市時間重疊即可。又如表3所示,該歷史報酬資料包括基金A、基金B以及基金C的歷史日報酬率,但本發明不以此為限。 表3(歷史日報酬率) 日期 基金 A 基金 B 基金 C 2021/1/1 0 0 0 2021/1/4 -0.106846 -1.663181 -0.26647 2021/1/5 1.215025 0.456926 -0.161113 2021/1/6 1.09799 -0.280763 0.122431 2021/1/7 0.936944 1.698374 0.109785 2021/1/8 0.854009 0.945725 0.106633 2021/1/11 -1.084632 -0.652207 -0.171646 2021/1/12 1.000864 -0.314253 -0.075836 2021/1/13 -0.548619 0.044175 0.012986 2021/1/14 0.851837 -0.624576 0.234335 2021/1/15 -1.679984 -0.487478 0.027154 2021/1/18 0.016032 0.016032 0.016032 2021/1/19 0.854172 1.03977 0.037539 2021/1/20 0.811446 1.640245 0.16065 (省略) 2021/12/27 0.591084 1.243687 -0.106496 2021/12/28 -0.095572 -0.484715 -0.095572 2021/12/29 -0.309873 0.093317 0.151419 2021/12/30 0.010989 -0.101554 0.041611 2021/12/31 0.138944 -0.291721 -0.000138 In one embodiment, the historical return data is obtained from the database by retrieving a historical return rate corresponding to each asset in the same time period in which listing times overlap. As shown in Table 1, the same time period in which the listed listing times overlap is based on 2021/1/1~2021/12/31 as the data calculation interval, but is not limited to the time period in this example. The same time period Can be longer or shorter, as long as the time to market overlaps. As shown in Table 3, the historical return data includes the historical daily return rates of Fund A, Fund B and Fund C, but the present invention is not limited to this. Table 3 (Historical daily return rate) date Fund A Fund B Fund C 2021/1/1 0 0 0 2021/1/4 -0.106846 -1.663181 -0.26647 2021/1/5 1.215025 0.456926 -0.161113 2021/1/6 1.09799 -0.280763 0.122431 2021/1/7 0.936944 1.698374 0.109785 2021/1/8 0.854009 0.945725 0.106633 2021/1/11 -1.084632 -0.652207 -0.171646 2021/1/12 1.000864 -0.314253 -0.075836 2021/1/13 -0.548619 0.044175 0.012986 2021/1/14 0.851837 -0.624576 0.234335 2021/1/15 -1.679984 -0.487478 0.027154 2021/1/18 0.016032 0.016032 0.016032 2021/1/19 0.854172 1.03977 0.037539 2021/1/20 0.811446 1.640245 0.16065 (omitted) 2021/12/27 0.591084 1.243687 -0.106496 2021/12/28 -0.095572 -0.484715 -0.095572 2021/12/29 -0.309873 0.093317 0.151419 2021/12/30 0.010989 -0.101554 0.041611 2021/12/31 0.138944 -0.291721 -0.000138

再如表4所示,基金A、基金B以及基金C所屬的歷史報酬資料,依據個別歷史日報酬率(如表3所示),更進一步包括報酬率、標準差、年化報酬率和年化標準差。 表4(歷史報酬資料) 基金名稱 基金 A 基金 B 基金 C 報酬率 0.0170 0.0746 0.0102 標準差 0.8944 1.0007 0.2404 年化報酬率 4.2859 18.8117 2.5627 年化標準差 14.1978 15.8862 3.8158 As shown in Table 4, the historical return data of Fund A, Fund B and Fund C are based on individual historical daily returns (as shown in Table 3) and further include return rate, standard deviation, annualized return rate and annualized return rate. standard deviation. Table 4 (historical compensation data) Fund name Fund A Fund B Fund C rate of return 0.0170 0.0746 0.0102 standard deviation 0.8944 1.0007 0.2404 annualized rate of return 4.2859 18.8117 2.5627 annualized standard deviation 14.1978 15.8862 3.8158

所述隨機產生集合104之步驟,為透過遞增金額的變化,而重覆執行該投資組合設定之步驟,隨機產生包括多個該投資組合的一集合。於一實施例中,是以電腦利用應用程式進行所述多個該投資組合的隨機產生,但本發明不以此為限。如表5所示,為隨機產生包括組別1-20共20組投資組合的集合,其中各投資組合的基金A、基金B以及基金C,皆符合前述投入金額上限(5000元)和投入金額下限(1000元),且遞增金額以1000元為單位的條件。 表5(投資組合的集合)   基金 A 基金 B 基金 C 投資總額 組別 投資金額 1 1000 5000 3000 9000 2 2000 3000 4000 9000 3 3000 1000 2000 6000 4 2000 4000 4000 10000 5 5000 3000 3000 11000 6 3000 1000 5000 9000 7 3000 5000 5000 13000 8 4000 4000 4000 12000 9 5000 1000 1000 7000 10 3000 4000 2000 9000 11 1000 5000 5000 11000 12 1000 1000 5000 7000 13 5000 1000 1000 7000 14 5000 5000 1000 11000 15 5000 1000 5000 11000 16 1000 5000 1000 7000 17 4000 2000 3000 9000 18 5000 3000 1000 9000 19 2000 3000 1000 6000 20 1000 2000 5000 8000 The step of randomly generating the set 104 is to repeatedly execute the steps of setting the investment portfolio by changing the incremental amount to randomly generate a set including a plurality of the investment portfolios. In one embodiment, a computer is used to generate the plurality of investment portfolios randomly using an application program, but the invention is not limited to this. As shown in Table 5, a set of 20 investment portfolios including groups 1-20 is randomly generated. Fund A, Fund B and Fund C of each investment portfolio all meet the aforementioned upper limit of investment amount (5,000 yuan) and investment amount. The lower limit is (1,000 yuan), and the incremental amount is in units of 1,000 yuan. Table 5 (Collection of Portfolios) Fund A Fund B Fund C total investment Group Investment amount 1 1000 5000 3000 9000 2 2000 3000 4000 9000 3 3000 1000 2000 6000 4 2000 4000 4000 10000 5 5000 3000 3000 11000 6 3000 1000 5000 9000 7 3000 5000 5000 13000 8 4000 4000 4000 12000 9 5000 1000 1000 7000 10 3000 4000 2000 9000 11 1000 5000 5000 11000 12 1000 1000 5000 7000 13 5000 1000 1000 7000 14 5000 5000 1000 11000 15 5000 1000 5000 11000 16 1000 5000 1000 7000 17 4000 2000 3000 9000 18 5000 3000 1000 9000 19 2000 3000 1000 6000 20 1000 2000 5000 8000

所述計算斜率105之步驟,係按該多個投資組合的預估年化標準差進行大小的排序,以所述預估年化標準差符合一第一條件者的投資組合為一初始基準點(標示如圖2座標中的(X1,Y1))。所述符合該第一條件的投資組合,於一實施例中,可以是在該多個投資組合中,所述預估年化標準差最低的投資組合,例如表2中組別12的投資組合,其「預估年化標準差」為2.266而於所在的集合中為最低者。The step of calculating the slope 105 is to sort the multiple investment portfolios according to their estimated annualized standard deviations, and use the investment portfolio whose estimated annualized standard deviation meets a first condition as an initial benchmark point. (Marked as (X1, Y1) in the coordinates in Figure 2). The investment portfolio that meets the first condition, in one embodiment, may be the investment portfolio with the lowest estimated annualized standard deviation among the multiple investment portfolios, such as the investment portfolio of Group 12 in Table 2 , its "estimated annualized standard deviation" is 2.266 and is the lowest in the set.

承上,接著再依其餘投資組合的預估年化報酬率與預估年化標準差,與該初始基準點對應之預估年化報酬率與預估年化標準差計算出的斜率,再對各該斜率進行大小的排序,以從該多個投資組合中獲得所述斜率最高者,符合一第二條件,例如圖2之座標中,標示為(X2,Y2)所屬之投資組合,其組別12的斜率1.963為最高(併參表6之當前組別12的當前預估年化標準差2.266、當前預估年化報酬率5.130,以及當前組別的斜率1.963)。Continuing on from the above, and then based on the estimated annualized return and estimated annualized standard deviation of the remaining investment portfolios, the slope calculated from the estimated annualized return and estimated annualized standard deviation corresponding to the initial base point, and then Sort the slopes in order to obtain the one with the highest slope from the multiple investment portfolios, which meets a second condition. For example, in the coordinates of Figure 2, the investment portfolio to which (X2, Y2) belongs is marked. Group 12 has the highest slope of 1.963 (see Table 6 for the current estimated annualized standard deviation of 2.266, the current estimated annualized return of 5.130, and the current group's slope of 1.963).

所述迴圈運算106之步驟,為該多個投資組合中,以斜率高於該第二條件的投資組合為一更新基準點(以此更新基準點取代該初始基準點而為新的基準點),並剔除報酬率較低者以更新該集合,再回到該計算斜率之步驟,以獲得下一個斜率最高的投資組合條件。所述符合該第二條件者,除上述所述斜率為最高的投資組合,進一步也可以是該預估年化標準差低於所述斜率符合該第二條件者,以及該預估年化報酬率高於所述斜率符合該第二條件者,為所述報酬率較低者,以從該集合中剔除。所述「當前」,係指作為比較基礎之該初始基準點或該更新基準點所對應之組別、預估年化標準差、預估年化報酬率。The step of the loop operation 106 is to use the investment portfolio with a slope higher than the second condition among the plurality of investment portfolios as an updated base point (using this updated base point to replace the initial base point and become a new base point) ), and eliminate those with lower returns to update the set, and then return to the step of calculating the slope to obtain the portfolio condition with the next highest slope. Those that meet the second condition, in addition to the investment portfolio with the highest slope mentioned above, may also be those whose estimated annualized standard deviation is lower than the slope that meets the second condition, and the estimated annualized return Those whose rate is higher than the slope and meet the second condition are those with a lower return rate and will be eliminated from the set. The "current" refers to the initial benchmark point or the group corresponding to the updated benchmark point, the estimated annualized standard deviation, and the estimated annualized rate of return that serve as the basis for comparison.

舉例來說,如以表6所示,根據組別1-20的投資組合,共進行了五次迴圈運算106之步驟,結果分別於表6中以前緣線的點編號1~5表示。前緣線的點編號1,是以組別12有最小預估年化標準差而作為初始基準點,再與其餘組別進行斜率的比較,其中以組別20有最大斜率1.963。接著,剔除組別1~19中,所述預估年化標準差與所述預估年化報酬率皆低於組別20者(即剔除組別6、組別12、組別15),改以組別20有最大斜率而為第一次的更新基準點,再與剔除後的其餘組別進行斜率的比較,以此類推,獲得以組別11有最大斜率而為第二次的更新基準點、以組別1有最大斜率而為第三次的更新基準點,以及以組別16有最大斜率而為第四次的更新基準點,藉此獲得組別12、組別20、組別11、組別1,以及組別16等五個前緣線的點編號1~5。 表6(迴圈運算的最大斜率與組別)   前緣線的點編號 1 2 3 4 5 當前組別 12 20 11 1 16 當前預估年化標準差 2.266 3.137 5.461 7.323 10.875 當前預估年化報酬率 5.130 6.840 10.105 11.781 14.415 組別 與當前組別的斜率 1.315 1.180 0.900 0.000 0.000 1 1.177 0.811 0.000 0.000 0.000 2 0.258 0.000 0.000 0.000 0.000 3 1.232 0.987 0.000 0.000 0.000 4 0.558 0.242 0.000 0.000 0.000 5 0.000 0.000 0.000 0.000 0.000 6 1.140 0.875 0.000 0.000 0.000 7 0.849 0.542 0.000 0.000 0.000 8 0.142 0.000 0.000 0.000 0.000 9 0.891 0.704 0.095 0.000 0.000 10 1.557 1.405 0.000 0.000 0.000 11 0.000 0.000 0.000 0.000 0.000 12 0.142 0.000 0.000 0.000 0.000 13 0.707 0.552 0.133 0.000 0.000 14 0.000 0.000 0.000 0.000 0.000 15 1.079 0.979 0.796 0.742 0.000 16 0.467 0.033 0.000 0.000 0.000 17 0.518 0.324 0.000 0.000 0.000 18 0.889 0.733 0.312 0.000 0.000 19 1.963 0.000 0.000 0.000 0.000 20 最大斜率 1.963 1.405 0.900 0.742   最大斜率組別 20 11 1 16   For example, as shown in Table 6, based on the investment portfolios of groups 1-20, a total of five loop calculation steps of 106 are performed, and the results are respectively represented in Table 6 by point numbers 1 to 5 of the leading edge line. The point number 1 of the front line is based on the minimum estimated annualized standard deviation of group 12 as the initial reference point. The slope is then compared with other groups. Among them, group 20 has the largest slope of 1.963. Next, among groups 1 to 19, those whose estimated annualized standard deviation and estimated annualized return rate are both lower than group 20 are eliminated (that is, group 6, group 12, and group 15 are eliminated), Group 20 has the largest slope and is used as the base point for the first update. Then the slope is compared with the remaining groups after elimination. By analogy, group 11 has the largest slope and is the second update point. The base point, group 1 has the largest slope and is the third updated base point, and group 16 has the largest slope and is the fourth updated base point, thereby obtaining group 12, group 20, group The points of the five leading edge lines are numbered 1 to 5, including Category 11, Group 1, and Group 16. Table 6 (Maximum slope and group of loop operation) Point number of leading edge line 1 2 3 4 5 Current group 12 20 11 1 16 Current estimated annualized standard deviation 2.266 3.137 5.461 7.323 10.875 Current estimated annualized return 5.130 6.840 10.105 11.781 14.415 Group slope with current group 1.315 1.180 0.900 0.000 0.000 1 1.177 0.811 0.000 0.000 0.000 2 0.258 0.000 0.000 0.000 0.000 3 1.232 0.987 0.000 0.000 0.000 4 0.558 0.242 0.000 0.000 0.000 5 0.000 0.000 0.000 0.000 0.000 6 1.140 0.875 0.000 0.000 0.000 7 0.849 0.542 0.000 0.000 0.000 8 0.142 0.000 0.000 0.000 0.000 9 0.891 0.704 0.095 0.000 0.000 10 1.557 1.405 0.000 0.000 0.000 11 0.000 0.000 0.000 0.000 0.000 12 0.142 0.000 0.000 0.000 0.000 13 0.707 0.552 0.133 0.000 0.000 14 0.000 0.000 0.000 0.000 0.000 15 1.079 0.979 0.796 0.742 0.000 16 0.467 0.033 0.000 0.000 0.000 17 0.518 0.324 0.000 0.000 0.000 18 0.889 0.733 0.312 0.000 0.000 19 1.963 0.000 0.000 0.000 0.000 20 maximum slope 1.963 1.405 0.900 0.742 Maximum slope group 20 11 1 16

所述類效率配置107之步驟,為以該集合中的預估年化夏普值符合一估測條件的投資組合,估測為類效率配置者。於一實施例中,在該類效率配置之步驟中,將該初始基準點以及至少一該更新基準點所對應的斜率進行高低的排序,並以其中的預估年化夏普值最高者,視為符合該估測條件。根據該初始基準點以及該四個更新基準點,如表7所示對應的組別/預估年化夏普值,分別為組別20/1.702、組別12/1.602、組別11/1.576、組別1/1.404,以及組別16/1.188。The step of quasi-efficiency allocation 107 is to estimate the investment portfolio as a quasi-efficiency allocator based on the estimated annualized Sharpe value in the set that meets an estimation condition. In one embodiment, in the step of efficiency configuration, the slopes corresponding to the initial reference point and at least one updated reference point are sorted, and the one with the highest estimated annualized Sharpe value is regarded as To comply with this estimation condition. According to the initial base point and the four updated base points, the corresponding group/estimated annualized Sharpe values as shown in Table 7 are group 20/1.702, group 12/1.602, group 11/1.576, respectively. Group 1/1.404, and Group 16/1.188.

於一實施例中,在該類效率配置107之步驟中,將前述組別1、組別11、組別12、組別16,以及組別20所對應初始基準點以及四個更新基準點,並以此為基準而繪製出一類效率前緣曲線(如圖3所示),並以該類效率前緣曲線中的年化夏普值最高者,於此例中即組別20的投資組合視為符合該估測條件。 表7(類效率前緣曲線中各組別點所對應的資料) 組別 預估年化標準差 預估年化報酬率 預估年化夏普值 12 2.266 5.130 1.602 20 3.137 6.840 1.702 11 5.461 10.105 1.576 1 7.323 11.781 1.404 16 10.875 14.415 1.188 無風險利率點 0 1.5   In one embodiment, in the step of efficiency configuration 107, the initial reference points and four updated reference points corresponding to the aforementioned group 1, group 11, group 12, group 16, and group 20 are Based on this, a type of efficiency frontier curve is drawn (as shown in Figure 3), and the one with the highest annualized Sharpe value in this type of efficiency frontier curve, in this case, is the investment portfolio of group 20. To comply with this estimate. Table 7 (data corresponding to each group point in the class efficiency front curve) Group Estimated Annualized Standard Deviation Estimated annualized return Estimated Annualized Sharpe Value 12 2.266 5.130 1.602 20 3.137 6.840 1.702 11 5.461 10.105 1.576 1 7.323 11.781 1.404 16 10.875 14.415 1.188 risk free interest rate point 0 1.5

本發明並提供一種非暫態電腦可讀取記錄媒體,其儲存多個可執行碼,使所述電子裝置於讀取該些可執行碼並執行後,能夠執行上述方法。The present invention also provides a non-transitory computer-readable recording medium that stores a plurality of executable codes so that the electronic device can execute the above method after reading and executing the executable codes.

上述實施例之演算法,於此將其虛擬碼(Pseudo Code)列出並說明如下:「 begin //開始Initialize FundsSet.InvAmt;  //設定投資組合內,各基金的投入金額上限、下限,與遞增金額Initialize FundsSet.HisReturn;  //取得投資組合內各基金的歷史報酬率數據Function calFundsExpectReturnRisk(FundsSet){       //取以上各基金中之歷史報酬率數據之同一或更長/短時間段GetCommonHisReturnLength(FundsSet.HisReturn); //計算各基金之預估年化報酬率與預估年化標準差     CalExpectReturn(FundsSet);        CalRisk(FundsSet); } for I = 0 & I < N;//迴圈運算N次RandmAmtSet = RandomAmtAllocation(FundsSet); //以各基金的投入金額上限、下限範圍內隨機取得一組投資金額配置AllocationInPercentSet = AllocationInPercent(RandmAmtSet);//依照上述各基金配置金額,計算投資組合總額,與各基金於投資組合中的個別權重Portolio.ExpectReturnRisk = CalPortfolio ExpectReturnRisk(AllocationInPercentSet);// 依各基金權重計算出投資組合的預估年化報酬率跟預估年化標準差PortfolioSet = AddPortofolio(Portolio);//加入投資組合的集合end forLowestRisk = SortPortfolioRisk(PortfolioSet);//將各投資組合的預估年化標準差排序並取得最小者為初始基準點; CalPortfolioSharpRatio; (PortfolioSet);//計算所有投資組合的預估年化夏普值SortPortfolioSharpRatio; (PortfolioSet);//透過排序取得預估年化夏普值排序並取得最大的點IniPoint = LowestRisk;//以投資組合中最小的預估年化標準差者作為初始基準點的投資組合N = PortfolioSet;//所含投資組合數量for I = 0 & I < N;//迴圈運算N次HighSlopPortfolio = CalHighSlop(IniPoint, PortfolioSet); //取得預估年化報酬率與預估年化標準差大於初始基準點的所有其他投資組合的點,並計算這些點的斜率,並進行斜率值排序,取得斜率最大的投資組合IniPoint = HighSlopPortfolio;//上述斜率最大的點即為投資組合的更新基準點PortfolioSet = PickHigherSlopExpectReturnLowerRisk(PortfolioSet); //排除所有其他斜率較低,以及預估年化標準差與預估年化報酬率較低的所有投資組合點,建立新的投資組合的集合end forPortfolioSet = SortPortfolio (PortfolioSet);//將初始基準點與至少一更新基準點所對應的投資組合,依照個別預估年化標準差與預估年化報酬率的數值由小到大排序DrawQuasiEfficientFrontier(PortfolioSet);//繪製出類效率前緣曲線圖FinalPortfolio = SortPortfolioSharpRatio (PortfolioSet); //取得預估年化夏普值最高的投資組合成為最佳化之效率配置end //結束」 The algorithm of the above embodiment is listed and explained as follows: " begin //Start Initialize FundsSet.InvAmt; //Set the upper limit, lower limit, and incremental amount of the investment amount of each fund in the investment portfolio Initialize FundsSet.HisReturn; //Get the historical return data of each fund in the investment portfolio Function calFundsExpectReturnRisk(FundsSet ){ //Get the same or longer/shorter time period of the historical return data in each fund above GetCommonHisReturnLength(FundsSet.HisReturn); //Calculate the estimated annualized return and estimated annualized standard deviation of each fund CalExpectReturn (FundsSet); CalRisk(FundsSet); } for I = 0 & I < N;//Loop operation N times RandmAmtSet = RandomAmtAllocation(FundsSet); //Randomly obtain a set of investment amount allocations within the upper and lower limits of each fund's investment amount AllocationInPercentSet = AllocationInPercent(RandmAmtSet); //Based on the allocation amount of each fund mentioned above, calculate the total investment portfolio and the individual weight of each fund in the investment portfolio Portolio.ExpectReturnRisk = CalPortfolio ExpectReturnRisk(AllocationInPercentSet);//Calculate the estimated annual return of the investment portfolio based on the weight of each fund Rate and estimated annualized standard deviation PortfolioSet = AddPortofolio(Portolio);//Add the set of portfolios end forLowestRisk = SortPortfolioRisk(PortfolioSet);//Sort the estimated annualized standard deviation of each portfolio and obtain the smallest one as the initial Base point; CalPortfolioSharpRatio; (PortfolioSet);//Calculate the estimated annualized Sharpe value of all portfoliosSortPortfolioSharpRatio; (PortfolioSet);//Get the estimated annualized Sharpe value sorting through sorting and obtain the largest point IniPoint = LowestRisk;/ /The portfolio with the smallest estimated annualized standard deviation in the portfolio as the initial benchmark point N = PortfolioSet; //The number of portfolios included for I = 0 & I < N; //Loop operation N times HighSlopPortfolio = CalHighSlop(IniPoint, PortfolioSet); //Get the points of all other investment portfolios where the estimated annualized return and estimated annualized standard deviation are greater than the initial base point, calculate the slopes of these points, sort the slope values, and obtain the slopes The largest portfolio IniPoint = HighSlopPortfolio; //The point with the largest slope above is the updated base point of the portfolio PortfolioSet = PickHigherSlopExpectReturnLowerRisk(PortfolioSet); //Exclude all other lower slopes, as well as the estimated annualized standard deviation and the estimated year Convert all portfolio points with lower returns and create a new set of portfolios end forPortfolioSet = SortPortfolio (PortfolioSet); // Combine the investment portfolios corresponding to the initial base point and at least one updated base point, and annualize them according to individual estimates Sort the values of standard deviation and estimated annualized return from small to large DrawQuasiEfficientFrontier(PortfolioSet); //Draw the efficiency frontier curve FinalPortfolio = SortPortfolioSharpRatio (PortfolioSet); //Get the investment with the highest estimated annualized Sharpe value The combination becomes the optimized efficiency configuration end //End"

由上述之說明不難發現本發明的特點,在於本發明的類效率配置估測投資組合的方法,以及非暫態電腦可讀取記錄媒體,其透過投資組合設定,以資產的投資金額必須符合金額遞增單位為限制條件,再參考歷史報酬資料而產生預期報酬資料作為估測基礎,並經由重覆執行而在隨機產生投資組合的集合中,以預估年化夏普值符合估測條件的投資組合為類效率配置者,藉此產生幾近於效率配置的投資組合結果,且由於投資金額符合交易時的遞增金額,所產生的投資組合能夠直接投入交易市場中進行申購,以達到投資組合的估測結果更直覺,且更有效率之功效。From the above description, it is easy to find that the characteristics of the present invention lie in the efficiency-like allocation estimation method of the investment portfolio of the present invention and the non-transitory computer-readable recording medium. Through the investment portfolio setting, the investment amount of the assets must comply with The incremental unit of amount is used as a restriction, and the expected return data is generated with reference to historical return data as the basis for estimation, and through repeated execution, the annualized Sharpe value of the investment that meets the estimation conditions is estimated in a set of randomly generated investment portfolios. The portfolio is a quasi-efficiency allocator, thereby producing an investment portfolio result that is close to efficient allocation, and since the investment amount matches the incremental amount at the time of transaction, the resulting investment portfolio can be directly put into the trading market for subscription to achieve the investment portfolio's The estimation results are more intuitive and more efficient.

本發明在上文中已以較佳實施例揭露,然熟習本項技術者應理解的是,該實施例僅用於描繪本發明,而不應解讀為限制本發明之範圍。應注意的是,舉凡與該實施例等效之變化與置換,均應設為涵蓋於本發明之範疇內。因此,本發明之保護範圍當以申請專利範圍所界定者為準。The present invention has been disclosed above with preferred embodiments. However, those skilled in the art should understand that the embodiments are only used to illustrate the present invention and should not be interpreted as limiting the scope of the present invention. It should be noted that any changes and substitutions that are equivalent to this embodiment should be considered to be within the scope of the present invention. Therefore, the protection scope of the present invention shall be subject to the scope of the patent application.

100:方法 101:限制條件設定 102:投資組合設定 103:產生預期報酬資料 104:集合 105:計算斜率 106:迴圈運算 107:類效率配置 100:Method 101: Restriction setting 102: Portfolio Settings 103: Generate expected return information 104:Gathering 105: Calculate slope 106: Loop operation 107: Class efficiency configuration

圖1係本發明一具體實施例的方法流程圖。 圖2係本發明一具體實施例以初始基準點為基礎的投資組合之座標圖。 圖3係本發明一具體實施例的類效率前緣曲線圖。 Figure 1 is a method flow chart of a specific embodiment of the present invention. Figure 2 is a coordinate diagram of an investment portfolio based on an initial benchmark point according to a specific embodiment of the present invention. Figure 3 is a quasi-efficiency front curve diagram of a specific embodiment of the present invention.

100:方法 100:Method

101:限制條件設定 101: Restriction setting

102:投資組合設定 102: Portfolio Settings

103:產生預期報酬資料 103: Generate expected return information

104:集合 104:Gathering

105:計算斜率 105: Calculate slope

106:迴圈運算 106: Loop operation

107:類效率配置 107: Class efficiency configuration

Claims (12)

一種類效率配置估測投資組合的方法,其係由一電子裝置以多個可執行碼所執行,所述方法包括: 限制條件設定:挑選欲投資的多個資產,並對各該資產設定一符合金額遞增單位的限制條件; 投資組合設定:以若干該資產設定一投資組合,該投資組合包括該若干資產的投資金額,該若干資產的投資金額設定為符合該限制條件; 產生預期報酬資料:在該投資組合中,以該若干資產個別的投資金額佔投資總額的比例計算出投資權重,且該若干資產以個別的投資金額對應自一資料庫擷取的一歷史報酬資料以產生一預期報酬資料,且以該若干資產個別的投資金額佔投資總額的比例計算出投資權重,該預期報酬資料至少包括一預估年化報酬率、一預估年化標準差及一預估年化夏普值; 集合:透過一遞增金額的變化而重覆執行該投資組合設定以及該產生預期報酬資料之步驟,而隨機產生包括多個該投資組合的一集合;以及 類效率配置:以該集合中的預估年化夏普值符合一估測條件的投資組合,估測為類效率配置者。 A method for estimating investment portfolios with efficiency allocation, which is executed by an electronic device using a plurality of executable codes. The method includes: Restriction setting: Select multiple assets to invest in, and set a restriction for each asset that meets the incremental unit of amount; Investment portfolio setting: Set up an investment portfolio with a number of the assets, the investment portfolio includes the investment amount of the certain assets, and the investment amount of the certain assets is set to comply with the restriction; Generate expected return data: In the investment portfolio, the investment weight is calculated based on the proportion of the individual investment amount of the certain assets to the total investment, and the individual investment amount of the certain assets corresponds to a historical return data extracted from a database To generate an expected return information and calculate the investment weight based on the proportion of the individual investment amount of certain assets to the total investment. The expected return information at least includes an estimated annualized rate of return, an estimated annualized standard deviation and an estimated annualized standard deviation. Estimated annualized Sharpe value; Collection: Randomly generate a collection of multiple investment portfolios by repeatedly executing the steps of setting up the investment portfolio and generating expected return data by changing an incremental amount; and Class-efficiency allocation: A portfolio whose estimated annualized Sharpe value in the set meets an estimation condition is estimated to be a class-efficiency allocator. 如請求項1所述之類效率配置估測投資組合的方法,其中該集合之步驟後,更包括一計算斜率之步驟,係按該多個投資組合的預估年化標準差進行大小的排序,以所述預估年化標準差符合一第一條件的投資組合為一初始基準點,並依其餘投資組合的預估年化報酬率與預估年化標準差與該初始基準點對應之預估年化報酬率與預估年化標準差計算的斜率,再對各該斜率進行大小的排序,以從該多個投資組合中獲得所述斜率符合一第二條件的投資組合,視為符合該估測條件。A method for estimating the efficiency allocation of investment portfolios as described in claim 1, wherein after the aggregation step, a step of calculating the slope is further included, which is sorted according to the estimated annualized standard deviation of the multiple investment portfolios. , taking the investment portfolio whose estimated annualized standard deviation meets a first condition as an initial benchmark point, and based on the estimated annualized return rate and estimated annualized standard deviation of the remaining investment portfolios corresponding to the initial benchmark point The slope calculated by the estimated annualized return rate and the estimated annualized standard deviation is then sorted by magnitude to obtain an investment portfolio whose slope meets a second condition from the multiple investment portfolios, which is regarded as meet the conditions for this estimate. 如請求項2所述之類效率配置估測投資組合的方法,其中該計算斜率之步驟後,更包括一迴圈運算之步驟,係該多個投資組合中,剔除報酬率較低於符合該第二條件之斜率者以更新該集合,並以斜率符合該第二條件的投資組合為一取代該初始基準點的更新基準點,再回到該計算斜率之步驟,以獲得下一個斜率符合該第二條件的投資組合。The method of estimating investment portfolios with efficiency allocation as described in claim 2, wherein the step of calculating the slope further includes a step of loop calculation, if among the multiple investment portfolios, the return rate is eliminated is lower than the rate that meets the requirement. The slope of the second condition is updated by updating the set, replacing the initial base point with an investment portfolio whose slope meets the second condition, and then returning to the step of calculating the slope to obtain the next slope that meets the slope. Second condition portfolio. 如請求項3所述之類效率配置估測投資組合的方法,其中,在該類效率配置之步驟中,將該初始基準點以及至少一該更新基準點所對應的斜率之投組進行高低的排序,並以其中的預估年化夏普值最高者,視為符合該估測條件。A method for estimating investment portfolios with efficiency allocation as described in claim 3, wherein in the step of efficiency allocation, the investment groups with slopes corresponding to the initial base point and at least one updated base point are compared with each other. Sort them, and the one with the highest estimated annualized Sharpe value is deemed to meet the estimation conditions. 如請求項4所述之類效率配置估測投資組合的方法,其中,在該類效率配置之步驟中,將該初始基準點以及至少一該更新基準點繪製出一類效率前緣曲線,以該類效率前緣曲線中的預估年化夏普值最高者,視為符合該估測條件。A method for estimating an investment portfolio with efficiency allocation as described in claim 4, wherein in the step of efficiency allocation, the initial base point and at least one updated base point are used to draw a type of efficiency front curve, with the The one with the highest estimated annualized Sharpe value in the efficiency-like front curve is deemed to meet the estimation conditions. 如請求項5所述之類效率配置估測投資組合的方法,其中,在該迴圈運算之步驟中,以該預估年化標準差與該預估年化報酬率皆低於所述斜率符合該第二條件者,為從該集合中剔除之投資組合。A method for estimating investment portfolios with efficiency allocation as described in claim 5, wherein in the step of loop calculation, both the estimated annualized standard deviation and the estimated annualized rate of return are lower than the slope Those that meet the second condition are the investment portfolios that are removed from the set. 如請求項4所述之類效率配置估測投資組合的方法,其中,該投資金額為各該投資組合內各該資產的一投入金額上限、一投入金額下限,以及該遞增金額。The method of efficiency allocation estimation investment portfolio as described in claim 4, wherein the investment amount is an upper limit of investment amount, a lower limit of investment amount, and the incremental amount for each asset in the investment portfolio. 如請求項7所述之類效率配置估測投資組合的方法,其中,該投入金額上限,是由一輸入介面之輸入而設定;該投入金額下限與該遞增金額,係依各該資產所知的申購限制及交易限制而自動帶出。A method for estimating investment portfolios with efficiency allocation as described in claim 7, wherein the upper limit of the investment amount is set by input from an input interface; the lower limit of the investment amount and the incremental amount are based on the knowledge of each asset. The subscription restrictions and transaction restrictions are automatically brought out. 如請求項4所述之類效率配置估測投資組合的方法,其中,該歷史報酬資料是從該資料庫在上市時間重疊的同一時間段中,擷取各該資產個別對應的一歷史報酬率所獲得。A method for estimating investment portfolios with efficiency allocation as described in claim 4, wherein the historical return data is to extract a historical return rate corresponding to each asset individually from the database in the same time period in which the listing time overlaps. obtained. 如請求項9所述之類效率配置估測投資組合的方法,其中,各該資產所屬的歷史報酬資料,包括年化報酬率和年化標準差,以及各該資產之間的一相關係數與共變數矩陣。A method for estimating investment portfolios with efficiency allocation as described in claim 9, wherein the historical return data of each asset includes annualized return rate and annualized standard deviation, and a correlation coefficient between each asset and Covariable matrix. 如請求項10所述之類效率配置估測投資組合的方法,其中,在該多個投資組合中,以所述預估年化標準差最低的投資組合為符合該第一條件者,且以所述斜率最高的投資組合為符合該第二條件者。A method for efficiently allocating estimated investment portfolios as described in claim 10, wherein among the multiple investment portfolios, the investment portfolio with the lowest estimated annualized standard deviation is the one that meets the first condition, and The investment portfolio with the highest slope is the one that meets the second condition. 一種非暫態電腦可讀取記錄媒體,其儲存多個可執行碼,使一電子裝置於讀取該些可執行碼並執行後,能夠執行以下步驟,包括: 限制條件設定:挑選欲投資的多個資產,並對各該資產設定一符合金額遞增單位的限制條件; 投資組合設定:以若干該資產設定一投資組合,該投資組合包括該若干資產的投資金額,該若干資產的投資金額設定為符合該限制條件; 產生預期報酬資料:在該投資組合中,以該若干資產個別的投資金額佔投資總額的比例計算出投資權重,且該若干資產以個別的投資金額對應自一資料庫擷取的一歷史報酬資料以產生一預期報酬資料,且以該若干資產個別的投資金額佔投資總額的比例計算出投資權重,該預期報酬資料至少包括一預估年化報酬率、一預估年化標準差及一預估年化夏普值; 集合:透過一遞增金額的變化而重覆執行該投資組合設定以及該產生預期報酬資料之步驟,而隨機產生包括多個該投資組合的一集合;以及 類效率配置:以該集合中的預估年化夏普值符合一估測條件的投資組合,估測為類效率配置者。 A non-transitory computer-readable recording medium that stores a plurality of executable codes so that an electronic device can perform the following steps after reading and executing the executable codes, including: Restriction setting: Select multiple assets to invest in, and set a restriction for each asset that meets the incremental unit of amount; Investment portfolio setting: Set up an investment portfolio with a number of the assets, the investment portfolio includes the investment amount of the certain assets, and the investment amount of the certain assets is set to comply with the restriction; Generate expected return data: In the investment portfolio, the investment weight is calculated based on the proportion of the individual investment amount of the certain assets to the total investment, and the individual investment amount of the certain assets corresponds to a historical return data extracted from a database To generate an expected return information and calculate the investment weight based on the proportion of the individual investment amount of certain assets to the total investment. The expected return information at least includes an estimated annualized rate of return, an estimated annualized standard deviation and an estimated annualized standard deviation. Estimated annualized Sharpe value; Collection: Randomly generate a collection of multiple investment portfolios by repeatedly executing the steps of setting up the investment portfolio and generating expected return data by changing an incremental amount; and Class-efficiency allocation: A portfolio whose estimated annualized Sharpe value in the set meets an estimation condition is estimated to be a class-efficiency allocator.
TW111120011A 2022-05-30 2022-05-30 Method and non-transient computer-readable recording medium for estimating portfolio-like efficiency allocation TWI799281B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
TW111120011A TWI799281B (en) 2022-05-30 2022-05-30 Method and non-transient computer-readable recording medium for estimating portfolio-like efficiency allocation

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
TW111120011A TWI799281B (en) 2022-05-30 2022-05-30 Method and non-transient computer-readable recording medium for estimating portfolio-like efficiency allocation

Publications (2)

Publication Number Publication Date
TWI799281B TWI799281B (en) 2023-04-11
TW202347230A true TW202347230A (en) 2023-12-01

Family

ID=86948726

Family Applications (1)

Application Number Title Priority Date Filing Date
TW111120011A TWI799281B (en) 2022-05-30 2022-05-30 Method and non-transient computer-readable recording medium for estimating portfolio-like efficiency allocation

Country Status (1)

Country Link
TW (1) TWI799281B (en)

Family Cites Families (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7249080B1 (en) * 1999-10-25 2007-07-24 Upstream Technologies Llc Investment advice systems and methods
US7162445B2 (en) * 1999-12-30 2007-01-09 Ge Corporate Financial Services, Inc. Methods and systems for quantifying cash flow recovery and risk
US8005740B2 (en) * 2002-06-03 2011-08-23 Research Affiliates, Llc Using accounting data based indexing to create a portfolio of financial objects
TWI470570B (en) * 2012-07-13 2015-01-21 Kuo Tsai Hu An evaluation method for security values, a method for portfolio process to construct the portfolio and a computer program product thereof for storing security information processing program
US20220138280A1 (en) * 2015-01-23 2022-05-05 Locus Lp Digital Platform for Trading and Management of Investment Securities

Also Published As

Publication number Publication date
TWI799281B (en) 2023-04-11

Similar Documents

Publication Publication Date Title
Jansen External finance in Thailand’s development: An interpretation of Thailand’s growth boom
Ismail et al. Labour market competitiveness and foreign direct investment: The case of Malaysia, Thailand and the Philippines
US8311921B2 (en) System and method for dynamic order management
CN107808337A (en) Factor Clustering and device, equipment and storage medium
WO2018184553A1 (en) Insurance calculation method, apparatus, terminal device, and computer-readable storage medium
KR20160111500A (en) Stratified composite portfolios of investment securities
Fernando et al. Does risk management affect on bank efficiency? An analysis of Sri Lankan banking sector
Ashogbon et al. Public Debt, Institutional Quality and Economic Growth: Evidence from Nigeria
US20210073908A1 (en) Systems and computer-implemented processes for occupational risk assessment
CN111680973B (en) Intelligent priority arrangement method for collection task of collection system
TW202347230A (en) Method for estimating portfolio by quasi-efficient allocation and non-transitory computer-readable recording medium performing steps of setting a restriction, setting a portfolio, generating an expected payoff data set, and executing quasi-efficient allocation with an executable code
CN116227958A (en) Method and system for dynamically and quantitatively evaluating offset fund manager based on holding bin and net value
JP2005535977A (en) Snapshot approach to underwrite asset portfolio valuation
Nkalu et al. Trade openness and exchange rate fluctuations nexus in Nigeria
Hörmann et al. When is quantitative easing effective?
WO2019242145A1 (en) Method and device for constructing bond etf, and computer-readable storage medium
CN112508608A (en) Popularization activity configuration method, system, computer equipment and storage medium
Ismail et al. Selecting The Most Significant Determinants that contributes to Islamic banks profitability using Principal Component Analysis
KR20210017053A (en) Method for deriving sales estimating models for individual proprietorship
Cicowiez et al. A Simple Stylized Long-run Growth Model for Haiti
Rifin et al. A Comparative analysis between shariah-compliant & non-Shariah compliant stocks
CN114004703A (en) Macroscopic factor-based quantitative asset configuration system, method, medium, and apparatus
WO2019218518A1 (en) Method and apparatus for constructing bond etf, and computer-readable storage medium
Kaur Decomposition of international economic linkages among top five GDP holder countries’ stock markets after the spread of Covid-19
Timmer et al. GGDC RESEARCH MEMORANDUM 162