zslUpdateDB: Update zsl Data
In baixueyuan/zsl: Download and manipulate discount rate of bond from China Clear.

Description Usage Arguments Details Value

Update the bond discount rate data to MySQL database. The date of the lastest records can be detected from the database, and search the new data from the website, so the param date can be ignored.

1	zslUpdateDB(date, ch, folder = "", delete.file = TRUE)

`date`	the date of updating the zsl data
`ch`	the RODBC connection object
`folder`	the folder where to put the xls files
`delete.file`	logical, whether to delete the downloaded file

If the param date is given, that's meaning that this date's data would be updated even if it exists on the database server. All the data of and later than the given date will be deleted first, then new data is written.

No return, only the database will be updated.

baixueyuan/zsl documentation built on May 11, 2019, 5:27 p.m.