-
Snowflake / SQL version needed for existing Python code
Hi All, We have some Python code for extracting Bond Cashflows data which was kindly written by Lukasz Trzcinski. However, we now ideally would like to retrieve this data via Snowflake or SQL code. Please can someone advise / convert the code? Attached file 'bond cash flows (multiple bonds)' contains the code and…
-
Optimizing Speed of Application.Run "EikonRefreshWorkbook"
I am trying to fetch some historical prices in large blocks of at least 50000 and inserting them directly into SQL with a VBA-Loop. Thanks to this forum I was already able to figure out that a synchronous refresh of the TR-formulas can be done with Application.Run "EikonRefreshWorkbook". Everything works fine for a small…
-
How to load World Check Standard Data from either CSV or XML? Much Tried with .CSV over Oracle DB
How to load World Check Standard Data from either CSV or XML? Much Tried with .CSV over Oracle DB
-
Which API to query RICs from Tableau?
Which API can be used to query RICs from Tableau?
-
Need help developing a tool to query historical prices from Datascope Select (DSS) and import them i
Hello Developer Community I need a someone to develop a tool to query historical prices from Datascope Select (DSS) and import them into our SQL Server database This should be a 3 step process: * Populate required prices/FX rates from positions in our SQL server database * Retrieve data (historical prices / FX rates) from…
-
Using get_data with loop in python for historical data
I would like to download several infos and balance sheet items from several companies. I keep in an SQL table a list of RICs that I imported as a list of integers [4295859221, ...] named rics and in another SQL table the list of the fields I want to download from Eikon as a DataFrame [TR.F.CashSTInvst, TR.TotalAssets, ...]…
-
Can I download Market Holidays via SSL/RSSL?
Hi All, In the same vein as pulling the appendix_a from TREP can I pull a list of market holidays via SSL/RSSL. Kind Regards, Adam
-
Hi all, I am trying to connect python by pyodbc to sql data base, but I am getting this error: Inter
Hi all, I am trying to connect python by pyodbc to sql data base, but I am getting this error: InterfaceError: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)')
-
Best API to use for loading Symbol and Pricing Data into ETL?
We are needing to load ticker lists and pricing data through our ETL process into our application. I'm confused by the number of API's available - I'm just going to be automatically loading the ticker data into one of our SQL Server tables, at a certain time each morning. Same with pricing for yesterday's close. Which API…
-
SQL interface instead of Eikon excel
Dear All, We would like to kindly ask you, whether we can access to market data (which the current Excel interface is linked) using SQL interface? Our aim is to retrieve volumes and bids directly to a data table created in MS SQL to retrieve data against the current Excel. The database connection generally consists of the…
-
Connecting MS SQL Server 2014 to EIKON services
We are trying to establish a live link that will help us to retrieve TBA pricing by using MS SQLS 2014. There is a report built in SSRS on our side that requires live pricing feed. What is the most efficient way of solving this?
-
Get Records from SYS.DUAL in rowwise
HI , I would like to know whether we can get the rows from dual in rows. For Example: select 'a','b','c' from Dual. Ouput: 'A' 'B' 'C' a b c But I required output in rowwise.i.e., Required Output: a b c I need a solution with nested query.without union and level commands Any help in this regard is highly appreciated.
-
How does Cobalt handle SQL database replication and fault tolerance across multiple sites?
Hello, This is a broad question, but I'm wondering how Cobalt handles its SQL databases across multiple sites? Specifically, I'm interested in replication and fault tolerance. For example, the Foldering module has a database it writes to. Presumably there is a separate physical database for site A and site B in Cobalt. How…