Description Usage Arguments Value Author(s) Examples
View source: R/pub03_DatabaseOperationFuncs.R
update the local database
Due to the SHENWAN inustry standard changing in 2014, fix local database's shenwan industry rule's bug and make the rule keep consistent. The new industry standard is 33. Update 3 related local tables:CT_SystemConst,CT_IndustryList and LC_ExgIndusry.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 | lcdb.update()
lcdb.update.SecuMain()
lcdb.update.QT_TradingDay()
lcdb.update.CT_SystemConst()
lcdb.update.CT_IndustryList()
lcdb.update.LC_ExgIndustry()
lcdb.update.LC_IndexComponent()
lcdb.update.LC_IndexComponentsWeight(begT, endT, IndexID)
lcdb.update.QT_IndexQuote(begT, endT, IndexID, datasrc = c("quant", "jy"))
lcdb.update.QT_DailyQuote(begT, endT, stockID)
lcdb.update.QT_DailyQuote2(begT, endT, stockID, loopFreq = "100 year")
lcdb.update.LC_RptDate(begT, endT)
lcdb.update.LC_PerformanceGrowth(begT, endT)
lcdb.fix.swindustry()
lcdb.fix.ezindustry()
|
begT |
a numeric date. if missing, ' |
endT |
a numeric date. if missing, 99990101. |
nothing.
nothing.
Andrew Dow
Qian Han
1 2 3 4 5 6 | lcdb.update.LC_IndexComponentsWeight() # update all the indexs up to date
lcdb.update.LC_IndexComponentsWeight(20060101,20060330) # update all the indexs in given period
lcdb.update.LC_IndexComponentsWeight(19000101,99990101,"EI000905") # update all the data of given index
lcdb.update.LC_IndexComponentsWeight(20060101,20060330,"EI000905")
lcdb.fix.swindustry()
lcdb.fix.ezindustry()
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.