[R-SIG-Finance] 'Defaults' removed from CRAN? (2014-10-03)

[Mark Knecht]

On Wed, Oct 8, 2014 at 9:56 AM, G See <gsee000 at gmail.com> wrote:
> Out of curiosity, did you try _not_ changing your current code, but
> instead adding library(Defaults) to the top of the script?  It's not
> ideal, but Defaults _is_ still available
> (http://cran.r-project.org/src/contrib/Archive/Defaults/).  That could
> buy you some time until you come up with something better.
>
> Just a (possibly bad) thought.
> Garrett
>

I did not but for whatever reason it didn't seem to work for me. SetDefaults is
apparently found and the defaults are in therebut getSymbols.MySQL didn't
apparently pick up. SPY is not returned, QQQ is when I pass the info
in explicitly.
I'm probably doing something stupid...

- Mark

> library(quantmod)
> library(RMySQL)
> library(Defaults)
>
>
> dbName = "R_ETF"
>
> getDefaults()
[1] "getSymbols.MySQL"
>
> dbc = dbConnect(MySQL(), dbname=dbName)
> setDefaults(getSymbols.MySQL, user="mark", password="MyTempPassword", dbname=dbName)
>
> getDefaults()
[1] "getSymbols.MySQL"
>
> getDefaults("getSymbols.MySQL")
$user
[1] "'mark'"

$password
[1] "'MyTempPassword'"

$dbname
[1] "dbName"

>
> getSymbols("SPY", src="MySQL")
Error in getSymbols.MySQL(Symbols = "SPY", env = <environment>,
verbose = FALSE,  :
  At least one connection argument ( ‘user’ ‘password’ ‘dbname’ ) is not set
>
> getSymbols("QQQ", src="MySQL", user="mark", password="MyTempPassword", dbname=dbName)
[1] "QQQ"

>



library(quantmod)
library(RMySQL)
library(Defaults)


dbName = "R_ETF"

getDefaults()

dbc = dbConnect(MySQL(), dbname=dbName)
setDefaults(getSymbols.MySQL, user="mark", password="MyTempPassword",
dbname=dbName)

getDefaults()

getDefaults("getSymbols.MySQL")

getSymbols("SPY", src="MySQL")

getSymbols("QQQ", src="MySQL", user="mark", password="MyTempPassword",
dbname=dbName)