Hi guys,
I'm getting a object required error on the undrelined line. Would anyone have a vba macro that works to retrive historical prices please. There's no smaple in the help file. grateful for your advice. Thanks..
Sub prices()
Dim factory As fxcore2_com.IRequestFactory
Set factory = session.getRequestFactory()
Dim timeframes As fxcore2_com.ITimeframeCollection
Set timeframes = factory.timeframes
Dim timeFrame As ITimeframe
Set timeFrame = timeframes.getByID("m1")
Dim request As fxcore2_com.IRequest
Set request = factory.createMarketDataSnapshotRequestInstrument("EUR/USD", timeFrame, 300)
Call factory.fillMarketDataSnapshotRequestTime(request, "05/05/2012", "25/05/2012", False)
Call session.sendRequest(request)
Dim rfactory As fxcore2_com.IResponseReaderFactory
Set rfactory = session.getResponseReaderFactory()
Dim response
Dim mReader As IMarketDataSnapshotResponseReader
Set mReader = rfactory.createMarketDataSnapshotReader(response)
Dim ii As Integer
For ii = 0 To mReader.Count - 1
'information like reader.getDate(i), reader.getBidOpen(i), reader.getBidHigh(i), reader.getBidLow(i), reader.getBidClose(i), reader.getVolume(i) is now available
Next ii
End Sub