Skip to content

R Shiny + PostgreSQL application for managing and visualizing expenses + net worth

Notifications You must be signed in to change notification settings

ryushida/shinymoney

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

29 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

R Shiny Application for visualizing expenses and net worth.

Features

  • Enter expenses (date, amount, account, category, notes)

  • Visualize Spending by Date (Scatter plot and heatmap)

  • Visualize Spending by Category (Scatter plot and heatmap)

  • Enter value of each account

  • Visualize the value of each account (Stacked Bar Plot)

  • Manage categories, accounts, and account types

  • Import CSV of Portfolio and Visualize (Bar and Treemap)

Usage

  1. Start PostgreSQL server

  2. Create database and tables

psql postgresuser
CREATE DATABASE databasename;
\c databasename postgresuser
\i init.sql

\l
\dt
  1. Create config.yml
default:
  database_name: 'databasename'
  database_host: '127.0.0.1'
  database_port: 5432
  database_user: 'postgresuser'
  database_password: 'password'
  1. Start Application

About

R Shiny + PostgreSQL application for managing and visualizing expenses + net worth

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages