Python比VBA更適合做金融報表吧? - 金融業討論
By Regina
at 2022-03-14T18:53
at 2022-03-14T18:53
Table of Contents
陳年報表一點開,常常令人懷疑人生
裡面的VBA比狗屎還亂
令人懷疑最初的撰寫者是否根本沒受過教育
低劣混亂的程式,固然與設計者本身的大腦有關
但蠻大程度也跟VBA的語言特性脫不了關係
VBA沒有python的pandas dataframe
這種對二維數據可以靈活處理的套件
導致跨表操作就像一場悲劇
然而固有的陋習使得VBA在金融業仍然甚囂塵上
個人認為作為excel的原生語言
VBA很適合結合介面,做資料處理結果的呈現
但中間的計算過程,絕對應該用python進行
不知道大家怎麼看
-----
Sent from JPTT on my iPhone
--
Tags:
金融業
All Comments
By Heather
at 2022-03-15T23:51
at 2022-03-15T23:51
By Tracy
at 2022-03-17T04:49
at 2022-03-17T04:49
By Ivy
at 2022-03-18T09:47
at 2022-03-18T09:47
By Anthony
at 2022-03-19T14:45
at 2022-03-19T14:45
By Zora
at 2022-03-20T19:43
at 2022-03-20T19:43
By Gilbert
at 2022-03-22T00:41
at 2022-03-22T00:41
By Emily
at 2022-03-23T05:39
at 2022-03-23T05:39
By Madame
at 2022-03-24T10:37
at 2022-03-24T10:37
By Vanessa
at 2022-03-25T15:35
at 2022-03-25T15:35
By Kristin
at 2022-03-26T20:33
at 2022-03-26T20:33
By Ethan
at 2022-03-28T01:31
at 2022-03-28T01:31
By Harry
at 2022-03-29T06:29
at 2022-03-29T06:29
By Jacky
at 2022-03-30T11:27
at 2022-03-30T11:27
By Linda
at 2022-03-31T16:25
at 2022-03-31T16:25
By Zora
at 2022-03-30T11:53
at 2022-03-30T11:53
By Elvira
at 2022-03-31T16:51
at 2022-03-31T16:51
By Sierra Rose
at 2022-03-30T11:53
at 2022-03-30T11:53
By Linda
at 2022-03-31T16:51
at 2022-03-31T16:51
By Kelly
at 2022-03-30T11:53
at 2022-03-30T11:53
By Iris
at 2022-03-31T16:51
at 2022-03-31T16:51
By Skylar DavisLinda
at 2022-03-30T11:53
at 2022-03-30T11:53
By Emily
at 2022-03-31T16:51
at 2022-03-31T16:51
By Hazel
at 2022-03-30T11:53
at 2022-03-30T11:53
By Suhail Hany
at 2022-03-31T16:51
at 2022-03-31T16:51
By Jacky
at 2022-03-30T11:53
at 2022-03-30T11:53
By Frederic
at 2022-03-31T16:51
at 2022-03-31T16:51
By Agatha
at 2022-03-30T11:53
at 2022-03-30T11:53
By Kristin
at 2022-03-31T16:51
at 2022-03-31T16:51
By Franklin
at 2022-03-30T11:53
at 2022-03-30T11:53
By Bethany
at 2022-03-31T16:51
at 2022-03-31T16:51
By Mason
at 2022-03-30T11:53
at 2022-03-30T11:53
Related Posts
理專挪用款項後失聯 台銀:已移送檢調
By Ivy
at 2022-03-14T18:05
at 2022-03-14T18:05
金融小聚會,有興趣的就來吧!
By Franklin
at 2022-03-14T15:58
at 2022-03-14T15:58
為什麼會讓沒做過業務的當業務主管
By Carol
at 2022-03-13T22:26
at 2022-03-13T22:26
行員在相親市場上握有多少籌碼
By Thomas
at 2022-03-13T15:55
at 2022-03-13T15:55
行員在相親市場上握有多少籌碼
By Christine
at 2022-03-13T12:15
at 2022-03-13T12:15