International Finance

profilemalsadi2
HongKongRunningMaster.xlsx
Home>Business & Finance homework help>International Finance

Sheet1

Currency Stock S&P 500 Day Date Hangseng Hangseng in USD Rate of Return Date Currency Date S&P500 Rate of Return
https://quotes.wsj.com/fx/USDHKD/advanced-chart https://quotes.wsj.com/index/HK/XHKG/HSI/advanced-chart https://quotes.wsj.com/index/US/S&P%20US/SPX/advanced-chart?mod=md_usstk_chart_advanced Mon 8/26/2019 25680.33 3273.631543 8/26/2019 7.8446 8/26/2019 2878.38
Tue 8/27/2019 25664.07 3270.30812 -0.101521% 8/27/2019 7.8476 8/27/2019 2869.16 -0.320319%
Wed 8/28/2019 25615.48 3265.364709 -0.151160% 8/28/2019 7.8446 8/28/2019 2887.94 0.654547%
Thu 8/29/2019 25703.50 3276.042264 0.326994% 8/29/2019 7.8459 8/29/2019 2924.58 1.268724%
Fri 8/30/2019 25724.73 3280.127764 0.124708% 8/30/2019 7.8426 8/30/2019 2926.46 0.064283%
Sat 8/31/2019 25724.73 3280.127764 0.000000% 8/31/2019 7.8426 8/31/2019 2926.46 0.000000%
Sun 9/1/2019 25724.73 3280.127764 0.000000% 9/1/2019 7.8426 9/1/2019 2926.46 0.000000%
Mon 9/2/2019 25626.55 3267.650622 -0.380386% 9/2/2019 7.8425 9/2/2019 2926.46 0.000000%
Tue 9/3/2019 25527.85 3254.401397 -0.405466% 9/3/2019 7.8441 9/3/2019 2906.27 -0.689912%
Wed 9/4/2019 26523.23 3382.633593 3.940270% 9/4/2019 7.8410 9/4/2019 2937.78 1.084208%
Thu 9/5/2019 26515.53 3382.945905 0.009233% 9/5/2019 7.8380 9/5/2019 2976 1.300982%
Fri 9/6/2019 26690.76 3404.607378 0.640314% 9/6/2019 7.8396 9/6/2019 2978.71 0.091062%
Sat 9/7/2019 26690.76 3404.607378 0.000000% 9/7/2019 7.8396 9/7/2019 2978.71 0.000000%
Sun 9/8/2019 26690.76 3404.607378 0.000000% 9/8/2019 7.8396 9/8/2019 2978.71 0.000000%
Mon 9/9/2019 26681.40 3403.76078 -0.024866% 9/9/2019 7.8388 9/9/2019 2978.43 -0.009400%
Tue 9/10/2019 26683.68 3403.574025 -0.005487% 9/10/2019 7.8399 9/10/2019 2979.39 0.032232%
Wed 9/11/2019 27195.06 3469.465707 1.935956% 9/11/2019 7.8384 9/11/2019 3000.93 0.722967%
Thu 9/12/2019 27087.63 3461.854919 -0.219365% 9/12/2019 7.8246 9/12/2019 3009.57 0.287911%
Fri 9/13/2019 27352.69 3497.339215 1.025008% 9/13/2019 7.8210 9/13/2019 3007.39 -0.072436%
Sat 9/14/2019 27352.69 3497.339215 0.000000% 9/14/2019 7.8210 9/14/2019 3007.39 0.000000%
Sun 9/15/2019 27352.69 3497.339215 0.000000% 9/15/2019 7.8210 9/15/2019 3007.39 0.000000%
Mon 9/16/2019 27124.55 3469.100513 -0.807434% 9/16/2019 7.8189 9/16/2019 2997.96 -0.313561%
Tue 9/17/2019 26790.24 3424.8108 -1.276692% 9/17/2019 7.8224 9/17/2019 3005.7 0.258176%
Wed 9/18/2019 26754.12 3416.655386 -0.238127% 9/18/2019 7.8305 9/18/2019 3006.73 0.034268%
Thu 9/19/2019 26468.95 3380.108035 -1.069682% 9/19/2019 7.8308 9/19/2019 3006.79 0.001996%
Fri 9/20/2019 26435.67 3372.714051 -0.218750% 9/20/2019 7.8381 9/20/2019 2992.07 -0.489559%
Sat 9/21/2019 26435.67 3372.714051 0.000000% 9/21/2019 7.8381 9/21/2019 2992.07 0.000000%
Sun 9/22/2019 26435.67 3372.714051 0.000000% 9/22/2019 7.8381 9/22/2019 2992.07 0.000000%
Mon 9/23/2019 26222.40 3345.205899 -0.815609% 9/23/2019 7.8388 9/23/2019 2991.78 -0.009692%
Tue 9/24/2019 26281.00 3352.211125 0.209411% 9/24/2019 7.8399 9/24/2019 2966.6 -0.841639%
Wed 9/25/2019 25945.35 3309.862479 -1.263305% 9/25/2019 7.8388 9/25/2019 2984.87 0.615857%
Thu 9/26/2019 26041.93 3322.564718 0.383769% 9/26/2019 7.8379 9/26/2019 2977.62 -0.242892%
Fri 9/27/2019 25954.81 3310.435825 -0.365046% 9/27/2019 7.8403 9/27/2019 2961.79 -0.531633%
Sat 9/28/2019 25954.81 3310.435825 0.000000% 9/28/2019 7.8403 9/28/2019 2961.79 0.000000%
Sun 9/29/2019 25954.81 3310.435825 0.000000% 9/29/2019 7.8403 9/29/2019 2961.79 0.000000%
Mon 9/30/2019 26092.27 3328.817473 0.555264% 9/30/2019 7.8383 9/30/2019 2976.74 0.504762%
Tue 10/1/2019 26092.27 3326.865063 -0.058652% 10/1/2019 7.8429 10/1/2019 2940.25 -1.225838%
Wed 10/2/2019 26042.69 3320.162421 -0.201470% 10/2/2019 7.8438 10/2/2019 2887.61 -1.790324%
Thu 10/3/2019 26110.31 3329.929474 0.294174% 10/3/2019 7.8411 10/3/2019 2910.63 0.797199%
Fri 10/4/2019 25821.03 3293.792813 -1.085208% 10/4/2019 7.8393 10/4/2019 2952.01 1.421685%
Sat 10/5/2019 25821.03 3293.792813 0.000000% 10/5/2019 7.8393 10/5/2019 2952.01 0.000000%
Sun 10/6/2019 25821.03 3293.792813 0.000000% 10/6/2019 7.8393 10/6/2019 2952.01 0.000000%
Mon 10/7/2019 25821.03 3292.238939 -0.047176% 10/7/2019 7.8430 10/7/2019 2938.79 -0.447830%
Tue 10/8/2019 25893.40 3300.792902 0.259822% 10/8/2019 7.8446 10/8/2019 2893.06 -1.556083%
Wed 10/9/2019 25682.81 3273.655564 -0.822146% 10/9/2019 7.8453 10/9/2019 2919.4 0.910455%
Thu 10/10/2019 25707.93 3278.989056 0.162922% 10/10/2019 7.8402 10/10/2019 2938.13 0.641570%
Fri 10/11/2019 26308.44 3354.042683 2.288926% 10/11/2019 7.8438 10/11/2019 2970.27 1.093893%
Sat 10/12/2019 26308.44 3354.042683 0.000000% 10/12/2019 7.8438 10/12/2019 2970.27 0.000000%
Sun 10/13/2019 26308.44 3354.042683 0.000000% 10/13/2019 7.8438 10/13/2019 2970.27 0.000000%
Mon 10/14/2019 26521.85 3380.560583 0.790625% 10/14/2019 7.8454 10/14/2019 2966.15 -0.138708%
Tue 10/15/2019 26503.93 3378.319503 -0.066293% 10/15/2019 7.8453 10/15/2019 2995.68 0.995567%
Wed 10/16/2019 26664.28 3398.93179 0.610134% 10/16/2019 7.8449 10/16/2019 2989.69 -0.199955%
Thu 10/17/2019 26848.49 3422.718697 0.699835% 10/17/2019 7.8442 10/17/2019 2997.95 0.276283%
Fri 10/18/2019 26719.58 3406.588895 -0.471257% 10/18/2019 7.8435 10/18/2019 2986.2 -0.391934%
Sat 10/19/2019 26719.58 3406.588895 0.000000% 10/19/2019 7.8435 10/19/2019 2986.2 0.000000%
Sun 10/20/2019 26719.58 3406.588895 0.000000% 10/20/2019 7.8435 10/20/2019 2986.2 0.000000%
Mon 10/21/2019 26725.68 3407.71418 0.033033% 10/21/2019 7.8427 10/21/2019 3006.72 0.687161%
Tue 10/22/2019 26786.20 3415.47446 0.227727% 10/22/2019 7.8426 10/22/2019 2995.99 -0.356867%
Wed 10/23/2019 26566.73 3388.008519 -0.804162% 10/23/2019 7.8414 10/23/2019 3004.52 0.284714%
Thu 10/24/2019 26797.95 3418.978056 0.914093% 10/24/2019 7.8380 10/24/2019 3010.29 0.192044%
Fri 10/25/2019 26667.39 3402.624628 -0.478313% 10/25/2019 7.8373 10/25/2019 3022.55 0.407270%
Sat 10/26/2019 26667.39 3402.624628 0.000000% 10/26/2019 7.8373 10/26/2019 3022.55 0.000000%
Sun 10/27/2019 26667.39 3402.624628 0.000000% 10/27/2019 7.8373 10/27/2019 3022.55 0.000000%
Mon 10/28/2019 26891.26 3430.313931 0.813763% 10/28/2019 7.8393 10/28/2019 3039.42 0.558138%
Tue 10/29/2019 26786.76 3417.027248 -0.387331% 10/29/2019 7.8392 10/29/2019 3036.89 -0.083240%
Wed 10/30/2019 26667.71 3401.493622 -0.454595% 10/30/2019 7.8400 10/30/2019 3046.77 0.325333%
Thu 10/31/2019 26906.72 3433.293352 0.934875% 10/31/2019 7.8370 10/31/2019 3037.56 -0.302287%
Fri 11/1/2019 27100.76 3458.40586 0.731441% 11/1/2019 7.8362 11/1/2019 3066.91 0.966236%
Sat 11/2/2019 27100.76 3458.40586 0.000000% 11/2/2019 7.8362 11/2/2019 3066.91 0.000000%
Sun 11/3/2019 27100.76 3458.40586 0.000000% 11/3/2019 7.8362 11/3/2019 3066.91 0.000000%
Mon 11/4/2019 27547.30 3515.120968 1.639921% 11/4/2019 7.8368 11/4/2019 3078.27 0.370405%
Tue 11/5/2019 27683.40 3534.291696 0.545379% 11/5/2019 7.8328 11/5/2019 3074.62 -0.118573%
Wed 11/6/2019 27688.64 3537.760969 0.098160% 11/6/2019 7.8266 11/6/2019 3076.78 0.070253%
Thu 11/7/2019 27847.23 3558.20577 0.577902% 11/7/2019 7.8262 11/7/2019 3085.18 0.273013%
Fri 11/8/2019 27651.14 3532.789063 -0.714312% 11/8/2019 7.8270 11/8/2019 3093.08 0.256063%
Sat 11/9/2019 27651.14 3532.789063 0.000000% 11/9/2019 7.8270 11/9/2019 3093.08 0.000000%
Sun 11/10/2019 27651.14 3532.789063 0.000000% 11/10/2019 7.8270 11/10/2019 3093.08 0.000000%
Mon 11/11/2019 26926.55 3442.060388 -2.568188% 11/11/2019 7.8228 11/11/2019 3087.01 -0.196245%
Tue 11/12/2019 27065.28 3457.452 0.447163% 11/12/2019 7.8281 11/12/2019 3091.84 0.156462%
Wed 11/13/2019 26571.46 3394.369004 -1.824552% 11/13/2019 7.8281 11/13/2019 3094.04 0.071155%
Thu 11/14/2019 26323.69 3363.14727 -0.919810% 11/14/2019 7.8271 11/14/2019 3096.63 0.083709%
Fri 11/15/2019 26326.66 3363.612669 0.013838% 11/15/2019 7.8269 11/15/2019 3120.46 0.769546%
Sat 11/16/2019 26326.66 3363.612669 0.000000% 11/16/2019 7.8269 11/16/2019 3120.46 0.000000%
Sun 11/17/2019 26326.66 3363.612669 0.000000% 11/17/2019 7.8269 11/17/2019 3120.46 0.000000%
Mon 11/18/2019 26681.09 3408.634941 1.338509% 11/18/2019 7.8275 11/18/2019 3122.03 0.050313%
Tue 11/19/2019 11/19/2019 11/19/2019
Wed 11/20/2019 11/20/2019 11/20/2019
Thu 11/21/2019 11/21/2019 11/21/2019
Fri 11/22/2019 11/22/2019 11/22/2019
Sat 11/23/2019 11/23/2019 11/23/2019
Sun 11/24/2019 11/24/2019 11/24/2019
Mon 11/25/2019 11/25/2019 11/25/2019
Tue 11/26/2019 11/26/2019 11/26/2019
Wed 11/27/2019 11/27/2019 11/27/2019
Thu 11/28/2019 11/28/2019 11/28/2019
Fri 11/29/2019 11/29/2019 11/29/2019
Sat 11/30/2019 11/30/2019 11/30/2019
Sun 12/1/2019 12/1/2019 12/1/2019
Mon 12/2/2019 12/2/2019 12/2/2019
Tue 12/3/2019 12/3/2019 12/3/2019
Wed 12/4/2019 12/4/2019 12/4/2019
Thu 12/5/2019 12/5/2019 12/5/2019
Fri 12/6/2019 12/6/2019 12/6/2019
FINAL AVERAGE
: Only Through 11/4/2019-- DONT FORGET TO UPDATE AND END OF SEMESTER!! -Carrie Cramer		 AS OF 11/4/2019 26424.20 3370.90 0.001047531 7.839001408 2977.697606000 0.000976545
FINAL STDEV

Hong Kong to USD Currency Rate

Date

Currency

Hong Kong Stock Price

Date

Stock

US S&P 500

Date

Stock

https://quotes.wsj.com/fx/USDHKD/advanced-chart https://quotes.wsj.com/index/HK/XHKG/HSI/advanced-chart https://quotes.wsj.com/index/US/S&P%20US/SPX/advanced-chart?mod=md_usstk_chart_advanced