Google Sheets with Live Stock Portfolio Performance Over time (and future) with Charts and Graphs
$30-250 USD
Paguhet në dorëzim
I would like an automated spreadsheet built in google sheets (This is the only service that offers historical stock performance data in spreadsheet)
The spreadsheet should track monthly and yearly performance data from 2011-Present and keep tracking as time goes on. If you have to input a limit, up to the year 2050 is fine.
There should be conditional formatting that highlights a cell red if it the return is negative, highlights in green if the return is positive, and display red text if it underperforms the S&P 500.
There should also be a dashboard that clearly displays a line charts compared to to to the S&P 500. The line charts should be dynamic to reflect The last month, 3 month, 6 month, 12, month, 2 year, 3 year, and 5 year performance via drop down menu. The categories for the line charts should be as follows and reflect the stocks associated with the category. All returns should be based on and display percentages.
Categories:
DOM EQ (LG Blend)
DOM EQ (LG Value)
DOM EQ (LG Growth)
DOM EQ (MD Blend)
DOM EQ (MD Value)
DOM EQ (MD Growth)
DOM EQ (SM Blend)
DOM EQ (SM Value)
DOM EQ (SM Growth)
INTL EQ (LG Blend)
INTL EQ (LG Value)
INTL EQ (LG Growth)
INTL EQ (MD Blend)
INTL EQ (MD Value)
INTL EQ (MD Growth)
INTL EQ (SM Blend)
INTL EQ (SM Value)
INTL EQ (SM Growth)
DOM Fixed Income
INTL Fixed income
This should be an easily updatable spreadsheet where I can enter the stock ticker number and category and it auto populates into the line charts (categories specified above).
Please see "set up" tab in the spreadsheet below for my stocks and their categories:
[login to view URL]
ID Projekti: #29867809
Rreth projektit
5 profesionistë freelancer dërguan një ofertë mesatare prej $67 për këtë punë
Hello Dear. I understand your project and wish to work with you. i have highly experienced. waiting for your response