EXCEL        R        PYTHON        TABLES        INFO

FIELD DESCRIPTION
THE DATABASE CONSIST OF THE FOLLOWING TABLES
MySQL SYNTAX
SYNTAX FOR A CONNECTION VIA A MySQL CLIENT
MS SQL SYNTAX
SYNTAX FOR A CONNECTION VIA A MICROSOFT SQL SERVER CLIENT

               

    Fields of table "equity" (Equity)
Field nameTypeDescription
Datedate(3)Date
SecurityIdbigint(8)Security id
CompanyIdbigint(8)Company id
Symbolvarchar(16)Symbol
ISINvarchar(13)ISIN
Namevarchar(50) of associated equity
BestBidPricefloat(8)Best bid price
BestAskPricefloat(8)Best ask price
Openfloat(8)Open price
Highfloat(8)Higest observed price during trading day
Lowfloat(8)Lowest observed price during trading day
Closefloat(8)Closing price
OfficialNumberOfTradesfloat(8)Official number of trades
OfficialVolumefloat(8)Official volume
UnofficialNumberOfTradesfloat(8)Unofficial number of trades
UnofficialVolumefloat(8)Unofficial volume
VolumeWeightedAveragePricefloat(8)Volume weighted average price
Pricefloat(8)Price
AdjustedPricefloat(8)Adjusted price
Dividendsfloat(8)Last payed dividend
LDividendsfloat(8)Lagged dividend
CorpAdjfloat(8)Corp adjustments (splits etc.)
DividendAdjfloat(8)Dividend adjustment factor
Currencyvarchar(3)Currency. Currently allways NOK
Descriptionvarchar(40)Description
CountryCodevarchar(10)Country code
SumAnnualDividendsfloat(8)Sum annual dividends
NumberOfSharesfloat(8)Number of shares issued (not free float adjusted)
CompanyOwnedSharesfloat(8)Company owned shares
OutstandingSharesfloat(8)Outstanding shares
Exchangevarchar(3)Exchange
NOKPerForexfloat(8)Exchange rate. Currently allways 1
mktcapfloat(8)Market capitalization
OSEBXmktshare_prevmnthfloat(8)Prevoius month market share in OSEBX index
OSEBXAlpha_prevmnthfloat(8)Prevoius month alpha relative to OSEBX index
OSEBXBeta_prevmnthfloat(8)Prevoius month beta relative to OSEBX index
SMBfloat(8)SMB Fama-French factor
HMLfloat(8)HML Fama french factor
LIQfloat(8)LIQ Pastor-Stambaugh factor
MOMfloat(8)MOM Fama-French factor
DividendPriceRatiofloat(8)Dividend price ratio
lnDeltaPfloat(8)log return of the price
lnDeltaOSEBXfloat(8)log return of the OSEBX index
lnDeltaOBXfloat(8)log return of the OBX index
NOWA_DayLnratefloat(8)Log difference of Norwegian Overnight Weighted Average rate from the norwegian central bank after 2013. NIBOR before that.
Sectorvarchar(50)Sector
FROM [OSE].[dbo].[equity]


    Fields of table "bondindex" (Bonds Index)
Field nameTypeDescription
Datedate(3)Date
SecurityIdbigint(8)Security id
Symbolvarchar(16)Symbol
Namevarchar(50)Name of index
IndexTypevarchar(10)Type of index
Openfloat(8)Open price
Highfloat(8)Higest observed price during trading day
Lowfloat(8)Lowest observed price during trading day
Closefloat(8)Closing price
OpenYieldfloat(8)Yield given opening price
CloseYieldfloat(8)Yield given closing price
OpenDurationfloat(8)Duration given opening price
CloseDurationfloat(8)Duration given closing price
FROM [OSE].[dbo].[bondindex]


    Fields of table "WarrantsInfo" (Warrants info)
Field nameTypeDescription
FromDatedate(3)Date issued
ToDatedate(3)Date of expiry
SecurityIdbigint(8)Security ID
Symbolvarchar(22)Symbol
CompanyIdbigint(8)Company ID
CurrencyCodevarchar(10)Currency of annual report
SubscriptionPricefloat(8)Subscription price
WarrantTypeint(4)Type of warrant
UnderlyingSecuritybigint(8)SID of underlying security
TermsSharesfloat(8)Terms shares
WarrantsIssuedfloat(8)Numbers of warrants issued
TermsWarrantsfloat(8)Terms warrants
SecurityTypeint(4)Allways 5
ISINvarchar(24)ISIN
SecurityNamevarchar(50)Name
Currencyvarchar(3)Currency. Currently allways NOK
Exchangevarchar(10)Exhange
EquityClassIdint(4)Equity class id
Descriptionvarchar(40)Description
FROM [OSE].[dbo].[WarrantsInfo]


    Fields of table "Warrants" (Warrants)
Field nameTypeDescription
Datedate(3)Date
SecurityIdbigint(8)Security id
CompanyIdbigint(8)Company id
Symbolvarchar(16)Symbol
ISINvarchar(13)ISIN
Namevarchar(50) of associated equity
BestBidPricefloat(8)Best bid price
BestAskPricefloat(8)Best ask price
Openfloat(8)Open price
Highfloat(8)Higest observed price during trading day
Lowfloat(8)Lowest observed price during trading day
Closefloat(8)Closing price
OfficialNumberOfTradesfloat(8)Official number of trades
OfficialVolumefloat(8)Official volume
UnofficialNumberOfTradesfloat(8)Unofficial number of trades
UnofficialVolumefloat(8)Unofficial volume
VolumeWeightedAveragePricefloat(8)Volume weighted average price
Pricefloat(8)Price
Currencyvarchar(3)Currency. Currently allways NOK
Descriptionvarchar(40)Description
CountryCodevarchar(10)Country code
NOKPerForexfloat(8)Exchange rate. Currently allways 1
PriceNOKfloat(8)Price in NOK
FROM [OSE].[dbo].[Warrants]


    Fields of table "SecuritiesInfo" (Stocks info)
Field nameTypeDescription
EventDatedate(3)Event date
ToDatedate(3)To date
FromDatedate(3)From date
CompanyIdbigint(8)Company id
ISINvarchar(24)ISIN
Namevarchar(50)Name
Symbolvarchar(22)Symbol
SecurityIdbigint(8)Security id
SecurityNamevarchar(50)Security name
SecurityTypeint(4)Security type
EquityClassIdint(4)Equity class id
EventIdbigint(8)Event id
DividendIdbigint(8)Dividend id
AdjustmentFactorfloat(8)Adjustment factor for corporate events
DividendInForeignCurrencyfloat(8)Dividend in foreign currency
DividendInNOKfloat(8)Dividend in NOK
NumberOfDividendsPerYearint(4)Number of dividends per year
TypeOfDividendint(4)Type of dividend
SequenceNumberint(4)Sequence number
Pricefloat(8)Price
SubscriptionPricefloat(8)Subscription price
Descriptionvarchar(40)Description
CountryCodevarchar(10)Country code
Currencyvarchar(10)Currency. Currently allways NOK
CurrencyCodevarchar(10)Currency of annual report
Exchangevarchar(10)Exchange
Typevarchar(100)Type
NewSharesfloat(8)New shares
OldSharesfloat(8)Old shares
NumberOfSharesfloat(8)Number of shares issued (not free float adjusted)
CompanyOwnedSharesfloat(8)Company owned shares
TotalCompanyOwnedSharesfloat(8)Total company owned shares
TotalNumberOfSharesfloat(8)Total number of shares
NominalValuefloat(8)Nominal value
FROM [OSE].[dbo].[SecuritiesInfo]


    Fields of table "BondInfo" (Bonds Info)
Field nameTypeDescription
Typevarchar(100)Type
SecurityIdbigint(8)Security id
SecurityTypeint(4)Security type
Symbolvarchar(16)Symbol
ISINvarchar(24)ISIN
SecurityNamevarchar(78)Security name
EqNamevarchar(50)Name of associated equity
EqSecurityIDbigint(8)Security ID of associated equity
eqISINvarchar(24)ISIN of associated equity
CompanyIdbigint(8)Company id
Issuervarchar(72)Issuer
FromDatedate(3)From date
ToDatedate(3)To date
IssueDatedate(3)Issue date
MaturityDatedate(3)Maturity date
ActualMaturityDatedate(3)Acutal maturity date
CouponDatedate(3)Coupon date
OpeningDatedate(3)Opening date
ClosingDatedate(3)Closing date
ExpirationDatedate(3)Expiration date
AnnouncementDatedate(3)Announcement date
InterestRegulationDatedate(3)Interest regulation date
CurrencyCodevarchar(10)Currency of annual report
CountryCodevarchar(10)Country code
SectorIdint(4)Sector id
Exchangeint(4)Exchange
ListingTypeint(4)Listing type
BondIssueTypeint(4)Bond issue type
BondTypeint(4)Bond type
AmortizationTypeint(4)Amortization type
DownPaymentMethodint(4)Down payment method
BondDescriptionvarchar(1000)Bond description
InterestAsOfdate(3)Interest as of
FirstCouponPaymentdate(3)First coupon payment
FirstDownPaymentdate(3)First down payment
CouponRatefloat(8)Coupon rate
CouponInformationint(4)Coupon information
CouponSpreadfloat(8)Coupon spread
FirstCouponRatedate(3)First coupon rate
SecondCouponRatedate(3)Second coupon rate
RiskCategoryint(4)Risk category
BondSectorint(4)Bond sector
CSDint(4)CSD
MaxAmountfloat(8)Max amount
DenominationAmountfloat(8)Denomination amount
CashFlowDatedate(3)Cash flow date
CashFlowTypeIdint(4)Cash flow Type ID
Pricefloat(8)Price
NominalAmountVPSfloat(8)Nominal amount VPS
NominalAmountTotalfloat(8)Nominal amount total
OptionTypevarchar(3)Option type
TimeTypeint(4)Time type
ExCountint(4)Ex count
FROM [OSE].[dbo].[BondInfo]


    Fields of table "equityindex" (Stocks indicies)
Field nameTypeDescription
IDbigint(8)ID
Datedate(3)Date
SecurityIdbigint(8)Security id
Symbolvarchar(22)Symbol
Namevarchar(100)Name
Openfloat(8)Open price
Highfloat(8)Higest observed price during trading day
Lowfloat(8)Lowest observed price during trading day
Lastfloat(8)Last observed price
lnDeltafloat(8)log change in index value
FROM [OSE].[dbo].[equityindex]


    Fields of table "FutureForwards" (Futures and forwards)
Field nameTypeDescription
IDbigint(8)ID
Datedate(3)Date
SecurityIdbigint(8)Security id
IssuerNamevarchar(50)Issuer name
Symbolvarchar(20)Symbol
ISINvarchar(24)ISIN
ContractSymbolvarchar(10)Contract symbol
Descriptionvarchar(30)Description
ExDatedate(3)Ex date
IssuerSecurityIdbigint(8)Issuer security id
IssuerSymbolvarchar(10)Issuer symbol
BestBidPricefloat(8)Best bid price
BestAskPricefloat(8)Best ask price
Openfloat(8)Open price
Highfloat(8)Higest observed price during trading day
Lowfloat(8)Lowest observed price during trading day
LastTradedPricefloat(8)Last traded price
NumberOfTradesfloat(8)Number of trades
Volumefloat(8)Volume
VolumeWeightedAveragePricefloat(8)Volume weighted average price
FROM [OSE].[dbo].[FutureForwards]


    Fields of table "mutualfund" (Mutual funds)
Field nameTypeDescription
IDbigint(8)ID
Datedate(3)Date
SecurityIdbigint(8)Security id
FundIdbigint(8)Fund ID
Symbolvarchar(24)Symbol
ISINvarchar(24)ISIN
Namevarchar(100)Name
NAVfloat(8)Net Asset Value, fair value of the fund share
NAVAdjfloat(8)Net Asset Value, fair value of the fund share
Dividendsfloat(8)Last payed dividend
CorpAdjfloat(8)Corp adjustments (splits etc.)
DividendAdjfloat(8)Dividend adjustment factor
lnDeltaNAVfloat(8)log return NAV (Adjusted)
lnDeltaOSEBXfloat(8)log return of the OSEBX index
lnDeltaOBXfloat(8)log return of the OBX index
lnDeltaOSEFXfloat(8)log return OSEFX
SMBfloat(8)SMB Fama-French factor
HMLfloat(8)HML Fama french factor
LIQfloat(8)LIQ Pastor-Stambaugh factor
MOMfloat(8)MOM Fama-French factor
FROM [OSE].[dbo].[mutualfund]


    Fields of table "factors" (Equity factors)
Field nameTypeDescription
Datedate(3)Date
HML_H_Bfloat(8)High B/M and small size portf.
HML_H_Sfloat(8)High B/M and small size portf.
HML_L_Bfloat(8)Low B/M and big size portf.
HML_L_Sfloat(8)Low B/M and small size portf.
HML_N_Bfloat(8)Neutral B/M and big size portf.
HML_N_Sfloat(8)Neutral B/M and small size portf.
LIQ_H_Bfloat(8)High liquidity and big size portf.
LIQ_H_Sfloat(8)High liquidity and small size portf.
LIQ_L_Bfloat(8)Low liquidity and big size portf.
LIQ_L_Sfloat(8)Low liquidity and small size portf.
LIQ_N_Bfloat(8)Neutr. liquidity and big size portf.
LIQ_N_Sfloat(8)Neutr. liquidity and small size portf.
MOM_H_Bfloat(8)High momentum and big size portf.
MOM_H_Sfloat(8)High momentum and small size portf.
MOM_L_Bfloat(8)Low momentum and big size portf.
MOM_L_Sfloat(8)Low momentum and small size portf.
MOM_N_Bfloat(8)Neutr. momentum and big size portf.
MOM_N_Sfloat(8)Neutr. momentum and small size portf.
size_N_Bfloat(8)Big firms portfolio
size_N_Sfloat(8)Small firms portfolio
TOT_N_Mfloat(8)Total portfolio (i.e. SMBX)
SMBfloat(8)Fama-French small firms effect
HMLfloat(8)Fama-French value effect
LIQfloat(8)Pastor-Staumbaugh liquidity effect
MOMfloat(8)Fama-French momentume effect
FROM [OSE].[dbo].[factors]


    Fields of table "bonds" (Bonds)
Field nameTypeDescription
Datedate(3)Date
FromDatedate(3)Issuing date
MaturityDatedate(3)Maturity date
SecurityIdbigint(8)Security id
CompanyIdbigint(8)Company id
Namevarchar(100)Name of bond
Issuervarchar(100)Issuer
Equity_SecurityIDbigint(8)SID of issuer equity (if listed)
Equity_Symbolvarchar(22)Symbol of issuer equity (if listed)
ISINSubCodevarchar(10)ISINSub code
BondTypeint(4)Bond type
Symbolvarchar(16)Symbol
ISINvarchar(24)ISIN
CouponRatefloat(8)Coupon rate
OpenPricefloat(8)Open price
Highfloat(8)Higest observed price during trading day
Lowfloat(8)Lowest observed price during trading day
LastTradedPricefloat(8)Last traded price
OfficialVolumefloat(8)Official volume
UnofficialVolumefloat(8)Unofficial volume
BestBidPricefloat(8)Best bid price
BestAskPricefloat(8)Best ask price
FROM [OSE].[dbo].[bonds]


    Fields of table "options" (Options)
Field nameTypeDescription
Datedate(3)Date
SecurityIDbigint(8)Security id
Symbolvarchar(16)Symbol
ISINvarchar(13)ISIN
Namevarchar(100)Name of company
ExpirationDatedate(3)Expiration date
UnderlyingSIDbigint(8)Security ID of underlying security
UnderlyingISINvarchar(24)ISIN of underlying security
UnderlyingNamevarchar(50)Name of underlying security
UnderlyingSymbolvarchar(13)Symbol of underlying security
BestBidPricefloat(8)Best bid price
BestAskPricefloat(8)Best ask price
Lastfloat(8)Last observed price
Openfloat(8)Open price
Highfloat(8)Higest observed price during trading day
Lowfloat(8)Lowest observed price during trading day
Volumfloat(8)Volume
OpenInterestfloat(8)Open interest
Strikefloat(8)Strike price
IsCallint(4)Call (true) or Put (false)
FROM [OSE].[dbo].[options]


    Fields of table "account" (Accounting)
Field nameTypeDescription
Namevarchar(50)Name of company
SecurityIdbigint(8)Security id
companyIDbigint(8)Company id
OrganizationIDbigint(8)Organization ID (Brnnysund)
Yearbigint(8)Year
descriptionvarchar(100)Description
desc_simpl_envarchar(100)English description
desc_simpl_novarchar(100)Norwegian description
account_numberbigint(8)Number representing the account item
account_typevarchar(100)Can be Costs, Current assets, Debt Equity, Fixed assets or Revenue
Valuefloat(8)Nummeric value (amount)
sourcevarchar(11)Where the data was fetched from
Corporationint(4)True if its is corporate accounting
FROM [OSE].[dbo].[account]