Tweet
I'm looking to make a macro because I want to set a timer, so it can record quotes at periodic intervals. (Something like SigTools DDE Capture, but I need to specify the code to my needs)
How do I create a function that can fill in the quotes using Winros?
Right now, I'm trying to do it using .FormulaR1C1:
ActiveCell.FormulaR1C1 = "=winros|R[-2]C!'R[-1]C'"
Where the R[-2]C cell is the qualifier cell (e.g., Last), and the R[-1]C cell is the security (e.g., IBM AS). This would be repeated for a row of many securities and qualifiers.
This doesn't work, however. Is there a way to get this to work, or is there another way I can do this?
How do I create a function that can fill in the quotes using Winros?
Right now, I'm trying to do it using .FormulaR1C1:
ActiveCell.FormulaR1C1 = "=winros|R[-2]C!'R[-1]C'"
Where the R[-2]C cell is the qualifier cell (e.g., Last), and the R[-1]C cell is the security (e.g., IBM AS). This would be repeated for a row of many securities and qualifiers.
This doesn't work, however. Is there a way to get this to work, or is there another way I can do this?