We had 3 main motivators to create this project learn more about Dropbase’s product play around with stock data visualization learn more about the stock market and play around with it
What it does?
It shows the combined value of all NASDAQ companies in the given time frame.
How we built it
We found a list of stock data of NASDAQ companies and transformed them using the Dropbase API, next we made use of AlphaVantage API to get stock prices and took advantage of Dropbase pipelines to transform and insert the data into a database. Finally, using Dropbase pipelines we grouped, summed up and exported values into our frontend. We also created a simple backend on Google Cloud Platform, which will be used in the future to feed the data into the Dropbase database.
Challenges we ran into
One of the main problems was Dropbase's lack of documentation, but fortunately, the co-founders were very active on Discord, always ready to help. They also created code samples we used to get started.
Accomplishments that we are proud of
We are proud that we managed to learn so many new things in such a short time.
What we learned
We learned how to use the Dropbase API and create awesome charts using amCharts JS library.
We also revised our Flask knowledge a bit which, we have to admit, got a bit rusty.
What's next for Stocks Only Go Up
Currently, Dropbase's API is still very limited (but that's understandable because it's still in the beta stage), so we had to crumble up many ideas that we initially had but which turned out to be not possible. The most pressing need is surely auto-refreshing the data in Dropbase – we simply did not manage to deliver this feature on time. Another feature is making our frontend show some info about the data it’s displaying – you, The Reader Of This Devpost, know that it’s the sum of the stock values of all NASDAQ companies combined, but there’s no info about this on the website. We also have to wait for DNS records to update to deploy our domain stocksonlygoup.tech.