TFY-MyBank

A platform that allows users to simulate buying and selling stocks and create a watchlist of their favorite stocks. The portfolio data is stored in a relational database and real-time stock data is obtained through free API calls (in JSON format then stored) from marketstack and Alpha Vantage. Portfolio status visualization and access to the trading predictive alghoritms optionalities (Auto, Standard, Assisted -> to be implemented).

Features

• Login to the webapp
• Buy and sell stocks to build your portfolio
• Create and manage a watchlist of your favorite stocks
• Real-time stock data from trusted sources with real time graphs
• Multiple possibilities to manage your trading portfolio (Auto, Assisted, Standard)
• Secure platform with CSRF protection and user authentication

Login	Personal area	Add stocks
Watching list	Graphs based on DataBase	Real time data stock
Standard portfolio	Manage your trading portfoli	Transaction history

Getting Started

1. Clone the repository and set up your local environment $ git clone https://github.com/andreramolivaz/TFY-MyBank.git
2. Install PHP and a relational database software on your system (preferably XAMPP)
3. Config the connection to the DB here
4. Request fot the API keys for marketstack and Alpha Vantage in order to retrieve real-time stock data and then put the key in the config file

DataBase Structure

Here you can find a dump of the DB so that you can use TFY-MyBank without getting the API key by only importing the dump on XAMPP.

ER Diagram

Project Structure

TFY_MyBank
├── Resources
│   └── stock-market-html.zip
├── Resources.zip
├── aggiungi-azione.php
├── aggiungi-sezione.php
├── area-cliente.php
├── azione.php
├── azioni.php
├── chiudi-posizione.php
├── debugging
│   ├── curl.php
│   ├── get-name.php
│   └── new-price.php
├── dist
│   ├── css
│   │   ├── sb-admin-2.css
│   │   └── sb-admin-2.min.css
│   └── js
│       ├── sb-admin-2.js
│       └── sb-admin-2.min.js
├── elimina-sezione.php
├── grafico.php
├── includes
│   ├── config.php
│   ├── connect.php
│   ├── database-planning.txt
│   ├── footer.php
│   ├── header.php
│   ├── info.txt
│   └── navigation.php
├── js
│   └── sb-admin-2.js
├── login.html
├── login.php
├── logo_size.jpg
├── logo_size_invert.jpg
├── logout.php
├── modifica-sezione.php
├── nuovi-dati.php
├── sezione.php
├── sezioni.php
├── storico.php
├── valori-cache-azione.php
└── vendor
    ├── bootstrap
    │   ├── css
    │   │   ├── bootstrap.css
    │   │   └── bootstrap.min.css
    │   ├── fonts
    │   │   ├── glyphicons-halflings-regular.eot
    │   │   ├── glyphicons-halflings-regular.svg
    │   │   ├── glyphicons-halflings-regular.ttf
    │   │   ├── glyphicons-halflings-regular.woff
    │   │   └── glyphicons-halflings-regular.woff2
    │   └── js
    │       ├── bootstrap.js
    │       └── bootstrap.min.js
    ├── bootstrap-social
    │   ├── bootstrap-social.css
    │   ├── bootstrap-social.less
    │   └── bootstrap-social.scss
    ├── font-awesome
    │   ├── css
    │   │   ├── font-awesome.css
    │   │   ├── font-awesome.css.map
    │   │   └── font-awesome.min.css
    │   ├── fonts
    │   │   ├── FontAwesome.otf
    │   │   ├── fontawesome-webfont.eot
    │   │   ├── fontawesome-webfont.svg
    │   │   ├── fontawesome-webfont.ttf
    │   │   ├── fontawesome-webfont.woff
    │   │   └── fontawesome-webfont.woff2
    │   ├── less
    │   │   ├── animated.less
    │   │   ├── bordered-pulled.less
    │   │   ├── core.less
    │   │   ├── extras.less
    │   │   ├── fixed-width.less
    │   │   ├── font-awesome.less
    │   │   ├── icons.less
    │   │   ├── larger.less
    │   │   ├── list.less
    │   │   ├── mixins.less
    │   │   ├── path.less
    │   │   ├── rotated-flipped.less
    │   │   ├── screen-reader.less
    │   │   ├── spinning.less
    │   │   ├── stacked.less
    │   │   └── variables.less
    │   └── scss
    │       ├── _animated.scss
    │       ├── _bordered-pulled.scss
    │       ├── _core.scss
    │       ├── _extras.scss
    │       ├── _fixed-width.scss
    │       ├── _icons.scss
    │       ├── _larger.scss
    │       ├── _list.scss
    │       ├── _mixins.scss
    │       ├── _path.scss
    │       ├── _rotated-flipped.scss
    │       ├── _screen-reader.scss
    │       ├── _spinning.scss
    │       ├── _stacked.scss
    │       ├── _variables.scss
    │       └── font-awesome.scss
    └── jquery
        ├── jquery.js
        └── jquery.min.js

Documentation

You can find a detailed documentation of the project in Italian here.

An italian ppt that resume evrething is also avaiable here.