LIVE FX data and OpenOffice Calc

[Done 777]

Hello,

I am looking someone who is providing free (or cheap) live forex data to OpenOffice Calc? Becuse i am a scalper, I need 1 sec. interval, but the best will be 100-300 ms.

Of course I need some tutorial which shows how to connect OpenOffice Calc
to FX data server too.

 

[Done 777]

I've got "Excel 2007" too, but only portable, so i am not sure is it good for watching quotes.

I see OpenTick has free real-time from ECNs. But I see it's "S - stocks". Am I right?

http://www.opentick.com/index.php?app=content&event=product_details&n=41#41

 

[mike007]

you can do it with www.thinkorswim.com fx feed but you have to open and fund an account there.

 

[Done 777]

I see Yahoo has free fx RT quotes, but do they allow 1s interval connecting?

 

[Done 777]

I see I can't set less than 1-minut refreshing in excel

 

[DaveN]

Do some research on MB Trading's API. (sdk.mbtrading.com) There are some examples of usage with Excel. I've not done anything with the MB API using Excel, but I think that should translate easily over to OO Calc. You can open a free demo account with MB Trading, use that to log in and connect your sheet/app, and get your streaming quotes (you'll see about 3 per second during active times).

 

[thegazelle]

You can set the interval to X seconds if you write a macro. I've got one that does it for some stuff I do at work.

I can't post all the code, but the part that might help is below :

Public Sub RefreshChartData()
Sheets("chart").Activate
Range("A1..A20").Select

' Do not attempt to refresh again if we are still in the middle of a request.
If Not Selection.QueryTable.Refreshing Then
Selection.QueryTable.Refresh BackgroundQuery:=True
RefreshRows
End If

Application.OnTime Now + TimeValue("00:00:55"), "Sheet1.RefreshChartData"

End Sub