Excel VBA

[L-plate]

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

[Ekaterina]

Hi L-plate,

we will write sample and give it to you tomorrow.

Best regards,
Ekaterina

[Ekaterina]

Hi L-plate,

Here is the 'Get historic prices' sample for Excel vba.