The most recent content from our members.
Accessing usage and inventory data from the on-prem PostgreSQL db Can we have the `public.consolidated0yyyy_mm_dd` usage-type tables populated on scheduled basis? Are those tables including ALL of the PEs used across the firm? If not, can we schedule a run for all of the PEs we’re subscribed to. What is the period covered…
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…
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
Which API can be used to query RICs from Tableau?
...m into our SQL Server database 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…
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, ...]…
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: InterfaceError: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)')
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…
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…
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?
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.
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…
It looks like you're new here. Sign in or register to get started.
