LIVE FX data and OpenOffice Calc

Discussion in 'Data Sets and Feeds' started by Done 777, Jan 25, 2009.

  1. Done 777

    Done 777


    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.
  2. Done 777

    Done 777

  3. mike007


    you can do it with fx feed but you have to open and fund an account there.
  4. Done 777

    Done 777

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

    Done 777

    I see I can't set less than 1-minut refreshing in excel :(
  6. DaveN


    Do some research on MB Trading's API. ( 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).
  7. 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()

    ' 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
    End If

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

    End Sub