NexusFi: Find Your Edge


Home Menu

 





Looking for how to get Interest Rates with API


Discussion in Currencies

Updated
      Top Posters
    1. looks_one gregid with 4 posts (0 thanks)
    2. looks_two rleplae with 2 posts (0 thanks)
    3. looks_3 Big Mike with 2 posts (1 thanks)
    4. looks_4 sam028 with 1 posts (1 thanks)
    1. trending_up 4,974 views
    2. thumb_up 2 thanks given
    3. group 5 followers
    1. forum 11 posts
    2. attach_file 0 attachments




 
Search this Thread

Looking for how to get Interest Rates with API

  #1 (permalink)
 
gregid's Avatar
 gregid 
Wrocław, Poland
 
Experience: Intermediate
Platform: NinjaTrader, Racket
Trading: Ockham's razor
Posts: 650 since Aug 2009
Thanks Given: 320
Thanks Received: 623

I am looking for a website/webservice from where I could programmatically get the information about current (possibly past?) interest rates to calculate Rollover Interest/Carry Trade fees.

I would rather avoid web scraping if possible so a webservice with nice API would be the best.

Any suggestions?

Started this thread Reply With Quote

Can you help answer these questions
from other members on NexusFi?
Futures True Range Report
The Elite Circle
NexusFi Journal Challenge - April 2024
Feedback and Announcements
The space time continuum and the dynamics of a financial …
Emini and Emicro Index
Exit Strategy
NinjaTrader
My NT8 Volume Profile Split by Asian/Euro/Open
NinjaTrader
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Get funded firms 2023/2024 - Any recommendations or word …
61 thanks
Funded Trader platforms
38 thanks
NexusFi site changelog and issues/problem reporting
26 thanks
GFIs1 1 DAX trade per day journal
19 thanks
The Program
18 thanks
  #3 (permalink)
 
Big Mike's Avatar
 Big Mike 
Manta, Ecuador
Site Administrator
Developer
Swing Trader
 
Experience: Advanced
Platform: Custom solution
Broker: IBKR
Trading: Stocks & Futures
Frequency: Every few days
Duration: Weeks
Posts: 50,398 since Jun 2009
Thanks Given: 33,173
Thanks Received: 101,537


Have you checked quandl?



Mike

We're here to help: just ask the community or contact our Help Desk

Quick Links: Change your Username or Register as a Vendor
Searching for trading reviews? Review this list
Lifetime Elite Membership: Sign-up for only $149 USD
Exclusive money saving offers from our Site Sponsors: Browse Offers
Report problems with the site: Using the NexusFi changelog thread
Follow me on Twitter Visit my NexusFi Trade Journal Reply With Quote
Thanked by:
  #4 (permalink)
 
gregid's Avatar
 gregid 
Wrocław, Poland
 
Experience: Intermediate
Platform: NinjaTrader, Racket
Trading: Ockham's razor
Posts: 650 since Aug 2009
Thanks Given: 320
Thanks Received: 623

Thanks Mike,

I haven't checked Quandl for that as I was looking for something kept more up to date (that would inform me if the interest rate changed). Quandl may be good for the past interest part though, although I can't verify this since my free trial expired and this seems to be Premium Data:
https://www.quandl.com/c/economics/interest-rate-sge-by-country
Can someone with premium access verify if the above includes historical interest rates data?

In the meantime still looking...

Started this thread Reply With Quote
  #5 (permalink)
 
gregid's Avatar
 gregid 
Wrocław, Poland
 
Experience: Intermediate
Platform: NinjaTrader, Racket
Trading: Ockham's razor
Posts: 650 since Aug 2009
Thanks Given: 320
Thanks Received: 623

If I am mistaken about Quandl not being up to date (actively updated), please let me know.

Started this thread Reply With Quote
  #6 (permalink)
Darthtrader4beta
western NY
 
Posts: 42 since Apr 2015
Thanks Given: 9
Thanks Received: 26


gregid View Post
If I am mistaken about Quandl not being up to date (actively updated), please let me know.

Quandl I'm sure is updated regularly but the pricing is just laughable IMO.

If you are not using the quandl API I would think your only real option for free interest rate data would be to scrape the wall street journal site. Bloomberg obviously would be able to do this but I don't drive a Ferrari.

Reply With Quote
  #7 (permalink)
 
gregid's Avatar
 gregid 
Wrocław, Poland
 
Experience: Intermediate
Platform: NinjaTrader, Racket
Trading: Ockham's razor
Posts: 650 since Aug 2009
Thanks Given: 320
Thanks Received: 623


Darthtrader4beta View Post
Quandl I'm sure is updated regularly but the pricing is just laughable IMO.

If you are not using the quandl API I would think your only real option for free interest rate data would be to scrape the wall street journal site. Bloomberg obviously would be able to do this but I don't drive a Ferrari.

Yeah, had the same conclusion - paying 175$ for just interest rate would be an overkill.

I'll probably end up scraping https://www.dailyfx.com/ for that info.

Started this thread Reply With Quote
  #8 (permalink)
 
rleplae's Avatar
 rleplae 
Gits (Hooglede) Belgium
Legendary Market Wizard
 
Experience: Master
Platform: NinjaTrader, Proprietary,
Broker: Ninjabrokerage/IQfeed + Synthetic datafeed
Trading: 6A, 6B, 6C, 6E, 6J, 6S, ES, NQ, YM, AEX, CL, NG, ZB, ZN, ZC, ZS, GC
Posts: 3,003 since Sep 2013
Thanks Given: 2,442
Thanks Received: 5,863

Just out of curiosity, have you worked out the storage ?

I 'm at the point that i have my data collection, i need to store the data now
I know that @Big Mike has 3 databases : tick, minute, day

I guess i will probably end up doing the same..

Any thoughts, advice on that ?

Follow me on Twitter Visit my NexusFi Trade Journal Reply With Quote
  #9 (permalink)
 
sam028's Avatar
 sam028 
Site Moderator
 
Posts: 3,765 since Jun 2009
Thanks Given: 3,825
Thanks Received: 4,629

I'm not sure it's very useful to have different databases, different tables are enough IMHO.
The good question is more: what would be the tables structure.
On my side I'm working on something similar with a single database and a table per bar type (tick/minute/day). I'm not sure it's the best option on performance point of view, as the tick table is going to be very very large, but on a "logical" point of view I don't like the idea of having a distinct table per symbol.


rleplae View Post
Just out of curiosity, have you worked out the storage ?

I 'm at the point that i have my data collection, i need to store the data now
I know that @Big Mike has 3 databases : tick, minute, day

I guess i will probably end up doing the same..

Any thoughts, advice on that ?


Success requires no deodorant! (Sun Tzu)
Follow me on Twitter Reply With Quote
Thanked by:
  #10 (permalink)
 
baywolf's Avatar
 baywolf 
San Diego, CA
 
Experience: Intermediate
Platform: TT Pro
Broker: Advantage
Trading: Gasoil, heatoil, crude
Posts: 55 since Sep 2009
Thanks Given: 26
Thanks Received: 33



gregid View Post
If I am mistaken about Quandl not being up to date (actively updated), please let me know.

True for many datasets on Quandl. On the left side there is a section "validate" with a link to the dataset source. Many times the source may have their own API you can tap directly or scrape the page if no API is provided. That way you can update on your terms. I think the value of Quandl is that they provide a single source for normalized datasets and their API is really easy to use, so you can save a lot of time testing ideas out.

Reply With Quote




Last Updated on November 10, 2015


© 2024 NexusFi™, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
All information is for educational use only and is not investment advice. There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Privacy Policy - Downloads - Top
no new posts