Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Eikon COM /
avatar image
Question by MSI · Aug 13, 2018 at 10:48 AM · eikonc# .netcom_apivessels

Using Vessel Built year in RSeach query

Hi

I am using RSearch api in C# to retrieve vessel IDs by their type, their size and year of built.

For search criteria, I am using the following query.

RCSAssetTypeGenealogy:'F:30' DWT:0 Built:1975

However, it does not recognise Built as valid search field. I Also tried AssetBuilt, TR.AssetBuilt and RCSAssetBuilt, i still get same issue.

Could anyone please let me know how to use year of built in search criteria in RSearch?

Thanks

People who like this

0 Show 0
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.

2 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by Alex Putkov. · Aug 13, 2018 at 11:24 AM

As far as I can see 'year built' is not available as a criteria for the vessel search. In other words there's no way to search for vessels by the year built. You can see the list of search criteria available in the GUI provided by SRCH app in Eikon or in the wizard behind the Search button in Thomson Reuters ribbon in Eikon Excel.

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.

avatar image
Answer by MSI · Aug 17, 2018 at 10:04 AM

Thanks Alex, what about speed? I am trying to use speed as search criteria, which returns no result, whereas there is data. I would like to narrow down the result by a few parameter to get the result below 2000 row limit...

thanks

Comment

People who like this

0 Show 2 · 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.

avatar image
REFINITIV
Alex Putkov. ♦♦ · Aug 17, 2018 at 11:43 AM 0
Share

I have no problem using speed as criteria. I just tried this:
.AssetClass = "PHYSICALASSET"
.SearchCriteria = "RCSAssetTypeGenealogy:'F:K' LocationSpeed:>18.00 DWT:>10000"
which translates into search for all vessels with the speed greater than 18 and dead weight tonnage greater than 10,000. This search resulted in 1001 vessel.

avatar image
REFINITIV
Alex Putkov. ♦♦ · Aug 17, 2018 at 11:47 AM 0
Share

You can see the list of criteria available following the Search wizard behind the Search button in Thomson Reuters ribbon in Eikon Excel. Following this wizard you can insert =RSearch worksheet function into Excel, which mimics the behavior of RSearch COM library. You can copy & paste the search criteria that Search wizard inserts for =RSearch worksheet function into your code using RSearch COM library.

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

Can I find the default Eikon for Excel RHistory fields for an instrument using the COM APIs and VBA?

Login to Reuters EIKON via VBA with username and password

How to connect to Reuters Eikon Excel programmatically with VBA?

"Forced" login

Corporate Action Excel getting wrong data

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • 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
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • 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
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges