作者查詢 / Marty
作者 Marty 在 PTT [ Visual_Basic ] 看板的留言(推文), 共387則
限定看板:Visual_Basic
看板排序:
全部Gossiping26138home-sale2175Stock594Visual_Basic387NTUSTfinM93169Option163HatePolitics132Finance86Militarylife82Trading78car54CFAiafeFSA53Interior47CodeJob43FixMyHouse43L_TalkandCha42HsinTien36Salary32PublicIssue30DigiCurrency29joke29Olympics_ISG26Tech_Job26Google25Broker23Wanhua19ck50th33118E-appliance17Teacher17FuMouDiscuss16Soft_Job14C_Sharp13ntnuepc9111biker10Buddhism9Daan9MobileComm9PublicServan9rent-exp9movie8Anti-ramp7CVS7NTU-Archery7Database6EZsoft6Foreign_Inv6Hsinchu6Kaohsiung6specialman6SuperBike6C_and_CPP5CFantasy5Chiayi5SMSlife5e-coupon4GossipPicket4Hualien4medstudent4PCSH91_3054SENIORHIGH4Storage_Zone4Tainan4tax4A-MEI3Beauty3Examination3EzHotKey3fastfood3FCU-LM100B3ForeignEX3Japan_Travel3kartrider3KS98-3023Lineage3MapleStory3nCoV20193Network3Non-Graduate3NTUSTfinM973tajen3WuLing46-3173CSU2EuropeanCar2Fund2Geography2GetMarry2graduate2IME2KOU2MATLAB2Military2NCCU08FMGRAD2Neihu2NTUfinWork2PC_Shopping2Quant2TAXI2TigerBlue2Violation2WorkinChina2XBOX2AfterPhD1Android1Anti-Cancer1BabyMother1Bank_Service1Baseball1BigSanchung1BikerShop1Biotech1Brethren1calligraphic1ChungLi1Civil1CKSHTalk1Ecophilia1Education1Employee1Eric1Gov_owned1GreenParty1HardwareSale1IA1iOS1Jinmen1KOTDFansClub1KS96-3141L_SecretGard1LAW1Lawyer1License1Lifeismoney1LinKou1Master_D1media-chaos1MIT1MONSTER1NDMC-PH231NSwitch1NTU1NTUCivilism1NTUST-MBA931Old-Games1pighead1PttAntiBot1PttLaw1ScienceNote1sex1SpaceArt1studyteacher1Taipei1Test1TFG05Book1TFSHS61st3211TFSHS68th3161TKU_Talk1<< 收起看板(156)
1F推:格式\設定格式化條件 (不需要用VBA低..XD)07/09 20:19
1F推:VBA裡面是用"Sqr"而不是"Sqrt"...另外用VBA做模擬比較慢..06/20 22:59
2F→:要講究速度的話VBA很難辦到..不如改用Matlab吧..XD06/20 23:00
3F推:感覺好多Magic Number..建議稍為標一下註解和程式想法...^^06/19 11:41
1F推:你的問題應該先朝[怎麼解出IRR]來思考..而不是怎麼寫..^^06/18 21:44
2F→:一般來說解IRR會利用[誤差趨近0]的思考方向來解..06/18 21:45
1F推:int(x)...05/08 09:31
2F推:Matlab榜上無名真令人意外...04/28 11:35
1F推:& "('" & a & "');" <= 你這邊寫錯了..改成這樣就好了..04/24 12:27
2F推:我想你是兩個Sub裡的程式碼用了同一個名稱的變數..03/20 08:32
1F推:他這個找評價的邏輯可能因為網頁格式改了..所以沒用了...03/05 17:24
2F→:把前面找評價的程式碼改一改就可以了..03/05 17:25
3F推:vlookup...02/27 23:19