[R-SIG-Finance] How to use RExcel using Macro Approach for real time market data

Kunal Shah kunalshah305 at gmail.com
Sat Jun 20 13:58:44 CEST 2015


I do the following things
1: Import real time market data from my brokers terminal to Excel
2: I have written a small macro to export that data to R using RExcel
3: R performs all the computations and outputs the result
4: I display back R's output to the Excel Sheet

How to make VBA understand that this process needs to be continuously done
with every refresh of stock market data.

Also, since I have just started using RExcel, I would appreciate any
feedback about the package.


	[[alternative HTML version deleted]]

More information about the R-SIG-Finance mailing list