外幣投資輔助系統設計與實作

目前國內各家銀行都會開設網路銀行，可以在網路上進行大部分和到實體銀行一樣的交易，也許功能上會稍微有些侷限，不過隨著開設網路銀行帳戶的客戶增加，現在網路銀行也成為銀行業者主要的服務業務了，經由充分的授權，我們可以透過網路銀行來進行各項交易活動。不過目前銀行業者在網路銀行上所提供給客戶關於外匯的資訊並不是很充裕，僅有目前牌告匯率與歷史匯率的資料，這對於希望有更多資訊來做出投資買賣判斷的客戶所提供是不足的，尤其財經變化是瞬息萬千的，如果沒有足夠及時的資訊那等於是盲目的投資。我們希望利用網際網路的便利來幫助投資者在外幣投資的時候能有更精確的判斷，如此可以在資訊更加豐富的環境下做出更明確的投資決策，當然沒有不存在風險的投資理財方式，不過我們希望可以在投資輔助系統的幫助下，因為掌握了能做出更多有利決策的資訊而可以讓風險降低，如此可以成為日漸風行的投資外幣理財管道利器。我們把系統設計成數個模組，這些模組都是以Microsoft Excel 2003搭配內建的VBA(Visual Basic for Application)開發而成，這些模組的資料前端來源都是web base架構，也就是我們先利用Excel VBA寫成的程式來抓取網路銀行或是財金網站所提供的匯率資料，然後先把抓取的資料儲存在Excel裡面，然後再進行資料探勘等分析，以提供使用者買賣的資訊。

關鍵字

網路銀行；投資輔助系統；外匯

並列摘要

Nowadays, most banks set up network bank to provide transaction services which traditional banks provide. The function of network bank may be a little restricted. However, with the increasing amount of accounts, the network bank has become authorities' main affair. Through sufficient authorization, we can proceed with various transactions on network bank. Nevertheless, the bank authorities do not supply enough information about foreign exchange, only present Exchange Rate and historical data are provided. It is quite insufficient for the accounts that need more information to make investment decision. Without enough immediate information would lead investor's blind investment, especially under the financial statement varying from minute to minute. We expect to assist investors in making more accurate decision by plentiful information on internet. There is certainly no investment without risk; it is hopefully for the investor making more beneficial decision and decrease risk under the investment assistant system. We design several modules with the system. These modules are developed by Microsoft Excel 2003 with built-in VBA (Visual Basic for Application). The information comes from web base; that means we utilize the program written by excel VBA to collect Exchange Rate information form bank or financial website. Then excel can proceed data mining to provide the user with agiotage information.