joshuaulrich / joshuaulrich/quantmod

[R-Forge #111] db.fields bug in getSymbols.MySQL

Open
#21 0 comments 0 reactions 1 assignee Claimed by @joshuaulrich View on GitHub
bug
Dominant language
R
Stars
906
Forks
233
PR merge metrics
No merged PRs in 30d

Description

Submitted by: Denis Kolodin
Assigned to: Nobody
[R-Forge link](http://r-forge.r-project.org/tracker/index.php?func=detail&aid=111&group_id=125&atid=544)

When I call getSymbols('MSFT',src='MySQL', db.fields = c('timestamp', 'open', 'high', 'low', 'close', 'volume', 'adjust')) it make query:
SELECT timestamp, open, high, low, close, volume, adjust FROM my_table ORDER BY (!)date(!);

I change code that generates query to:
query <- paste('SELECT ', paste(db.fields, collapse = ','),
' FROM ', Symbols[[i]], ' ORDER BY ', db.fields[1])

Maybe fix it in library?!

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.