financial analysis in Excel
- Status: Closed
- Nagroda: $10
- Uzyskane Zgłoszenia: 1
- Zwycięzca: bizanalyst63
Opis Konkursu
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%
Zalecane Umiejętności
Opinie o Pracodawcy
“@bizanalyst63 won the contest on 16 December 2017”
afterhourstech, United States.
Najlepsze zgłoszenia do tego konkursu
-
bizanalyst63 India
Publiczna Tablica Wyjaśnień
Jak rozpocząć z konkursami?
-
Opublikuj swój Konkurs Łatwo i szybko
-
Uzyskaj Tysiące Ofert Z całego świata
-
Nagródź najlepszą ofertę Pobieraj pliki - Łatwo!