Google Sheets. Google Finance. Visualize in a dashboard. Users will pay to use sheet.

Hi- I am looking to have a Google Sheets / Excel spreadsheet made for tracking dividend income (and other passive income streams like rental income, YouTube income, etc.) When a user enters a ticker symbol of a stock, ETF, etc, I need the sheet to recognize the ticker and pull relevant data such as company name, current price, dividend $, dividend yield, and MORE. This data should come from a free, but reliable source like Google Finance, Yahoo Finance, NASDAQ, Seeking Alpha, etc. I did some of this myself using just the function abilities of the sheet which pulled data from the sources above. The user will be inputting the ticker, shares owned, maybe price they paid, etc. I want a field to alert the user if a company drops their dividend, and also if the dividend has increased. Maybe a red colored SELL and green colored BUY next to that security.

I want fields to input non investment income like rental income, commissions, etc.,just in case a person wanted to include those too. These don’t need a data feed. They will be input by the user. This data then needs to go to a dashboard in a nice graphical dashboard which can be sorted, using the charts present in Google Sheets, Excel, or other free charting service.

I will be selling access to the sheet and data dashboard through a website by subscription service so it must have its formulas locked and hidden in a way that can’t be unhidden. The best example I can give is http://dividendmeter.com These are the basics. I can give more specifics if this project sounds like something you are able to do. Thanks! -Billy

About the recuiter
Member since Aug 9, 2019
Billy
from Minnesota, United States

---

---

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions