-
Time stamped an hour out of sync
One thing I noticed is the csv files my code is creating are being time stamped an hour out of sync. For example, when I save files at 18:44 my local time they are time stamped as 17:44. I tried to run this to get around it ``` import pandas as pd import pytz from datetime import datetime, timedelta # Adjust the offset…
-
Endpoint to upload csv file
Hi, I want to know if there is an endpoint to upload a csv file and screen multiple cases. When I checked posman collection I found only this endpoint https://api-worldcheck.refinitiv.com/v2/cases/saveAndScreen
-
Mapping logic between input column name (request) and output column name (csv) in Tick History API
Hi Team, May we know the mapping logic between input column name (request) and output column name (csv) in Tick History API? As this is API, it has programmatic rules in place on your side which determine the column order on your return payload. Also, the dev team constructs a CSV file with the available input column names…
-
Where is the button for export data table to csv file in ric search?
Can´t find the button or the function to export data table to csv file in ric search tool https://developers.refinitiv.com/en/tools-catalog/ric-search#
-
How to clean the output of data
Hello, I have the code below. import DatastreamPy as dsws import pandas as pd # set up connection def connection_DSWS(): DSWS_username = open("DSWSUsername.txt","r") DSWS_password = open("DSWSPassword.txt","r") ds = dsws.Datastream(username = str(DSWS_username.read()), password = str(DSWS_password.read()))…
-
column with double quotation in DSS csv file
One of prospects would like to enclose values with double-qutations in instrument identifier colunn in DSS csv output file (due to format issue of their internal systems). e.g. "JPY=", I thought about using 'User Defined Identifier' field with RIC values + , so that values with comma wil be enclosed with double-quotations.…
-
如何将获取到的ESG数据进行扁平化处理成为CSV
我获取到ESG数据之后,想要进行扁平化处理,变成CSV文件。但是,还是有很多字段是json格式。如何处理?
-
Some exported cells to csv do not have any decimal separator (I use Pandas and Python)
Hi folks, I am trying to download data to study it with Pandas. I want to store the data in csv format. THe problem is I see that sometimes the cells do not contain the decimal separator which means the number is 1000 higher than it should. For example: 253.456 253.634 253.83 253980 And this happens in all columns, High,…
-
How to quote strings in csv files
Hi, is there a way to obtain a csv file with string fields quoted? Currently, we receive the csv files without quotes, so it is hard to detect if a field is string or number. Regards.
-
About sample data in csv, excel...
is there any sample data ( in csv,excel..) in EDP, that could be sent to me for looking ?
-
Exporting weather data to CSV
I just want to write an API to extract historical weather data into a CSV. Any help is much appreciated!
-
How to pass additional parameters to csv file for Batch Uploading?
When creating a csv with several hundred tickets for batch processing, I want the file to contain all necessary information to minimize the # of manual modifications required after uploading the csv file into REDI or PT for batch release. Certain order types require additional parameters: (e.g. VWAP, TWAP, EDGX <inside…
-
how download a data into csv file
Hello Guys, i´m trying to download a data with get_timeseries and when i get it i have a problem with my csv file. I currently use: import eikon as ek ek.set_app_id('XXXXXXXXXXXXXXXXXXX') df=ek.get_timeseries(['CARC.BA','CEL.BA','CAMb.BA','COL.BA','DYC.BA','ESM.BA','FER.BA','FIP.BA','GAR.BA',…
-
Data within eikon in python to CSV file.
import eikon as ek import csv ek.set_app_id('ID') df = ek.get_timeseries([".MERV"], start_date="2000-01-01", end_date="2018-05-18",interval='minute') writer = csv.writer(open("C:/data/MERV.csv", 'w')) for row in df: writer.writerow(row)
-
News headline and story to CSV file
Hi, I would like to make csv file of news headlines and story. for headline I’m using→headlines = ek.get_news_headlines('JPY=') for story I’m using →for index, headline_row in headlines.iterrows(): story = ek.get_news_story(headline_row['StoryId']) print (story) then request, df.to_csv('news.csv') Does anyone know where do…