financial analysis in Excel

  • Status: Closed
  • Prize: $10
  • Entries Received: 1
  • Winner: bizanalyst63

Contest Brief

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) ([url removed, login to view]). 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 ([url removed, login to view]). 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%

Recommended Skills

Top entries from this contest

View More Entries

Public Clarification Board

How to get started with contests

  • Post your contest

    Post Your Contest Quick and easy

  • Get tons of entries

    Get Tons of Entries From around the world

  • Award the best entry

    Award the best entry Download the files - Easy!

Post a Contest Now or Join us Today!