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

               

    Table "equity" (Equity)

    SELECT
[Date],
[SecurityId],
[CompanyId],
[Symbol],
[ISIN],
[Name],
[BestBidPrice],
[BestAskPrice],
[Open],
[High],
[Low],
[Close],
[OfficialNumberOfTrades],
[OfficialVolume],
[UnofficialNumberOfTrades],
[UnofficialVolume],
[VolumeWeightedAveragePrice],
[Price],
[AdjustedPrice],
[Dividends],
[LDividends],
[CorpAdj],
[DividendAdj],
[Currency],
[Description],
[CountryCode],
[SumAnnualDividends],
[NumberOfShares],
[CompanyOwnedShares],
[OutstandingShares],
[Exchange],
[NOKPerForex],
[mktcap],
[OSEBXmktshare_prevmnth],
[OSEBXAlpha_prevmnth],
[OSEBXBeta_prevmnth],
[SMB],
[HML],
[LIQ],
[MOM],
[DividendPriceRatio],
[lnDeltaP],
[lnDeltaOSEBX],
[lnDeltaOBX],
[NOWA_DayLnrate],
[Sector],
[IN_OSEBX],
[Equity],
[Debt],
[Earnings],
[debt_ratio],
[PE]
    FROM [OSE].[dbo].[equity]

    Table "factors" (Equity factors)

    SELECT
[Date],
[HML_H_B],
[HML_H_S],
[HML_L_B],
[HML_L_S],
[HML_N_B],
[HML_N_S],
[LIQ_H_B],
[LIQ_H_S],
[LIQ_L_B],
[LIQ_L_S],
[LIQ_N_B],
[LIQ_N_S],
[MOM_H_B],
[MOM_H_S],
[MOM_L_B],
[MOM_L_S],
[MOM_N_B],
[MOM_N_S],
[size_N_B],
[size_N_S],
[TOT_N_M],
[SMB],
[HML],
[LIQ],
[MOM]
    FROM [OSE].[dbo].[factors]

    Table "bonds" (Bonds)

    SELECT
[Date],
[FromDate],
[MaturityDate],
[SecurityId],
[CompanyId],
[Name],
[Issuer],
[Equity_SecurityID],
[Equity_Symbol],
[ISINSubCode],
[BondType],
[Symbol],
[ISIN],
[CouponRate],
[OpenPrice],
[High],
[Low],
[LastTradedPrice],
[OfficialVolume],
[UnofficialVolume],
[BestBidPrice],
[BestAskPrice]
    FROM [OSE].[dbo].[bonds]

    Table "options" (Options)

    SELECT
[Date],
[SecurityID],
[Symbol],
[ISIN],
[Name],
[ExpirationDate],
[UnderlyingSID],
[UnderlyingISIN],
[UnderlyingName],
[UnderlyingSymbol],
[BestBidPrice],
[BestAskPrice],
[Last],
[Open],
[High],
[Low],
[Volum],
[OpenInterest],
[Strike],
[IsCall]
    FROM [OSE].[dbo].[options]

    Table "account" (Accounting)

    SELECT
[Name],
[SecurityId],
[companyID],
[OrganizationID],
[Year],
[description],
[desc_simpl_en],
[desc_simpl_no],
[account_number],
[account_type],
[Value],
[source],
[Corporation]
    FROM [OSE].[dbo].[account]

    Table "bondindex" (Bonds Index)

    SELECT
[Date],
[SecurityId],
[Symbol],
[Name],
[IndexType],
[Open],
[High],
[Low],
[Close],
[OpenYield],
[CloseYield],
[OpenDuration],
[CloseDuration]
    FROM [OSE].[dbo].[bondindex]

    Table "WarrantsInfo" (Warrants info)

    SELECT
[FromDate],
[ToDate],
[SecurityId],
[Symbol],
[CompanyId],
[CurrencyCode],
[SubscriptionPrice],
[WarrantType],
[UnderlyingSecurity],
[TermsShares],
[WarrantsIssued],
[TermsWarrants],
[SecurityType],
[ISIN],
[SecurityName],
[Currency],
[Exchange],
[EquityClassId],
[Description]
    FROM [OSE].[dbo].[WarrantsInfo]

    Table "Warrants" (Warrants)

    SELECT
[Date],
[SecurityId],
[CompanyId],
[Symbol],
[ISIN],
[Name],
[BestBidPrice],
[BestAskPrice],
[Open],
[High],
[Low],
[Close],
[OfficialNumberOfTrades],
[OfficialVolume],
[UnofficialNumberOfTrades],
[UnofficialVolume],
[VolumeWeightedAveragePrice],
[Price],
[Currency],
[Description],
[CountryCode],
[NOKPerForex],
[PriceNOK]
    FROM [OSE].[dbo].[Warrants]

    Table "SecuritiesInfo" (Stocks info)

    SELECT
[EventDate],
[ToDate],
[FromDate],
[CompanyId],
[ISIN],
[Name],
[Symbol],
[SecurityId],
[SecurityName],
[SecurityType],
[EquityClassId],
[EventId],
[DividendId],
[AdjustmentFactor],
[DividendInForeignCurrency],
[DividendInNOK],
[NumberOfDividendsPerYear],
[TypeOfDividend],
[SequenceNumber],
[Price],
[SubscriptionPrice],
[Description],
[CountryCode],
[Currency],
[CurrencyCode],
[Exchange],
[Type],
[NewShares],
[OldShares],
[NumberOfShares],
[CompanyOwnedShares],
[TotalCompanyOwnedShares],
[TotalNumberOfShares],
[NominalValue]
    FROM [OSE].[dbo].[SecuritiesInfo]

    Table "BondInfo" (Bonds Info)

    SELECT
[Type],
[SecurityId],
[SecurityType],
[Symbol],
[ISIN],
[SecurityName],
[EqName],
[EqSecurityID],
[eqISIN],
[CompanyId],
[Issuer],
[FromDate],
[ToDate],
[IssueDate],
[MaturityDate],
[ActualMaturityDate],
[CouponDate],
[OpeningDate],
[ClosingDate],
[ExpirationDate],
[AnnouncementDate],
[InterestRegulationDate],
[CurrencyCode],
[CountryCode],
[SectorId],
[Exchange],
[ListingType],
[BondIssueType],
[BondType],
[AmortizationType],
[DownPaymentMethod],
[BondDescription],
[InterestAsOf],
[FirstCouponPayment],
[FirstDownPayment],
[CouponRate],
[CouponInformation],
[CouponSpread],
[FirstCouponRate],
[SecondCouponRate],
[RiskCategory],
[BondSector],
[CSD],
[MaxAmount],
[DenominationAmount],
[CashFlowDate],
[CashFlowTypeId],
[Price],
[NominalAmountVPS],
[NominalAmountTotal],
[OptionType],
[TimeType],
[ExCount]
    FROM [OSE].[dbo].[BondInfo]

    Table "equityindex" (Stocks indicies)

    SELECT
[ID],
[Date],
[SecurityId],
[Symbol],
[Name],
[Open],
[High],
[Low],
[Last],
[lnDelta]
    FROM [OSE].[dbo].[equityindex]

    Table "FutureForwards" (Futures and forwards)

    SELECT
[ID],
[Date],
[SecurityId],
[IssuerName],
[Symbol],
[ISIN],
[ContractSymbol],
[Description],
[ExDate],
[IssuerSecurityId],
[IssuerSymbol],
[BestBidPrice],
[BestAskPrice],
[Open],
[High],
[Low],
[LastTradedPrice],
[NumberOfTrades],
[Volume],
[VolumeWeightedAveragePrice]
    FROM [OSE].[dbo].[FutureForwards]

    Table "mutualfund" (Mutual funds)

    SELECT
[ID],
[Date],
[SecurityId],
[FundId],
[Symbol],
[ISIN],
[Name],
[NAV],
[NAVAdj],
[Dividends],
[CorpAdj],
[DividendAdj],
[lnDeltaNAV],
[lnDeltaOSEBX],
[lnDeltaOBX],
[lnDeltaOSEFX],
[SMB],
[HML],
[LIQ],
[MOM]
    FROM [OSE].[dbo].[mutualfund]