LIVE FX data and OpenOffice Calc

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.

 

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

 

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

 

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

 

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

 

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).

 

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