/
Connecting to the Database Directly

Connecting to the Database Directly

Introduction

For more sophisticated users, connecting to the database is sometimes the most efficient method. There are many ways of connecting to the database directly. For example

Details on the tables inside the Database

Currently there are 3 main tables inside the Database. We are constantly adding new tables based on customer feedback, so pls check here for details in case you see a table you do not recognize

  • Consolidated_Holdings: These are a daily snapshot of all your assets and liabilities for every child account that you have
  • IRR_Table: This has the XIRR and absolute return made in USD for every security for every child_account
  • Transaction_Snapshot: This is all the transactions in your account marked to market as of the last valuation date


Related content

Connecting to PostgreSQL using pgAdmin 4
Connecting to PostgreSQL using pgAdmin 4
Read with this
Menu: User Accounts
Menu: User Accounts
More like this
Connecting Excel to PostgreSQL
Connecting Excel to PostgreSQL
Read with this
User Accounts
More like this
Consolidated_Holdings
Consolidated_Holdings
More like this
Strategy_Records
Strategy_Records
More like this