Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Transactions /
  • REDI API /
avatar image
Question by ds01 · Jul 26, 2021 at 06:12 PM · excelredi-apiforexdde

FX Prices return zero

Hi,

Could you provide a sample on how to pull an FX quote using Excel?

After reading the DDE usage guide, i tried =RediLink|FXQ!'AUD/USD;CROSS,SB' which will return the pair in the first cell (as desired) and then zero as the spot bid.

It does the same when i replace SB with SA for spot ask.

Thanks


People who like this

0 Show 2
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
REFINITIV
zoya faberov ♦♦ · Jul 26, 2021 at 09:20 PM 0
Share
Hi @ds01,

The example of usage in DDE Usage Guide that you are looking at should be good.

I am going to request to confirm, if you/your user are permissioned for FX via DDE, as this could be the reason why. Will keep you informed of the findings.

avatar image
ds01 zoya faberov ♦♦ · Jul 28, 2021 at 01:39 PM 0
Share
Thanks Zoya. Please let me know if I can provide anything to help.

1 Reply

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by brian.mullane · Aug 16, 2021 at 01:16 PM

Hi @ds01 ,

Please see below for a sample.

Before trying this, I recommend checking with your support representative to ensure you're entitled for FX quotes in the REDI API.

Thanks,

Brian

1629119566662.png



1629119566662.png (142.2 KiB)
Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
11 People are following this question.

Related Questions

London Stock Exchange - order prices

Redi Trade Automation

Excel DDE real-time data retrieval

DDE links =REDILink|'L1'!'SPY;LP' gets the the latest price (LP). Where can I find a list of all types of data available like high and low and volume?

Redi Current positon in excel

  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Electronic Trading
    • Generic FIX
    • Local Bank Node API
    • Trading API
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Intelligent Tagging
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open Calais
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • RDMS
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • Workspace SDK
    • Element Framework
    • Grid
  • World-Check Data File
  • 中文论坛
  • Explore
  • Tags
  • Questions
  • Badges