DepotQuotesCollector
DepotPerformanceCalculator
Think global - Act local
- 4-in-1 Solution for using public market quotes within a local environment
- Languages English and German
- Multiple Cultures (Format of Number and Date)
- Multiple Currencies for definitions and evaluations
- Integration in existing workflow (Clipboard and neutral file formats)
Ready to explore with test data (Download)
Free for non-commercial and private use
DepotQuotesCollector
The DepotQuotesCollector calls websites analogously a browser and reads the quotes history of tradable securities.
- https://www.ariva.de (Multiple marketplaces)
- https://de.finance.yahoo.com (Multiple marketplaces)
(Integral part of 4-in-1-Solution DepotPerformanceCalculator)
StockList
- StockList contains a table of tradable securities
and/or manually generated source files
- Definition in one or multiple StockList files (tables)
- Loadable as single file or multiple added files combined
- Collected quotes history of market quotes and the data of
manually generated source files will be stored in separate
local data files, e.g.:
EU0009652759_EURUSD_AR-EZB.xml (Metadata)
EU0009652759_EURUSD_AR-EZB.dbl (Binary data)
and/or manually generated source files
- Definition in one or multiple StockList files (tables)
- Loadable as single file or multiple added files combined
- Collected quotes history of market quotes and the data of
manually generated source files will be stored in separate
local data files, e.g.:
EU0009652759_EURUSD_AR-EZB.xml (Metadata)
EU0009652759_EURUSD_AR-EZB.dbl (Binary data)
Identifier
Requestable Types
- ISIN (International Securities Identification Number) and
a marketplace (e.g. DE0005810055 as identifier for
Deutsche Börse AG and marketplace Xetra)
a marketplace (e.g. DE0005810055 as identifier for
Deutsche Börse AG and marketplace Xetra)
- Symbol (e.g. 4689.T, already containing identifier
YAHOO JAPAN CORP. and marketplace Tokyo)
YAHOO JAPAN CORP. and marketplace Tokyo)
- Stock (e.g. Deutsche Börse AG, YAHOO JAPAN CORP., BASF)
- Fund (e.g. Franklin Templeton GL BD MDIS A USD, IP White T)
- Bond (e.g. Microsoft Corp. DL-Notes 2015(15/22))
- Certificate (e.g. Open End Turbo auf T-Note Future)
- Commodity (e.g. Gold (/oz (31,10 g), Kruegerrand 1 oz (/unit))
- Currency (e.g. EZB, NYSE, Börse-Frankfurt)
- Index (e.g. Dow Jones, EURO STOXX 50, DAX)
- Fund (e.g. Franklin Templeton GL BD MDIS A USD, IP White T)
- Bond (e.g. Microsoft Corp. DL-Notes 2015(15/22))
- Certificate (e.g. Open End Turbo auf T-Note Future)
- Commodity (e.g. Gold (/oz (31,10 g), Kruegerrand 1 oz (/unit))
- Currency (e.g. EZB, NYSE, Börse-Frankfurt)
- Index (e.g. Dow Jones, EURO STOXX 50, DAX)
Improved Security
The DepotQuotesCollector reads data from the internet analogously to a web browser and stores these data to local files. It does not send any more data or data of local DepotList etc. to anywere. All other programs compute local data only.
Exemplarily some more features
- Search and Filter with wildcards
- Context menus header cells for table layout, sorting etc.
- Context menus table cells for viewing of data tables,
calling web info etc.
- Search and Filter with wildcards
- Context menus header cells for table layout, sorting etc.
- Context menus table cells for viewing of data tables,
calling web info etc.
Limitations
The DepotQuotesCollector stores the market quotes until the previous day of the day starting the collection as quotes history. For the current day the request gets the last available market quote. For each day one set of marketquotes will be stored. Intraday quotes depending on a days time are not representable.
On page "Download" test data with multiple examples is available. Ready to explore.