Asset Alert

AssetAlert is an easy-to-use fintech backend library that you can integrate with your investment portfolio. You can track price changes for cryptos and stocks and receive live price growth/dip alerts.

Comment

Inspiration

Millions of people, including myself, family members, and friends, use Google Sheets to manage investment portfolios. However, I’ve noticed that there isn’t really an easy way to track changes in company stocks or cryptocurrency within Sheets.

What it does

I decided to build Asset Alert, which is an easy-to-use and highly functional backend library that allows you to add stocks and cryptocurrencies to a watchlist and get notifications on price changes.

How we built it

I created a Google Apps Script project for this tool. The backend is JavaScript, and the two popups use HTML5. Additionally, I utilized the AlphaVantage financial api to get historical stock/crypto data, as well as the Google Sheets API to retrieve the user's watchlist data and email. I also utilized Google Cloud in order to actually deploy my library to the public.

Challenges we ran into

Using an external API within Apps Script and extracting all the financial data from the complex JSON api responses Figuring out how to schedule daily, weekly, and monthly tasks within the code Figuring out how to actually send the emails to the client within the code Deploying my project both on the Google Cloud Platform and as a backend library

Accomplishments that we're proud of

-I was able to individually develop a useful fintech library within a matter of days -I was able to deploy this library using GCP so that the public can use it -I learned to schedule tasks and send emails using JavaScript

What we learned

-Sharpened JavaScript skills -Learned to deploy a project on GCP -Learned to work with APIs like the Google Sheets API and AlphaVantage stock api

What's next for Asset Alert

-Make it such that the columns are already titled in the first row of the watchlist so the only thing the user has to do is input their data and call my library -Possibly add more features such as top headlines for the stock and crypto -Receive feedback from interested users and incorporate such feedback -Improve the UI experience (i.e. more aesthetic emails and popups)

Built With

Share this project:

Updates