lcdb.init: lcdb.init

In QuantAndrew/QDataGet: Data getting functionns

Description

initialize all the tables in sqlitdb

Usage

lcdb.init.IndexQuote_000985E(begT = 20050101)

lcdb.init.IndexQuote_000985(begT = 19900101)

lcdb.init.QT_FreeShares(filename = "D:/sqlitedb/QT_FreeShares.csv")

lcdb.init.CT_TechVars(filename = "D:/sqlitedb/CT_TechVars.csv")

lcdb.init_main(begT = 19900101, endT = 99990101)

lcdb.init_qt()

lcdb.init.QT_DailyQuote(begT = 19900101, endT = 99990101)

lcdb.init.QT_DailyQuote2(begT = 19900101, endT = 99990101)

lcdb.init.CT_FactorLists(filename = "D:/sqlitedb/CT_FactorLists.csv")

lcdb.init.QT_FactorScore(begT = 20050104, endT = 99990101)

lcdb.init_fs()

Examples

# A correct throughout process of initialize the whole local database:
# 1. expert 3 csv tables:
lcdb.export2csv("main","CT_TechVars")
lcdb.export2csv("main","QT_FreeShares")
lcdb.export2csv("fs","CT_FactorLists")
# 2. build 3 empty sqlite files: qt.db, fs.db, main.db
# 3. initialize 3 database files, in proper order:
lcdb.init_qt()
lcdb.init_main()
lcdb.init_fs()

QuantAndrew/QDataGet documentation built on May 14, 2019, 7:35 a.m.