SpendWise

Inspiration

Managing personal finances can be daunting, especially when balancing daily expenses with long-term investments. I wanted to create a tool that merges convenience with insights using voice recognition to simplify expense logging and integrating stock market data to encourage better financial decisions. This project combines my interests in artificial intelligence, data analysis and financial literacy into one streamlined application.

What it does

This project is a voice-driven financial tracking and insights tool that helps users take control of their spending while gaining insights into the stock market.

1. Voice-Based Expense Logging
2. Users can log their daily expenses simply by speaking into a microphone.
3. The system uses speech-to-text technology to interpret the user's voice input and automatically categorize the expense.

4. For example, saying "Spent 50 on groceries" logs the expense description as "groceries" and the amount as $50 in the database.

5. Automated Expense Summaries

6. The application generates daily, weekly, and monthly summaries of the user's spending habits.

7. Each summary includes the total amount spent, providing a clear view of financial trends over time.

8. The summaries are stored in a dedicated database table for easy access and analysis.

9. Stock Market Insights

10. The app connects to the Alpha Vantage API to fetch data about the top-performing stocks.

11. Users can view the latest stock market trends and performance metrics. -This feature is designed to encourage users to think about investment opportunities and inspire better financial planning.

12. Secure and Organized Data Storage

13. All user data, including expenses and summaries, is stored securely in a MySQL database.

14. Sensitive information, such as API keys and database credentials, is managed using .env files to ensure privacy and security.

How we built it

1. Technologies Used:
2. Python: Main programming language for backend logic.
3. MySQL: For structured and persistent data storage.
4. pyaudio & speech_recognition: For voice input and transcription.
5. requests: For making API calls.
6. dotenv: To manage environment variables securely.
7. Development Process:
8. Step 1: Set up the database schema for users, expenses, summaries, and stock data.
9. Step 2: Integrated voice recognition for logging expenses and ensured real-time database updates.
10. Step 3: Connected to Alpha Vantage API to fetch and store stock performance data.
11. Step 4: Developed logic to generate and display daily, weekly and monthly summaries.

Challenges we ran into

1. Voice Recognition Accuracy:
2. The speech recognition library sometimes struggled with different accents, background noise, or unclear speech.

3. Solution: Improved the pre-processing by adjusting microphone sensitivity and providing clearer instructions to the user.

4. Error Handling for External APIs:

5. The stock API occasionally returned incomplete or unexpected data formats.

6. Solution: Added error handling for HTTP requests and response parsing.

7. Database Constraints:

8. Designing efficient relationships between tables (e.g., ensuring each expense belongs to a valid user) was tricky.

9. Solution: Iterated on the schema multiple times to find a balance between complexity and usability.

4.Learning Curve:

• Some libraries, like pyaudio, required additional configuration (especially on Linux/Ubuntu).
• Solution: Spent time researching and debugging system-level errors related to audio devices.

Accomplishments that we're proud of

1. Successful Voice Integration
2. Implemented a robust speech-to-text system using the SpeechRecognition library to accurately capture and process user voice commands.

3. Transformed a complex idea into a seamless user experience where expenses can be logged with just a few words.

4. Automated Financial Summaries

5. Built dynamic daily, weekly, and monthly expense summaries that are generated automatically, providing users with real-time insights into their spending habits.

6. Ensured that all data is securely stored in a well-structured MySQL database.

7. Stock Market Insights Feature

8. Integrated the Alpha Vantage API to fetch real-time stock market data, empowering users to explore investment opportunities alongside managing expenses.

9. Created a functional pipeline to process, store, and present stock performance data effectively.

10. Error Handling and Resilience

11. Developed a system that gracefully handles issues like failed API calls, voice misinterpretations, and database errors, ensuring the application remains user-friendly and reliable.

12. Secure Environment Management

13. Incorporated the use of .env files for managing sensitive credentials like API keys and database configurations, emphasizing best practices in security.

14. Scalable Database Design

15. Designed a modular database schema with tables for users, expenses, summaries, and stock data to accommodate future feature expansions or user growth.

16. Learning and Overcoming Challenges

17. Navigated through new technologies, like voice recognition and API integrations, while troubleshooting multiple issues such as ALSA errors for microphone input.

18. Gained deeper insights into Python, MySQL, and handling real-world data complexities.

19. A Step Toward Financial Literacy

20. Created a tool that has real-world value by simplifying expense tracking and introducing users to stock market awareness, making financial literacy more accessible.

What we learned

1. Voice Recognition Technology
2. Explored the intricacies of speech-to-text systems using SpeechRecognition.

3. Learned how to optimize voice input for better accuracy and user experience while managing system constraints like background noise.

4. Database Design and Optimization

5. Improved our understanding of relational database structures, including efficient schema design with primary keys, foreign keys, and ENUM data types.

6. Learned how to handle real-time data insertion and retrieval using MySQL.

7. API Integration -Gained experience working with third-party APIs like Alpha Vantage, including authentication, handling rate limits and parsing JSON data.

8. Learned to validate and handle unpredictable API responses to ensure seamless functionality.

9. Error Handling and Debugging

10. Developed skills in identifying and resolving issues such as ALSA audio input errors and database connection failures.

11. Understood the importance of implementing robust exception handling to make applications more resilient.

12. Environment Management

13. Mastered the use of .env files for securely managing sensitive information like API keys and database credentials.

14. Learned how environment variables improve portability and security in project deployment

What's next for SpendWise

• GUI Implementation: Build a user-friendly interface for ease of interaction.
• Real-Time Insights: Add real-time notifications about spending habits and stock market updates.
• Budget Planning: Allow users to set budgets and track spending against those limits.
• Mobile Compatibility: Extend the app to Android and iOS for on-the-go financial management.

Built With

• mysql
• pyaudio
• python
• requests