Using the Internet as a Data Source

The classic Excel application has two sources of data — databases on the network, and the user. If an item of data was not available in a database, the user was required to type it in and maintain it. To enable this, the application had to include a number of sheets and dialogs to store the information and provide a mechanism for the data entry.

A typical example of this would be maintaining exchange rate information in a financial model; it is usually the user's responsibility to obtain the latest rates and type them into the model. You can add value to the application by automating the retrieval of up-to-date exchange rate information from one of many web sites.

The following sections demonstrate different techniques for retrieving information from the web, using the USD exchange rates available from www.x-rates.com/d/USD/table.html (see Figure 24-1) as an example.

Exchange Rates Table lor An i Dollar, U.S.A. - Microsoft Internet Explorer

File Edit View Favorites Tools Help

! http : //yvw w. x-ra tes, com/d/USD/table, html ca • Ü

Menu

, Currency Calculator , Custom Table , Historic Lookup , Currency Photos . Home

News & Quotes

. Executable Quotes , Forex Market News . Currency Forecasts

Currency Trading

. Why Trade Currency?

. What Moves Rates? . How to get started? . The ¿300 Mini Acct . Free Practice Acct

Services

. Currency Trading Course

Menu

, Currency Calculator , Custom Table , Historic Lookup , Currency Photos . Home

American Dollar

H Irk' an values to graphs

1 USD

in USD

Australian Dollar

1.29752

0.770701

Brazilian Real

2,1428

0.466679

British Pound

0.524742

1.9057

Canadian Dollar

1.1275

0.B86918

Chinese Yuan

7.8651

0.127144

Danish Krone

5,8362

0.171344

Eufo

0.782779

1.2775

Hong Kong Dollar

7.7838

0.128472

Indian Rupee

44.59

0.0224266

Japanese Yen

117.74

0.00349329

Malaysian Rjnggit

3.64

0.274725

Mexican Peso

10,866

0,0920302

New Zeafand Doliar

1.49678

0.668101

Norwegian Kroner

6,4518

0.154996

Singapore Dollar

1.5603

0.640902

South African Rartd

7,2925

0.137127

South Korean Won

934.7

0.00106986

Sri Lanka Rupee

107,15

0.00933271

Swedish Krona

7.1451

0.139956

Swiss Franc

1,2494

0.B00384

Taiwan Dollar

32.85

0.0304414

Thai Baht

36,68

0.0272628

Venezuelan Bolivar

2144.6

. American Dollar . Argentine Peso . Australian Dollar . Botswana Pula . Brazilian Real . British Pound . Canadian Dollar

Chili

Currency

. American Dollar . Argentine Peso . Australian Dollar . Botswana Pula . Brazilian Real . British Pound . Canadian Dollar

Chili i Pese

Chin« Colombian Peso Danish Krone Euro

Hong Kong Dollar Hungarian Forint Iceland Krona Indian Rupee Iranian Rial Israeli Itew Shekel Japanese Ve.n Malaysian Ring git Mexican Pe=o Nepalese Rupee New Zealand Dollar Norwegian Kroner Omani Rial Pakistan Rupee Qatari Rial Saudi Rryal Singapore Dollar Slovenian Tolar South African Rand South Korean Won

Figure 24-1

0 0

Post a comment