pystockdb

PyPI - Downloads

Database for stocks based on pony.orm. This package provides an create, sync and update tool.

At the moment we are only support a few stocks. If you want to have more, please contribute pytickersymbols.

install

pip install pystockdb

database schema

StockDB Schema

quick start

In all samples we use sqlite but you are free to use other providers. For more information's please read Connecting to the Database.

Install sqlite stock db:

import logging
from pystockdb.tools.create import CreateAndFillDataBase

logger = logging.getLogger('test')
config = {
    'max_history': 1,
    'indices': ['DAX'],
    'currencies': ['EUR'],
    'db_args': {
        'provider': 'sqlite',
        'filename': 'demo.sqlite',
        'create_db': True
    },
}
create = CreateAndFillDataBase(config, logger)
create.build()

Update sqlite stock db:

import logging
from pystockdb.tools import ALL_SYMBOLS
from pystockdb.tools.update import UpdateDataBaseStocks

logger = logging.getLogger('test')
config = {
    'symbols': [ALL_SYMBOLS],
    'prices': True,       # update prices
    'fundamentals': True, # update fundamental stock data
    'db_args': {
        'provider': 'sqlite',
        'filename': 'demo.sqlite',
        'create_db': False
    },
}
update = UpdateDataBaseStocks(config, logger)
update.build()

Sync sqlite stock db:

import logging
from pystockdb.tools.sync import SyncDataBaseStocks

logger = logging.getLogger('test')
config = {
    'max_history': 1,
    'indices': ['CAC 40'], # add new index to existing database
    'currencies': ['EUR'],
    'db_args': {
        'provider': 'sqlite',
        'filename': 'demo.sqlite',
    },
}
sync = SyncDataBaseStocks(config, logger)
sync.build()

Getting database objects:

import datetime
from pony.orm import db_session

from pystockdb.db.schema.stocks import Price, Stock
from pystockdb.tools.base import DBBase

# connect to database

arguments = {
    'db_args': {
    'provider': 'sqlite',
    'filename': 'test.sqlite',
    'create_db': False
    }
}
# Read https://docs.ponyorm.org/api_reference.html for other provider settings

DBBase(arguments, None)

now = datetime.datetime.now()
last_week = now - datetime.timedelta(days=7)
with db_session:
    # get ifx stock object
    stock = Stock.select(
        (lambda s: 'IFX.F' in s.price_item.symbols.name)
    ).first()
    # select ifx.f prices of the last week
    prices = Price.select(
        lambda p: p.symbol.name == 'IFX.F'
        and p.date >= last_week
        and p.date <= now
    )

issue tracker

https://github.com/portfolioplus/pystockdb/issuese

Release files for pystockdb 1.0.16

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Built distribution (wheel)

Table of built distributions (wheels) for pystockdb 1.0.16
File	Interpreter	ABI	Platform	Reset
pystockdb-1.0.16-py3-none-any.whl 14.1 kB Dec 13, 2019	Python 3	none	any	Details

Release files / pystockdb-1.0.16-py3-none-any.whl

Download URL	pystockdb-1.0.16-py3-none-any.whl
Size	14.1 kB
Tags	Python 3
SHA-256 checksum How to use checksums	`f9fe2f5f13514e4c811f69ff4da4c744011b68053755498b34c2322ad4c886df`
BLAKE2b-256 checksum How to use checksums	`f7a4c8dbd14a8b5e11a22d6e235c0be7b70bc1267d31eb9d339b4dd68e4d2b5c`
Upload date	Dec 13, 2019
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`twine/3.1.1 pkginfo/1.5.0.1 requests/2.22.0 setuptools/42.0.2 requests-toolbelt/0.9.1 tqdm/4.40.2 CPython/3.6.7`