コンテストを投稿する

financial analysis in Excel

ステータス: Closed
賞金: $10
受け取ったエントリー: 1
優勝者: bizanalyst63

Winner

コンテスト概要

Easy project here, expect less than 1 hour of work for expert Excel user. Below is a list of 26 MLP stocks. Please disregard the percentage number, just take the name and symbol. I need an EXCEL Spreadsheet with these 26 stocks as rows, then in each row I want the corresponding 1-year price history with one day per Column for each Row. The Excel must download the 1-year price history from some public free data source automatically (no manual copy-paste) (https://www.google.com/search?q=where+to+download+stock+price+history+for+free). Then finally, in a 2nd tab in the EXCEL, I want to see the correlations between the 26 stock price histories, shown as a 26 x 26 matrix (https://www.google.com/search?q=excel+stock+price+correlation). The entire work must be done in EXCEL including VBA with no external dependencies. THE FIRST ACCEPTABLE SOLUTION WILL BE AWARDED.

Here is the list of stocks and stock symbol (please ignore the numbers):

Magellan Midstream Partners LP (MMP) 10.58%
Enterprise Products Partners LP (EPD) 10.26%
Energy Transfer Partners LP (ETP) 9.17%
MPLX LP (MPLX) 8.99%
Williams Partners LP (WPZ) 7.99%
Plains All American Pipeline LP (PAA) 7.21%
Buckeye Partners LP (BPL) 5.65%
Western Gas Partners LP (WES) 4.00%
EQT Midstream Partners LP (EQM) 3.49%
Andeavor Logistics LP (ANDX) 2.87%
Spectra Energy Partners LP (SEP) 2.84%
DCP Midstream LP (DCP) 2.83%
Enbridge Energy Partners LP (EEP) 2.63%
TC PipeLines LP (TCP) 2.34%
EnLink Midstream Partners LP (ENLK) 2.14%
Genesis Energy LP (GEL) 2.11%
Shell Midstream Partners LP (SHLX) 2.07%
NuStar Energy LP (NS) 2.02%
Antero Midstream Partners LP (AM) 1.90%
Phillips 66 Partners LP (PSXP) 1.89%
Tallgrass Energy Partners LP (TEP) 1.78%
Boardwalk Pipeline Partners LP (BWP) 1.42%
Rice Midstream Partners LP (RMP) 1.35%
Dominion Energy Midstream Partners LP (DM) 1.30%
Holly Energy Partners LP (HEP) 1.18%