{"version":"1.0","provider_name":"Fortune Insight","provider_url":"https:\/\/prime.fortuneinsight.com\/web","author_name":"\u9322\u741b","author_url":"https:\/\/prime.fortuneinsight.com\/web\/posts\/author\/chinshun","title":"\u300a\u4ea4\u6613\u601d\u7dad\u300b\u6700\u6709\u6548\u7387\u61c9\u7528\u7a0b\u5f0f\u5de5\u5177\u5230\u4ea4\u6613\u7684\u601d\u7dad - Fortune Insight","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\"><a href=\"https:\/\/prime.fortuneinsight.com\/web\/posts\/525140\">\u300a\u4ea4\u6613\u601d\u7dad\u300b\u6700\u6709\u6548\u7387\u61c9\u7528\u7a0b\u5f0f\u5de5\u5177\u5230\u4ea4\u6613\u7684\u601d\u7dad<\/a><\/blockquote>\n<script type='text\/javascript'>\n<!--\/\/--><![CDATA[\/\/><!--\n\t\t!function(c,d){\"use strict\";var e=!1,n=!1;if(d.querySelector)if(c.addEventListener)e=!0;if(c.wp=c.wp||{},!c.wp.receiveEmbedMessage)if(c.wp.receiveEmbedMessage=function(e){var t=e.data;if(t)if(t.secret||t.message||t.value)if(!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var r,a,i,s=d.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),n=d.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),o=0;o<n.length;o++)n[o].style.display=\"none\";for(o=0;o<s.length;o++)if(r=s[o],e.source===r.contentWindow){if(r.removeAttribute(\"style\"),\"height\"===t.message){if(1e3<(i=parseInt(t.value,10)))i=1e3;else if(~~i<200)i=200;r.height=i}if(\"link\"===t.message)if(a=d.createElement(\"a\"),i=d.createElement(\"a\"),a.href=r.getAttribute(\"src\"),i.href=t.value,i.host===a.host)if(d.activeElement===r)c.top.location.href=t.value}}},e)c.addEventListener(\"message\",c.wp.receiveEmbedMessage,!1),d.addEventListener(\"DOMContentLoaded\",t,!1),c.addEventListener(\"load\",t,!1);function t(){if(!n){n=!0;for(var e,t,r=-1!==navigator.appVersion.indexOf(\"MSIE 10\"),a=!!navigator.userAgent.match(\/Trident.*rv:11\\.\/),i=d.querySelectorAll(\"iframe.wp-embedded-content\"),s=0;s<i.length;s++){if(!(e=i[s]).getAttribute(\"data-secret\"))t=Math.random().toString(36).substr(2,10),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t);if(r||a)(t=e.cloneNode(!0)).removeAttribute(\"security\"),e.parentNode.replaceChild(t,e)}}}}(window,document);\n\/\/--><!]]>\n<\/script><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/prime.fortuneinsight.com\/web\/posts\/525140\/embed\" width=\"600\" height=\"338\" title=\"&#8220;\u300a\u4ea4\u6613\u601d\u7dad\u300b\u6700\u6709\u6548\u7387\u61c9\u7528\u7a0b\u5f0f\u5de5\u5177\u5230\u4ea4\u6613\u7684\u601d\u7dad&#8221; &#8212; Fortune Insight\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe>","thumbnail_url":"https:\/\/prime.fortuneinsight.com\/web\/wp-content\/uploads\/2021\/04\/python_pic.png","thumbnail_width":542,"thumbnail_height":201,"description":"\u4e0d\u5c11\u521d\u5b78\u8005\u958b\u59cb\u63a5\u89f8\u7a0b\u5f0f\u4ea4\u6613\u6642\uff0c\u90fd\u6703\u4ee5\u70ba\u4e00\u5b9a\u8981\u975e\u5e38\u719f\u6089\u67d0\u7a2e\u7279\u5b9a\u7a0b\u5f0f\u8a9e\u8a00\uff0c\u624d\u80fd\u4eab\u53d7\u7a0b\u5f0f\u4ea4\u6613\u7684\u597d\u8655\u3002\u7531\u65bc\u5b78\u7fd2\u7a0b\u5f0f\u8a9e\u8a00\u6709\u4e00\u5b9a\u96e3\u5ea6\uff0c\u800c\u4e14\u9700\u6642\uff0c\u9019\u7a2e\u60f3\u6cd5\u9650\u5236\u4e86\u5f88\u591a\u4eba\u8457\u624b\u7814\u7a76\u9019\u500b\u5c08\u696d\u3002 \u4e0d\u904e\uff0c\u6700\u6709\u6548\u7387\u7684\u601d\u7dad\uff0c\u5fc5\u5b9a\u662f\u5c07\u6240\u6709\u7a0b\u5f0f\u5de5\u5177\uff0c\u5305\u62ec\u6dfa\u767d\u5982\u52b5\u5546\u63d0\u4f9b\u7684\u5206\u6790\u8edf\u4ef6\/excel\uff0c\u5230\u8f03\u8907\u96dc\u7684VBA\/\u539f\u751f\u7de8\u7a0b\u8a9e\u8a00\uff0c\u8996\u70ba\u81ea\u5df1\u53ef\u4ee5\u7528\u7684\u300c\u5175\u5668\u300d\uff0c\u6309\u4e0d\u540c\u60c5\u6cc1\u61c9\u7528\u3002\u6dfa\u6709\u6dfa\u7528\uff0c\u6df1\u6709\u6df1\u7528\uff0c\u4e0d\u5fc5\u9650\u5236\u81ea\u5df1\u53ea\u7740\u773c\u65bc\u539f\u751f\u7de8\u7a0b\u8a9e\u8a00\uff0c\u9019\u6a23\u4f60\u5c31\u53ef\u4ee5\u8f15\u6613\u4eab\u53d7\u5230\u7a0b\u5f0f\u4ea4\u6613\u7684\u597d\u8655\u3002\u4ee5\u4e0b\u6703\u63d0\u4f9b\u4e0d\u540c\u61c9\u7528\u65b9\u5411\u3002 \u4e0d\u77e5\u9053\u5927\u5bb6\u5982\u4f55\u8a55\u6838\u81ea\u5df1\u771f\u5009\u7684\u8868\u73fe\uff1f\u5c07\u6bcf\u6708\u56de\u5831\u6253\u9032excel\uff0c\u518d\u8a08\u7b97Calmar\/Sharpe\uff0c\u7136\u5f8c\u7528excel plot pnl curve\uff1f\u5149\u662fmaintain spreadsheet\u5df2\u5f88\u8cbb\u6642\uff0c\u66f4\u9051\u8ad6\u8981\u6bd4\u8f03\u5be6\u5009\u8207\u57fa\u6e96\u7684\u8868\u73fe\u3002 \u8207\u4e0d\u5c11\u4f7f\u7528IB\u7684\u670b\u53cb\u8a0e\u8ad6\uff0c\u767c\u73fe\u5f88\u591a\u4eba\u90fd\u4e0d\u77e5\u9053IB\u6709portfolio analyst\u529f\u80fd\uff0c\u9664\u4e86\u53ef\u4ee5\u6839\u64da\u81ea\u8a02timeframe\u8a08\u7b97\u5404\u7a2e\u91cf\u5316\u6307\u6a19\uff0c\u4e5f\u53ef\u4ee5\u8207\u4e0d\u540c\u5e02\u5834\u7684\u57fa\u6e96\u4f5c\u51fa\u8a73\u7d30\u6bd4\u8f03\u3002\u8981\u627e\u51fa\u4e26\u719f\u7fd2\u9019\u500b\u529f\u80fd\u96d6\u7136\u8981\u82b1\u9ede\u6642\u9593\uff0c\u4f46\u719f\u7528\u5f8c\u6309\u5e7e\u4e0b\u5c31\u53ef\u4ee5\u5c0d\u81ea\u5df1\u771f\u5009\u7684\u8868\u73fe\u4e00\u89bd\u7121\u907a\uff0c\u63d0\u9ad8\u5206\u6790\u6548\u7387\u3002 \u7b2c\u4e8c\uff0c\u662f\u9032\u884c\u4efb\u4f55\u5206\u6790\u524d\uff0c\u90fd\u61c9\u8a72\u6bd4\u8f03\u90a3\u7a2e\u5de5\u5177\u6700\u6709\u6548\u7387\uff0c\u4e0d\u5fc5\u53ea\u300c\u7528\u6b7b\u300d\u4e00\u7a2e\u5de5\u5177\u3002\u9019\u500b\u601d\u60f3\u6b65\u9a5f\uff0c\u6b63\u6b63\u662fprogrammer\u505atask\u524d\u5fc5\u7d93\u968e\u6bb5\u3002\u4f8b\u5982\u56de\u6e2c\u53c3\u6578\u6578\u91cf\u53ea\u67090-2\u500b\u7684\u7b56\u7565\uff0c\u800c\u5176\u53ef\u5ef6\u4f38\u6027\u53c8\u4e0d\u9ad8\u6642\uff0cexcel\u5f88\u591a\u6642\u6703\u8f03\u5feb\u901f\u3002\u76f8\u53cd\uff0c\u5982\u679c\u7b56\u7565\u6d89\u53ca\u5927\u91cf\u4f86\u81eaAPI\u7684\u6578\u64da\uff0c\u56de\u6e2c\u908f\u8f2f\u53c8\u6bd4\u8f03\u8907\u96dc\u6642\uff0cpython\u5c31\u61c9\u8a72\u6703\u8f03\u65b9\u4fbf\u3002 \u7b2c\u4e09\uff0c\u5982\u8981\u9032\u884c\u7c21\u55ae\u4f46\u91cd\u8907\u6027\u9ad8\u7684\u64cd\u4f5c\uff0c\u4f8b\u5982data cleaning\u4e2d\u7684\u9806\u6642\u6392\u5e8f\u53ca\u79fb\u9664\u932f\u8aa4\u6578\u64da\u9ede\uff0c\u5c31\u53ef\u4ee5\u8003\u616e\u4f7f\u7528VBA macro\u3002\u9019\u5957\u5de5\u5177\u80cc\u5f8c\u4e5f\u662f\u4f7f\u7528VBA\u904b\u4f5c\uff0c\u4f46\u4f60\u4e26\u4e0d\u9700\u8981\u61c2\u5f97VBA\u7de8\u7a0b\u3002\u4f7f\u7528macro recorder\uff0cexcel\u5c31\u6703\u5c07\u4eba\u624b\u64cd\u4f5c\u81ea\u52d5\u8f49\u8b8a\u6210VBA code\u3002\u96d6\u7136\u81ea\u52d5\u751f\u6210\u7684VBA code\u5728\u7de8\u7a0b\u4e0a\u7684\u6548\u7387\u672a\u5fc5\u6700\u9ad8\uff0c\u4f46\u9762\u5c0d\u7c21\u55aetask\u53ef\u8b02\u7dbd\u7dbd\u6709\u9918\u3002\u81ea\u5df1\u7d93\u9a57\u800c\u8a00\uff0c\u7531\u96f6\u5230\u4e00\u5b78\u61c2macro recorder\uff0c\u53ea\u970010-15\u5206\u9418\u3002 \u6700\u5f8c\uff0c\u60f3\u8aaa\u4e00\u500b\u4e0d\u7528\u7de8\u7a0b\u4e5f\u80fd\u4f7f\u7528API\u7684\u4f8b\u5b50\uff0c\u5c31\u662fBinance API\u7684Postman collection\u3002Postman\u662f\u4e00\u500bAPI\u61c9\u7528\u5e73\u53f0\uff0c\u8b93\u7528\u5bb6\u5728\u4e0d\u61c2\u7de8\u7a0b\u7684\u60c5\u6cc1\u4e0b\uff0c\u4e5f\u80fd\u4f7f\u7528\u5176API\u7684feature\uff0c\u5305\u62ec\u7372\u5f97\u865b\u64ec\u8ca8\u5e63\u73fe\u50f9\u3001\u6b77\u53f2\u6578\u64da\u3001\u843d\u76e4\u7b49\u7b49\u3002\u8a73\u7d30\u64cd\u4f5c\u9700\u8981\u8f03\u591a\u6642\u9593\u89e3\u91cb\uff0c\u6709\u6a5f\u6703\u518d\u8a73\u8ff0\u3002 \u7a0b\u5f0f\u4ea4\u6613\uff0c\u4e5f\u53ef\u4ee5\u5f88\u7c21\u55ae\u3002"}