Navigation

    Quantiacs Community

    • Register
    • Login
    • Search
    • Categories
    • News
    • Recent
    • Tags
    • Popular
    • Users
    • Groups

    Futures data issues

    Support
    3
    6
    317
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • M
      Msant14 last edited by

      Dear Team,

      I think your futures data have been changed, with more than an issue here and there. A quick example to catch one of the errors:
      0aed2153-1c1e-4fa3-a3f6-28bf6f39f5c1-image.png

      To me this sounds wrong because, first, I get an 800% return on the 23-12-2020, and second, all the prices look the same, right?

      An example from ICE:
      9f04d776-6ba9-442c-9e3f-6d397aa2f8ce-image.png

      Am I wrong or is this not correct?

      Thanks!

      support 2 Replies Last reply Reply Quote 1
      • support
        support @Msant14 last edited by

        @msant14 Yes, your are right, we are fixing the issue now. Unfortunately we had to replace some datasets, more info at:

        https://quantiacs.com/community/topic/60/data-for-futures

        Do not hesitate to point out problems! As soon as the bug is fixed we will let you know.

        1 Reply Last reply Reply Quote 0
        • support
          support @Msant14 last edited by

          @msant14 Hello, the issue has been fixed. Sorry, a problem with the data API. Please note that we are using 3month Euribor Futures from Eurex and not ICE

          A 1 Reply Last reply Reply Quote 0
          • A
            antinomy @support last edited by antinomy

            @support
            F_DE also looks odd on 2010-01-11:

            import qnt.data as qndata
            start_date = "2006-01-01"
            futures = qndata.futures.load_data(min_date=start_date).sel(field='close').to_pandas()
            futures.F_DE.loc[slice('2010-01-03', '2010-01-13')]
            
            2010-01-04    1023.00
            2010-01-05    1027.20
            2010-01-06    1033.50
            2010-01-07    1026.30
            2010-01-08    1033.20
            2010-01-11     103.39
            2010-01-12    1020.30
            2010-01-13    1022.40
            

            as if the price somehow got divided by 10 on that day...

            And EUR/YEN looks totally off:

            futures.F_RY.plot()
            

            EUR_YEN.png

            support 1 Reply Last reply Reply Quote 0
            • support
              support @antinomy last edited by

              @antinomy

              Hello.

              We fixed a problem with sudden "spikes" and "fissures" in the futures data (F_EB, F_ED), but I don't see the problem in the currency data (F_RY).

              Can you remove the data-cache and try again? Is this issue with F_RY still relevant?

              Regards.

              A 1 Reply Last reply Reply Quote 0
              • A
                antinomy @support last edited by

                @support I have done that twice before my post, but now F_RY looks fine. There are several directories with scripts and notebooks I use with qnt, so maybe I deleted the wrong data-cache before...
                Thanks for fixing the data!

                1 Reply Last reply Reply Quote 0
                • First post
                  Last post
                Powered by NodeBB | Contributors
                • Documentation
                • About
                • Career
                • My account
                • Privacy policy
                • Terms and Conditions
                • Cookies policy
                Home
                Copyright © 2014 - 2021 Quantiacs LLC.
                Powered by NodeBB | Contributors