TWI799281B - Method and non-transient computer-readable recording medium for estimating portfolio-like efficiency allocation - Google Patents

Method and non-transient computer-readable recording medium for estimating portfolio-like efficiency allocation Download PDF

Info

Publication number
TWI799281B
TWI799281B TW111120011A TW111120011A TWI799281B TW I799281 B TWI799281 B TW I799281B TW 111120011 A TW111120011 A TW 111120011A TW 111120011 A TW111120011 A TW 111120011A TW I799281 B TWI799281 B TW I799281B
Authority
TW
Taiwan
Prior art keywords
investment
portfolio
estimated
amount
annualized
Prior art date
Application number
TW111120011A
Other languages
Chinese (zh)
Other versions
TW202347230A (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

本發明提供一種類效率配置估測投資組合的方法,其係由電子裝置以可執行碼執行限制條件設定、投資組合設定、產生預期報酬資料集合,以及類效率配置之步驟,主要以資產的投資金額在符合一限制條件下隨機產生多個投資組合而為集合,並以集合中的預估年化夏普值符合一估測條件的投資組合,以其估測為類效率配置者,俾供作為選擇投資組合時之參考依據。本發明也提供一種非暫態電腦可讀取記錄媒體,能夠被讀取以執行上述方法。The present invention provides a method for estimating an investment portfolio by class-efficiency allocation, which uses executable codes to execute the steps of restriction condition setting, investment portfolio setting, generation of expected return data set, and class-efficiency allocation, mainly based on the investment of assets A collection of multiple investment portfolios is randomly generated when the amount meets a restriction condition, and the estimated annualized Sharpe value in the collection meets an estimation condition, and the estimation is used as a class efficiency allocator for use as The reference basis for selecting investment portfolios. The present invention also provides a non-transitory computer-readable recording medium capable of being read to perform the above method.

Description

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

本發明係關於一種投資組合的估測方法,尤指一種類效率配置估測投資組合的方法,及能夠執行該方法的非暫態電腦可讀取記錄媒體。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 conventional investment portfolios lies in that a portfolio contains multiple assets (such as stocks, bonds...), assuming that the sum of the investment proportions of these multiple assets is 1 (and does not use short-selling as an operation), through mean-difference optimization (Mean-Variance Optimization) Find the same expected rate of return and the least risky investment portfolio among multiple investment portfolios. Each investment portfolio found has the following two characteristics: 1. When the expected rate of return is fixed, Minimize risk (standard deviation). 2. With the risk (standard deviation) fixed, the expected rate of return can be maximized.

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

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

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

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

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

本發明並提供一種非暫態電腦可讀取記錄媒體,其儲存多個可執行碼,使一電子裝置於讀取該些可執行碼並執行後,能夠執行上述方法。The present invention also provides a non-transitory computer-readable recording medium, which 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 step of aggregating, a step of calculating the slope is further included, which is to sort the estimated annualized standard deviations of the multiple investment portfolios according to the estimated annualized standard deviations in accordance with The investment portfolio of a first-condition person is an initial benchmark point, and the estimated annualized rate of return and estimated annualized standard deviation of the remaining investment portfolios and the estimated annualized rate of return and estimated annualized rate of return corresponding to the initial benchmark point The slope calculated by normalizing the standard deviation, and then sorting each of the slopes, so as to obtain the investment portfolio whose slope meets a second condition from the plurality of investment portfolios, which is deemed to meet the estimation condition.

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

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

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

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

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

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

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

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

為充分瞭解本發明之目的、特徵及功效,茲藉由下述具體之實施例,並配合所附之圖式,對本發明做一詳細說明,說明如後:In order to fully understand the purpose, features and effects of the present invention, the present invention will be described in detail through the following specific embodiments and 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 for efficiency allocation, which is executed by an electronic device (not shown in the figure) with a plurality of executable codes, and please refer to FIG. 1 , the method 100 includes setting constraints 101. The steps of investment portfolio setting 102, generation of expected return data 103, collection 104, calculation of slope 105, loop operation 106, and class efficiency allocation 107 are executed, wherein:

所述限制條件設定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 conditions 101 is to select a plurality of assets to be invested, and to set a restriction condition for each of the assets that meets the increasing amount unit. The assets mentioned can be funds, stocks or bonds, but are not limited thereto. The incrementing unit of the amount mentioned above is the incrementing amount unit of the investment amount of the assets mentioned above, which can be directly put into the market for subscription without further conversion or processing (such as rounding or unconditional rounding down, etc.). In this embodiment, the multiple assets to be invested are selected from the three funds of Fund A, Fund B, and Fund C shown in Table 1, but the present invention is not limited to the three funds mentioned above. 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 Calculation 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 of each asset in each investment portfolio. In one embodiment, the upper limit of the investment amount is set by 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 (for example, announced by a stock exchange company) limit) and automatically brought out. The upper limit of the investment amount is used to determine the maximum amount to be invested in the transaction for each asset in each of the generated investment portfolios (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 investment portfolio 102 is to set up an investment portfolio with several assets, the investment portfolio includes the investment amount of the several assets, and the investment amount of each asset is set to meet the restriction condition. For example, the investment portfolio shown in Table 1 is a combination of three funds, including Fund A, Fund B, and Fund C. Both are 1,000 yuan, and the incremental amount is 1,000 yuan (thousand yuan) as the unit, and the difference in the incremental amount is used to generate a range that satisfies 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 one investment portfolio, the investment amounts of Fund A, Fund B, and Fund C are respectively set at 1,000 yuan, 5,000 yuan, and 3,000 yuan. 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 that in the investment portfolio, the individual investment amounts of the assets correspond to a historical return data extracted from a database to generate an expected return data. The database can be Cloud server, or the local server of the electronic device.

於一實施例中,該預期報酬資料如表2所示,包括一預估年化標準差、一預估年化夏普值,以及一預估年化報酬率,其中的預估年化夏普值是依據對應的預估年化標準差和預估年化報酬率所計算獲得,計算過程並考慮無風險利率,於此實施例中預設為1.5%(計算公式:夏普值=(報酬率-無風險利率)/標準差)。於此步驟中,並以該若干資產個別的投資金額佔投資總額的比例計算出投資權重。In one embodiment, the expected return data is shown in Table 2, including an estimated annualized standard deviation, an estimated annualized Sharpe value, and an estimated annualized rate of return, wherein 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 takes into account the risk-free interest rate, which is preset at 1.5% in this example (calculation formula: Sharpe value = (rate of return - risk-free rate)/standard deviation). In this step, the investment weight is calculated based on the ratio of the individual investment amount of the 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 standard deviation is 7.323, the estimated annualized rate of return is 11.781, and the estimated annualized Sharpe value is 1.404 (see also Group 1 in Table 2). Table 2 (Expected Compensation Information) Fund A Fund B Fund C Estimated Annualized Standard Deviation Estimated Annualized Rate of 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 by extracting a historical return rate corresponding to each of the assets from the database in the same time period when the listing time overlaps. As shown in Table 1, the same time period in which the listing time overlaps is based on 2021/1/1~2021/12/31 as the data calculation interval, but it is not limited to the time period in this example. The same time period Can be longer or shorter as long as time to market overlaps. As shown in Table 3, the historical return data includes historical daily return rates of Fund A, Fund B and Fund C, but the present invention is not limited thereto. Table 3 (historical daily rate of return) date Fund A Fund B Fund C 2021/1/1 0 0 0 1/4/2021 -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 return rates (as shown in Table 3), and further include rate of return, standard deviation, annualized rate of return and annualized rate of return. 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 a set 104 is to repeatedly execute the step of setting the investment portfolio through incremental changes in the amount, and randomly generate a set including a plurality of the investment portfolios. In one embodiment, the random generation of the plurality of investment combinations is performed by using an application program on a computer, but the present invention is not limited thereto. As shown in Table 5, a collection of 20 investment portfolios including groups 1-20 is randomly generated, and Fund A, Fund B, and Fund C of each investment portfolio are all in line with the aforementioned upper limit of investment amount (5,000 yuan) and investment amount The lower limit (1,000 yuan), and the condition that 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 estimated annualized standard deviations of the multiple investment portfolios, and use the investment portfolio whose estimated annualized standard deviation meets a first condition as an initial reference 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 , and its "estimated annualized standard deviation" is 2.266, which is the lowest in the set.

承上,接著再依其餘投資組合的預估年化報酬率與預估年化標準差,與該初始基準點對應之預估年化報酬率與預估年化標準差計算出的斜率,再對各該斜率進行大小的排序,以從該多個投資組合中獲得所述斜率最高者,符合一第二條件,例如圖2之座標中,標示為(X2,Y2)所屬之投資組合,其組別12的斜率1.963為最高(併參表6之當前組別12的當前預估年化標準差2.266、當前預估年化報酬率5.130,以及當前組別的斜率1.963)。Carrying on from the above, and then based on the estimated annualized rate of return and estimated annualized standard deviation of the rest of the investment portfolio, the slope calculated from the estimated annualized rate of return and estimated annualized standard deviation corresponding to the initial benchmark point, and then Sorting the magnitude of each of the slopes, so as to obtain the highest slope from the plurality of investment portfolios, which meets a second condition, for example, in the coordinates of Figure 2, the investment portfolio marked as (X2, Y2) belongs to it. 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 rate of 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 as an updated reference point among the plurality of investment portfolios (in this way, the updated reference point replaces the initial reference point as a new reference point ), and delete the one with the lower rate of return to update the set, and then return to the step of calculating the slope to obtain the next investment portfolio condition with the highest slope. The person who meets the second condition, in addition to the investment portfolio with the highest slope mentioned above, may further be the person whose estimated annualized standard deviation is lower than the slope and meets the second condition, and the estimated annualized return The one whose rate of return is higher than the slope and meets the second condition is the one with the lower rate of return, so as to be removed 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 as the basis of 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, according to the investment portfolios of groups 1-20, the steps of the loop operation 106 are performed five times in total, and the results are represented by point numbers 1-5 of the leading edge in Table 6 respectively. The point number 1 of the leading edge line is based on the minimum estimated annualized standard deviation of group 12 as the initial reference point, and then compares the slope with the other groups, among which group 20 has the largest slope of 1.963. Next, among groups 1 to 19, those whose estimated annualized standard deviation and estimated annualized rate of return are both lower than group 20 (i.e. group 6, group 12, and group 15 are excluded), Change to group 20 with the largest slope as the first update reference point, and then compare the slope with the remaining groups after elimination, and so on, to obtain the second update with group 11 having the largest slope The reference point, the third updated reference point with group 1 having the largest slope, and the fourth updated reference point with group 16 having the largest slope, so as to obtain group 12, group 20, group Point numbers 1~5 of the five leading edge lines 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 Rate of 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 the quasi-efficiency allocation 107 is estimating the portfolios that meet an estimation condition with the estimated annualized Sharpe value in the set as quasi-efficiency allocators. In one embodiment, in the step of this type of efficiency configuration, the slopes corresponding to the initial reference point and at least one update reference point are sorted from high to low, and the one with the highest estimated annualized Sharpe value is regarded as to meet the estimation criteria. According to the initial benchmark point and the four updated benchmark points, the corresponding group/estimated annualized Sharpe values shown in Table 7 are Group 20/1.702, Group 12/1.602, Group 11/1.576, Class 1/1.404, and Class 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 this type of efficiency configuration 107, the initial reference point and four update reference points corresponding to the aforementioned group 1, group 11, group 12, group 16, and group 20, Based on this, a type of efficiency frontier curve (as shown in Figure 3) is drawn, and the one with the highest annualized Sharpe value in this type of efficiency frontier curve, in this example, is the investment portfolio of group 20. to meet the estimated conditions. Table 7 (data corresponding to each group point in the class efficiency frontier curve) group Estimated Annualized Standard Deviation Estimated Annualized Rate of 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 rate point 0 1.5

本發明並提供一種非暫態電腦可讀取記錄媒體,其儲存多個可執行碼,使所述電子裝置於讀取該些可執行碼並執行後,能夠執行上述方法。The present invention also provides a non-transitory computer-readable recording medium, which 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-mentioned embodiment is listed and described as follows with its virtual code (Pseudo Code) here: " begin //Start Initialize FundsSet.InvAmt; //Set the upper limit, lower limit, and incremental amount of each fund in the investment portfolio Initialize FundsSet.HisReturn; //Get the historical rate of return data of each fund in the investment portfolio Function calFundsExpectReturnRisk(FundsSet ){ //Get the same or longer/shorter time period of the historical rate of return data in the above funds GetCommonHisReturnLength(FundsSet.HisReturn); //Calculate the estimated annualized rate of 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); //Obtain a set of investment amount allocation randomly within the upper limit and lower limit of the investment amount of each fund AllocationInPercentSet = AllocationInPercent(RandmAmtSet); //According to the allocation amount of each fund above, calculate the total investment portfolio, and the individual weights of each fund in the investment portfolio Portolio.ExpectReturnRisk = CalPortfolio ExpectReturnRisk(AllocationInPercentSet);// Calculate the estimated annualized return of the investment portfolio according to the weight of each fund Rate and estimated annualized standard deviation PortfolioSet = AddPortofolio(Portolio);//Add to the set of investment portfolio end forLowestRisk = SortPortfolioRisk(PortfolioSet);//Sort the estimated annualized standard deviation of each portfolio and get the smallest one as the initial Benchmark; CalPortfolioSharpRatio; (PortfolioSet);//Calculate the estimated annualized Sharpe value of all portfolios SortPortfolioSharpRatio; (PortfolioSet);//Get the estimated annualized Sharpe value by sorting and get the largest point IniPoint = LowestRisk;/ / Portfolio with the smallest estimated annualized standard deviation in the portfolio as the initial benchmark point N = PortfolioSet; // Number of portfolios included for I = 0 & I < N; // Loop operation N times HighSlopPortfolio = CalHighSlop(IniPoint, PortfolioSet); //Get the points of all other portfolios whose estimated annualized rate of return and estimated annualized standard deviation are greater than the initial benchmark point, and calculate the slope of these points, and sort the slope values to obtain the slope The largest portfolio IniPoint = HighSlopPortfolio;//The point with the largest slope above is the update reference point of the portfolio PortfolioSet = PickHigherSlopExpectReturnLowerRisk(PortfolioSet); //Exclude all other low slopes, and the estimated annualized standard deviation and estimated year All portfolio points with lower rate of return, create a new portfolio collection The values of standard deviation and estimated annualized rate of return are sorted from small to large DrawQuasiEfficientFrontier(PortfolioSet);//Draw QuasiEfficientFrontier(PortfolioSet);//Draw the quasi-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 not difficult to find that the characteristics of the present invention lie in the method of the present invention for quasi-efficiency allocation and estimation of the investment portfolio, and the non-transient computer-readable recording medium. Through the setting of the investment portfolio, the investment amount of the assets must meet the The increment unit of the amount is the restriction condition, and then refer to the historical return data to generate the expected return data as the estimation basis, and through repeated execution, in the set of randomly generated investment portfolios, the annualized Sharpe value is estimated to meet the estimation conditions. The combination is a quasi-efficient allocator, thereby producing a portfolio result that is close to efficient allocation, and since the investment amount conforms to the incremental amount at the time of the transaction, the resulting portfolio can be directly put into the trading market for subscription, so as to achieve the investment portfolio Estimation results are more intuitive and more efficient.

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

100:方法 101:限制條件設定 102:投資組合設定 103:產生預期報酬資料 104:集合 105:計算斜率 106:迴圈運算 107:類效率配置100: method 101: Restriction setting 102:Portfolio Setup 103: Generate expected remuneration data 104: collection 105: Calculate the slope 106: Loop operation 107:Class Efficiency Configuration

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

100:方法 100: method

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

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

103:產生預期報酬資料 103: Generate expected remuneration data

104:集合 104: collection

105:計算斜率 105: Calculate the slope

106:迴圈運算 106: Loop operation

107:類效率配置 107:Class Efficiency Configuration

Claims (12)

一種類效率配置估測投資組合的方法,其係由一電子裝置以多個可執行碼所執行,所述方法包括: 限制條件設定:挑選欲投資的多個資產,並對各該資產設定一符合金額遞增單位的限制條件; 投資組合設定:以若干該資產設定一投資組合,該投資組合包括該若干資產的投資金額,該若干資產的投資金額設定為符合該限制條件; 產生預期報酬資料:在該投資組合中,以該若干資產個別的投資金額佔投資總額的比例計算出投資權重,且該若干資產以個別的投資金額對應自一資料庫擷取的一歷史報酬資料以產生一預期報酬資料,且以該若干資產個別的投資金額佔投資總額的比例計算出投資權重,該預期報酬資料至少包括一預估年化報酬率、一預估年化標準差及一預估年化夏普值; 集合:透過一遞增金額的變化而重覆執行該投資組合設定以及該產生預期報酬資料之步驟,而隨機產生包括多個該投資組合的一集合;以及 類效率配置:以該集合中的預估年化夏普值符合一估測條件的投資組合,估測為類效率配置者。 A method for estimating investment portfolio efficiency allocation, which is executed by an electronic device with a plurality of executable codes, the method includes: Restriction setting: select multiple assets to invest in, and set a restriction that meets the amount increment unit for each asset; Investment portfolio setting: setting up an investment portfolio with certain assets, the investment portfolio includes the investment amount of the certain assets, and the investment amount of the certain assets is set to meet the restriction; Generating expected return data: In the investment portfolio, the investment weight is calculated based on the ratio 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 data, and calculate the investment weight based on the ratio of the individual investment amount of the certain assets to the total investment, the expected return data includes at least an estimated annualized rate of return, an estimated annualized standard deviation, and an estimated estimated annualized Sharpe value; Aggregation: Repeating the steps of setting the investment portfolio and generating the expected return data by changing an incremental amount, and randomly generating a set including a plurality of the investment portfolios; and Class-efficiency allocation: The investment portfolio whose estimated annualized Sharpe value in this set meets an estimation condition is estimated as a class-efficiency allocator. 如請求項1所述之類效率配置估測投資組合的方法,其中該集合之步驟後,更包括一計算斜率之步驟,係按該多個投資組合的預估年化標準差進行大小的排序,以所述預估年化標準差符合一第一條件的投資組合為一初始基準點,並依其餘投資組合的預估年化報酬率與預估年化標準差與該初始基準點對應之預估年化報酬率與預估年化標準差計算的斜率,再對各該斜率進行大小的排序,以從該多個投資組合中獲得所述斜率符合一第二條件的投資組合,視為符合該估測條件。The method for estimating investment portfolios for efficiency allocation as described in Claim 1, wherein after the step of aggregating, further includes a step of calculating the slope, which is sorted according to the estimated annualized standard deviations of the multiple investment portfolios , taking the investment portfolio whose estimated annualized standard deviation meets a first condition as an initial benchmark point, and according to the estimated annualized rate of return and estimated annualized standard deviation of the remaining investment portfolios corresponding to the initial benchmark point Calculate the slope of the estimated annualized rate of return and the estimated annualized standard deviation, and then sort the slopes in order to obtain a portfolio whose slope meets a second condition from the multiple investment portfolios, which is regarded as meet the estimation criteria. 如請求項2所述之類效率配置估測投資組合的方法,其中該計算斜率之步驟後,更包括一迴圈運算之步驟,係該多個投資組合中,剔除報酬率較低於符合該第二條件之斜率者以更新該集合,並以斜率符合該第二條件的投資組合為一取代該初始基準點的更新基準點,再回到該計算斜率之步驟,以獲得下一個斜率符合該第二條件的投資組合。The method for estimating investment portfolios for efficiency allocation as described in claim 2, wherein after the step of calculating the slope, a step of circle calculation is further included, which is to eliminate the returns that are lower than those that meet the multiple investment portfolios For the slope of the second condition, update the set, and use the portfolio whose slope meets the second condition as an updated reference point to replace the initial reference point, and then return to the step of calculating the slope to obtain the next slope meeting the Portfolio for the second condition. 如請求項3所述之類效率配置估測投資組合的方法,其中,在該類效率配置之步驟中,將該初始基準點以及至少一該更新基準點所對應的斜率之投組進行高低的排序,並以其中的預估年化夏普值最高者,視為符合該估測條件。The method for estimating investment portfolios for efficiency allocation as described in claim item 3, wherein, in the step of this type of efficiency allocation, the initial benchmark point and at least one investment group corresponding to the slope corresponding to the updated benchmark point are adjusted for high and low Sort, and the one with the highest estimated annualized Sharpe value is considered to meet the estimation conditions. 如請求項4所述之類效率配置估測投資組合的方法,其中,在該類效率配置之步驟中,將該初始基準點以及至少一該更新基準點繪製出一類效率前緣曲線,以該類效率前緣曲線中的預估年化夏普值最高者,視為符合該估測條件。The method for estimating investment portfolios of efficiency allocation as described in claim item 4, wherein, in the step of allocation of such efficiency, a type of efficiency frontier curve is drawn from the initial reference point and at least one update reference point, and the The one with the highest estimated annualized Sharpe value in the class-efficiency frontier curve is deemed to meet the estimation condition. 如請求項5所述之類效率配置估測投資組合的方法,其中,在該迴圈運算之步驟中,以該預估年化標準差與該預估年化報酬率皆低於所述斜率符合該第二條件者,為從該集合中剔除之投資組合。The method for estimating investment portfolios for efficient allocation as described in claim item 5, wherein, in the step of the loop operation, the estimated annualized standard deviation and the estimated annualized rate of return are both lower than the slope Those that meet the second condition are investment portfolios excluded from the collection. 如請求項4所述之類效率配置估測投資組合的方法,其中,該投資金額為各該投資組合內各該資產的一投入金額上限、一投入金額下限,以及該遞增金額。The method for estimating investment portfolios for efficiency allocation 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 of each asset in each investment portfolio. 如請求項7所述之類效率配置估測投資組合的方法,其中,該投入金額上限,是由一輸入介面之輸入而設定;該投入金額下限與該遞增金額,係依各該資產所知的申購限制及交易限制而自動帶出。The method for estimating investment portfolios for efficiency allocation as described in claim item 7, wherein the upper limit of the investment amount is set by an input interface; the lower limit of the investment amount and the incremental amount are known according to each asset The subscription limit and transaction limit are automatically brought out. 如請求項4所述之類效率配置估測投資組合的方法,其中,該歷史報酬資料是從該資料庫在上市時間重疊的同一時間段中,擷取各該資產個別對應的一歷史報酬率所獲得。The method for estimating investment portfolios for efficiency allocation as described in claim item 4, wherein the historical return data is extracted from the database in the same time period when the listing time overlaps, and a historical rate of return corresponding to each asset is individually extracted acquired. 如請求項9所述之類效率配置估測投資組合的方法,其中,各該資產所屬的歷史報酬資料,包括年化報酬率和年化標準差,以及各該資產之間的一相關係數與共變數矩陣。As described in claim item 9, the method for estimating investment portfolios for efficiency allocation, wherein, the historical return data to which each asset belongs includes annualized rate of return and annualized standard deviation, and a correlation coefficient between each asset and covariate matrix. 如請求項10所述之類效率配置估測投資組合的方法,其中,在該多個投資組合中,以所述預估年化標準差最低的投資組合為符合該第一條件者,且以所述斜率最高的投資組合為符合該第二條件者。The method of efficiency allocation estimation investment portfolio as described in claim item 10, wherein, among the plurality of 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 meeting the second condition. 一種非暫態電腦可讀取記錄媒體,其儲存多個可執行碼,使一電子裝置於讀取該些可執行碼並執行後,能夠執行以下步驟,包括: 限制條件設定:挑選欲投資的多個資產,並對各該資產設定一符合金額遞增單位的限制條件; 投資組合設定:以若干該資產設定一投資組合,該投資組合包括該若干資產的投資金額,該若干資產的投資金額設定為符合該限制條件; 產生預期報酬資料:在該投資組合中,以該若干資產個別的投資金額佔投資總額的比例計算出投資權重,且該若干資產以個別的投資金額對應自一資料庫擷取的一歷史報酬資料以產生一預期報酬資料,且以該若干資產個別的投資金額佔投資總額的比例計算出投資權重,該預期報酬資料至少包括一預估年化報酬率、一預估年化標準差及一預估年化夏普值; 集合:透過一遞增金額的變化而重覆執行該投資組合設定以及該產生預期報酬資料之步驟,而隨機產生包括多個該投資組合的一集合;以及 類效率配置:以該集合中的預估年化夏普值符合一估測條件的投資組合,估測為類效率配置者。 A non-transitory computer-readable recording medium, which 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 that meets the amount increment unit for each asset; Investment portfolio setting: setting up an investment portfolio with certain assets, the investment portfolio includes the investment amount of the certain assets, and the investment amount of the certain assets is set to meet the restriction; Generating expected return data: In the investment portfolio, the investment weight is calculated based on the ratio 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 data, and calculate the investment weight based on the ratio of the individual investment amount of the certain assets to the total investment, the expected return data includes at least an estimated annualized rate of return, an estimated annualized standard deviation, and an estimated estimated annualized Sharpe value; Aggregation: Repeating the steps of setting the investment portfolio and generating the expected return data by changing an incremental amount, and randomly generating a set including a plurality of the investment portfolios; and Class-efficiency allocation: The investment portfolio whose estimated annualized Sharpe value in this set meets an estimation condition is estimated as 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 true TWI799281B (en) 2023-04-11
TW202347230A 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)

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1437736A (en) * 1999-12-30 2003-08-20 Ge资本商业财务公司 Method and systems for quantifying cash flow recovery and risk
US7249080B1 (en) * 1999-10-25 2007-07-24 Upstream Technologies Llc Investment advice systems and methods
TW200844894A (en) * 2007-03-23 2008-11-16 Res 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

Patent Citations (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
CN1437736A (en) * 1999-12-30 2003-08-20 Ge资本商业财务公司 Method and systems for quantifying cash flow recovery and risk
TW200844894A (en) * 2007-03-23 2008-11-16 Res 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
TW202347230A (en) 2023-12-01

Similar Documents

Publication Publication Date Title
Brumm et al. Using adaptive sparse grids to solve high‐dimensional dynamic models
CN109063945B (en) Value evaluation system-based 360-degree customer portrait construction method for electricity selling company
AU2019101760A4 (en) Stratified composite portfolios of investment securities
CN103927615B (en) Entity is associated with classification
US8583530B2 (en) Code generation based on spreadsheet data models
Obadan Direct foreign investment in Nigeria: An empirical analysis
US20150039533A1 (en) System and methods to provide for and communicate about safer and better returning asset-liability investment programs
JP2013080456A (en) System, method, and program for enterprise evaluation
CN107808337A (en) Factor Clustering and device, equipment and storage medium
Saleena Impact of FDI on services export: Evidence from India
Mukarati et al. Land redistribution and the South African economy
TWI799281B (en) Method and non-transient computer-readable recording medium for estimating portfolio-like efficiency allocation
Ferreira et al. Parallel moeas for combinatorial multiobjective optimization model of financial portfolio selection
CN116227958A (en) Method and system for dynamically and quantitatively evaluating offset fund manager based on holding bin and net value
Dang et al. Dynamic importance allocated nested simulation for variable annuity risk measurement
TWM628128U (en) Customer value two-dimensional exploration system
Wang et al. A new dynamic hedging model with futures: The Kalman filter error-correction model
WO2019242145A1 (en) Method and device for constructing bond etf, and computer-readable storage medium
Cicowiez et al. A Simple Stylized Long-run Growth Model for Haiti
TWI809649B (en) Two-dimensional Exploration Method and System of Customer Value
JP2003058700A (en) Optimizing method for debenture portfolio and its program
Dao et al. Cluster Analysis of Vietnamese Banks on Efficiency and Performance
Timmer et al. GGDC RESEARCH MEMORANDUM 162
CN114004703A (en) Macroscopic factor-based quantitative asset configuration system, method, medium, and apparatus
Heidarpour et al. A new Keynesian framework for monetary policy analysis in Iran’s economy. A dynamic stochastic general equilibrium approach