Is there a way to make calls between R and Excel in order to run R quantstrat package using EOD data. Send proposed trades to an excel file (which has to be inserted manually as the broker does not have an API) and then import the trades from an excel file to R for continuous analysis? Thanks for your help
Asked
Active
Viewed 54 times
1
-
yes there is, what have you tried? – Nate Jun 08 '17 at 12:03
-
Use `openxlsx` library to write, `readxl` to read Excel files, Luke. – Alex Knorre Jun 08 '17 at 12:11
-
I have tried xlsx package functions write.xlsx and read.xlsx but I do not know what R function to use to extract the day's trades and what R function to use to insert the executed trades to blotter (?) – Cristian Popescu Jun 08 '17 at 12:42
-
Should I use getOrders daily and addOrder for each trade? If I did this, could I avoid having to work through Excel? – Cristian Popescu Jun 08 '17 at 13:00