The most recent content from our members.
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…
It looks like you're new here. Sign in or register to get started.
