Hér má finna upplýsingar um allar þjónustur í KODIAK Excel sem viðkemur skuldabréfum.
...
Þjónustur | Lýsing |
|---|---|
AskPrice | Returns the best ask price for a given symbol |
AskQuantity | Returns the quantity of the current best ask for a given symbol |
BidPrice | Returns the best bid price for a given symbol. |
BidQuantity | Returns the quantity of the current best bid for a given symbol |
CurrentMarketValue | Returns the current marketvalue for a given symbol |
High12Months | Returns the highest price traded in the last 12 months for a given symbol |
High12MonthsDate | Returns the date at which the highest traded price occurred in the past 12 months. |
High4Weeks | Returns the highest price traded in the last four weeks for a given symbol |
High7Days | Returns the highest price traded in the last 7 days for a given symbol |
HighDD | Returns the highest price traded in a given period for a given symbol |
HighPrice | Returns the highest trade price during a business day. If no trade price is found then the latest closing high paid price is returned |
HighThisYear | Returns the highest price traded in this year for a given symbol |
LastPaidD | Returns the last paid price on a given day for a given symbol. The function only considers trades that update last price |
LastPrice | Returns the last priceforming trade price for a given symbol. If no trade price is found then the latest corrected official closing price is returned |
LastPriceD | Returns the last priceforming trade price for a given symbol and day. If no trade price is found then the latest corrected official closing price is returned |
LastPriceDTest |
|
LastPriceTradeTime | Returns the date and time of the last priceforming trade for a given symbol. If last trade was not today, only the date is returned. |
LastTradeDateD | Returns the trade date where the last trade happened for a given symbol on or before the given date. |
LastTradePrice | Returns the last trade price for a given symbol. |
Low12Months | Returns the lowest price traded in the last 12 months for a given symbol |
Low12MonthsDate | Returns the date at which the lowest traded price occurred in the past 12 months. |
Low4Weeks | Returns the lowest price traded in the last four weeks for a given symbol |
Low7Days | Returns the lowest price traded in the last 7 days for a given symbol |
LowDD | Returns the lowest price traded in a given period for a given symbol |
LowPrice | Returns the lowest trade price during a business day. If no trade price is found then the latest closing low paid price is returned |
LowThisYear | Returns the lowest price traded in this year for a given symbol |
MarketCapD | Returns the total market value for a given symbol and day. Outstanding shares are exclusive of shares held by the company itself. The closingprice for the given day is used as price. |
NetChange12Months | Returns the net price change in the last 12 months for a given symbol |
NetChange3Months | Returns the net price change in the last 3 months for a given symbol |
NetChange4Weeks | Returns the net price change in the last four weeks for a given symbol |
NetChange7Days | Returns the net price change in the last 7 days for a given symbol |
NetChangeThisYear | Returns the net price change (nominal) this year for a given symbol |
NetChangeToday | Returns the net price change within the current day for a given symbol |
NordicAskPrice | Returns the latest ask price for a given stock symbol. Applies to all NASDAQ Nordic exchanges |
NordicAskQuantity | Return the latest ask quantity for a given symbol. Applies to all NASDAQ Nordic symbols. |
NordicBidPrice | Returns the latest bid price for a given symbol. Applies to all NASDAQ Nordic exchanges. |
NordicBidQuantity | Return the latest bid quantity for a given stock symbol. Applies to all NASDAQ Nordic symbols. |
NordicLastPrice | Returns the last price forming trade price for a given symbol |
NordicLastPriceD | Returns the latest price forming price for a given symbol on or before the given trade date. |
NordicTurnoverToday | Returns the turnover (in trading currency) today for a given symbol. |
NordicVolumeToday | Returns the volume in shares today |
NumberOfTradesTotal | Returns the total number of trades in Saxess today for a given symbol. |
OpeningPrice | Returns the opening trade price during a business day. If no trade price is found then NULL is returned |
PerChangeCorrected30Days | Returns the percentage change in price between closing price 30 days ago and the latest price. Price used is the adjusted price for corporate actions. Calculating 30 days: Current date - 30 days, if the earlier date is a holiday then we use the latest date before that. |
PerChangeCorrected7Days | Returns the percentage change in price between closing price 7 days ago and the latest price. Price used is the adjusted price for corporate actions. Calculating 7 days: Current date - 7 days, if the earlier date is a holiday then we use the latest date before that. |
PerChangeCorrectedYTD | Returns the percentage change in price YTD. Price used is the adjusted price for corporate actions. |
Price4Weeks | Returns the price 4 weeks ago for a given symbol |
TotalAskOrders | Returns the total volume on the ask side of the book at a given time for a given symbol |
TotalBidOrders | Returns the total volume on the bid side of the book at a given time for a given symbol |
TradableAbsReturnDD | Returns the absolute price change including dividends or interest payments for a given tradable between two dates |
TradablePerReturnDD | Returns the percentage price change including dividends or interest payments for a given tradable between two dates |
TradablePerReturnReinvestDD | Returns the total return for a given bond between two dates where interest payments and index adjustments are reinvested. |
TradeCount12M | Returns the count of trades traded in the last 12 months for a given symbol |
TradeCount4Weeks | Returns the count of trades traded in the last 4 weeks for a given symbol |
TradeCount7Days | Returns the count of trades traded in the last 7 days for a given symbol |
TradeCountDD | Returns the count of trades traded in a given period for a given symbol |
TradeCountThisYear | Returns the count of trades traded this year for a given symbol |
TradeCountToday | Returns the total number of trades in Saxess today for a given symbol. |
TradedAmountTotal | Returns the total amount of trading in Saxess today for a given symbol. |
ValueTraded12M | Returns the total value traded in the last 12 months for a given symbol |
ValueTraded4Weeks | Returns the total value traded in the last 4 weeks for a given symbol |
ValueTraded7Days | Returns the total value traded in the last 7 days for a given symbol |
ValueTradedDD | Returns the total value traded in a given period for a given symbol |
ValueTradedOnExchangeDD | Returns volume * price for a given date period and a given symbol. Includes only trades executed on the exchange. |
ValueTradedThisYear | Returns the total value traded in this year for a given symbol |
ValueTradedToday | Returns the total value of trading (eligible for last price updates) today for a given symbol. |
ValueTradedTodayM | Returns the total value of trading today for a given market symbol |
ValueTradeReportsDD | Returns volume * price for a given date period. Includes only trade reports and OTC trades (Trade class = Non Standard) |
VolumeTraded12M | Returns the total volume traded in the last 12 months for a given symbol |
VolumeTraded4Weeks | Returns the total volume traded in the last 4 weeks for a given symbol |
VolumeTraded7Days | Returns the total volume traded in the last 7 days for a given symbol |
VolumeTradedDD | Returns the total volume traded in a given period for a given symbol |
VolumeTradedOnExchangeDD | Returns the total volume between two dates that was traded on the exchange. This does not include trades executed off the exchange and then reported. |
VolumeTradedThisYear | Returns the total volume traded in this year for a given symbol |
VolumeTradedToday | Returns the total volume of trading in Saxess today for a given symbol. |
VolumeTradeReportsDD | Returns the total volume of trade reports and OTC trades between two dates that were reported to the exchange. |
Vwap | Returns the intraday VWAP (volume weighted average price) for a given symbol |
VwapAsk | Returns the volume weighted price on the ask side of the book at a given time for a given symbol |
VwapBid | Returns the volume weighted price on the bid side of the book at a given time for a given symbol |
...
Sýnishorn | Skjal | ||||||
|---|---|---|---|---|---|---|---|
| NasdaqOMXPrices Skjal með upplýsingum um rauntímaviðskipti í Nordic Exchange.
| ||||||
 | ClosingPrices Skjal með upplýsingum um dagslokaverð bréfa í Nordic Exchange
| ||||||
 | BondsCalc - BondsInfo Skjal sem sýnir upplýsingar um forsendur skuldabréfa. Skjalið sýnir einnig notkun á föllum og runum fyrir útreikninga á ávöxtunarkröfu, núvirði, binditíma o.f.l.
| ||||||
 | BondsYields Skjal með upplýsingum um ávöxtunarkröfu skuldabréfa miðað við viðskipti í NASDAQ OMX Iceland
| ||||||
 | NasdaqOMXIndex Skjal með upplýsingum um hlutabréfavísitölur. Það sýnir meðal annars nýjasta gildi og þróun hverrar vísitölu. Nýjustu útgáfu af Excel (Excel 2021 eða Office 365) þarf til þess að allir eiginleikar dæmaskjalsins virki.
|
