ããå¦ä½æ¯è¾åç§äº¤ææ¹æ³çä¼å£ï¼å¹¶ä¸æ¯åæç人ææ³çé£æ ·ï¼åªç§æä½ææ³çåæ¥çé«ãåªç§å°±æ¯æ好ãæ个æ¯æ¹æ¥è¯´ï¼å¼æè´§åºèµå°çäºååé±åå»èµåºèµå°çä¸ä¸åé±æ§è´¨å®å
¨ä¸åï¼ä¸ä¸ªå
·æå¯éå¤æ§ï¼å¦ä¸ä¸ªå ä¹å
¨åè¿æ°ã
ããæ以æè¿ä¹ä¸ç§è¯´æ³ï¼å¥½çæèµå°±æ¯ç¨å°½å¯è½å°çé£é©å»è·å¾å°½å¯è½å¤§çå©æ¶¦ãå¨ä¸ä¸çæèµé¢åéï¼æ¯ç¨å¤æ®æ¯çï¼
Sharpe Ratioï¼æ¥æ¯è¾åç§æèµæ¹æ³çç»æçã
ããå¤æ®æ¯çç计ç®å
¬å¼æ¯ï¼
ããå¤æ®æ¯ç = å®é
åæ¥ç / åæ¥çç
æ åå·®ããSharpe ratio = Excess return / Standard deviation
ããé¦å
å¨ Excel è¡¨æ ¼éååºæ¯å¹´ï¼ææ¯ä¸ªæï¼çæ¶ççï¼ç¶ååå»åä¸æ¶ææ é£é©èµäº§ï¼æ¯å¦çæèé¦åºå¸ï¼çæ¶ççï¼å¾åºæ¥çæ¯è¶
è¿æ é£é©æ¶ççååæ¥çã
ããå¾åºçååæ¥çåç¨ Excel è¡¨æ ¼çå
¬å¼è®¡ç®åºä¸¤ä¸ªæ°æ®ï¼
ããä¸ä¸ªæ¯å¹³åååæ¥çï¼è®¡ç®å
¬å¼æ¯ Averageï¼D6ï¼D15) = 15.1%
ããå¦ä¸ä¸ªæ¯ååæ¥ççæ åå·®ï¼è®¡ç®å
¬å¼æ¯ STDEV(D6:D15) = 9.2%
ããæåæå¹³åååæ¥çé¤ä»¥å
¶æ åå·®å¾åºçæ¯å¼å°±æ¯å¤æ®æ¯çï¼ Average / STDEV = 1.64
ããå¤æ®æ¯çè¶å¤§ï¼å°±è¯´æè·å¾åæ ·
æèµæ¶çççæ³¢å¨æ§æ¯è¾å°ï¼ä¹æå³ç
æèµåæ¥ççå¯å¤å¶æ§ä¹è¶é«ã