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
on吧?

By Elvira
at 2022-03-31T16:51
at 2022-03-31T16:51
是python確實速度跟程式撰寫的邏輯比較好,如果你願意
兩者結合當然好,但是多半的操作者要開python跟excel要
不覺得麻煩、要不聽到就退縮了

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
能接收老人無限輪迴詢問資料處理的common sense嗎?,
有時候承接也是一種避麻煩,因為金融業的人真的很討厭
變動的

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