How to get USA Fund NetValue data using PYTHON interface
I want to get USA Fund NetValue using python, can anybody tell me how to do this? Thank you
Best Answer
-
I suggest you speak to your local Thomson Reuters Support Desk and build out an excel model with their help first - this will get you familiarised with the data model. Alternatively, you can pick a sample instrument and open it in the Data Item Browser app (DIB) on Eikon to find the proper field.
Here is a quick sample for an US ETF:
df, e = tr.get_data(['QQQ.OQ'], ['TR.FundNAV'])
0
Answers
-
Many thanks. I used PyCharm to develop my python programme. Which library should I include first? For example, when we use pandas ,we often used like the following:
# -*- coding: utf-8 -*-from datetime import *
from pandas import DataFrame,Series
import pandas as pd
import os
import logging
import math0 -
Also another question, I see your code,I should input the Fund Code to get its netvalue. then,how can I get the full fundcode of USA fund market?
0 -
You should install the eikon package with pip and import it. Have a look at this tutorial to set up the dev environment.
0 -
As I proposed originally, I suggest you discuss this with your local support desk and build out your workflow with excel.
0 -
@qidifei
I suggest you also see the following tutorial, which talks at length about metadata discovery (how you can find symbols, fields and parameters to use in your data requests) and about modeling data retrieval in Excel and translating it into Python code.
https://developers.thomsonreuters.com/eikon-apis/eikon-data-apis/learning?content=14707&type=learning_material_item1 -
Thank you for your help. I have installed eEikon using PIP ^_^
0 -
Many thanks! Your share is very useful
0
Categories
- All Categories
- 6 AHS
- 39 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 60 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛