financial analysis in Excel
- Status: Closed
- Hadiah: $10
- Penyertaan Diterima: 1
- Pemenang: bizanalyst63
Ringkasan Peraduan
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%
Kemahiran Disyorkan
Maklum Balas Majikan
“@bizanalyst63 won the contest on 16 December 2017”
afterhourstech, United States.
Penyertaan teratas dari peraduan ini
-
bizanalyst63 India
Papan Penjelasan Umum
Bagaimana untuk mulakan dengan peraduan
-
Siarkan Peraduan Anda Cepat dan mudah
-
Dapatkan Bertan-tan Penyertaan Dari serata dunia
-
Anugerahkan penyertaan terbaik Muat turun fail - Mudah!