Developed by Espen Sirnes
login
more
TABLES
INFO (UIT.NO)
 INSTALL R/Python


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`,
`Internal code`,
`SecurityId`,
`CompanyId`,
`Symbol`,
`ISIN`,
`Name`,
`BestBidPrice`,
`BestAskPrice`,
`Open`,
`High`,
`Low`,
`Close`,
`NumberOfTrades`,
`Volume`,
`Turnover`,
`VolumeWeightedAveragePrice`,
`Price`,
`AdjustedPrice`,
`Dividends`,
`LDividends`,
`CorpAdj`,
`DividendAdj`,
`Currency`,
`NumberOfShares`,
`NumberSharesOSEBX`,
`Exchange`,
`NOKPerForex`,
`mktcap`,
`OSEBXmktshare_prevmnth`,
`OSEBXAlpha_prevmnth`,
`OSEBXBeta_prevmnth`,
`SMB`,
`HML`,
`LIQ`,
`MOM`,
`lnDeltaP`,
`lnDeltaOSEBX`,
`lnDeltaOBX`,
`NOWA_DayLnrate`,
`bills_3month_Lnrate`,
`Sector`,
`IN_OSEBX`,
`Equity`,
`Debt`,
`Earnings`,
`debt_ratio`,
`PE`,
`ID`
    FROM `OSE`.`equity`

    Table "AllISINS" (All ISINs)

    SELECT
`Name`,
`Internal code`,
`SecurityId`,
`ISIN`
    FROM `OSE`.`AllISINS`

    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`,
`ID`
    FROM `OSE`.`factors`

    Table "account" (Accounting)

    SELECT
`Name`,
`ISIN`,
`companyID`,
`OrganizationID`,
`Year`,
`description`,
`desc_simpl_en`,
`desc_simpl_no`,
`account_number`,
`account_type`,
`Value`,
`CorporateAccountValue`,
`CompanyAccountValue`,
`source`,
`Corporation`,
`ID`
    FROM `OSE`.`account`

    Table "equityindex_linked" (equityindex_linked)

    SELECT
`Date`,
`OSEBXLinked`,
`OBXLinked`,
`OSEFXLinked`,
`ID`
    FROM `OSE`.`equityindex_linked`

    Table "equityindex" (Stocks indicies)

    SELECT
`Date`,
`SecurityId`,
`Internal code`,
`ISIN code`,
`Symbol`,
`Name`,
`Open`,
`High`,
`Low`,
`Last`,
`ID`
    FROM `OSE`.`equityindex`

    Table "bondindex" (Bonds Index)

    SELECT
`Date`,
`SecurityId`,
`Symbol`,
`Name`,
`IndexType`,
`Open`,
`High`,
`Low`,
`Close`,
`OpenYield`,
`CloseYield`,
`OpenDuration`,
`CloseDuration`
    FROM `OSE`.`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`.`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`.`Warrants`

    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`.`BondInfo`

    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`.`FutureForwards`

    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`.`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`.`options`

    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`.`SecuritiesInfo`

    Table "newsweb" (News bulletins)

    SELECT
`publishTime`,
`NewsWebName`,
`EquityName`,
`EquitySecurityID`,
`CompanyId`,
`EquitySymbol`,
`EquityISIN`,
`issuerStatus`,
`title`,
`category`,
`market`,
`text`
    FROM `OSE`.`newsweb`

    Table "mutualfund" (Mutual funds)

    SELECT
`Date`,
`Name`,
`Symbol`,
`SecurityId`,
`ISIN`,
`NAV`,
`FundId`,
`Adjusted Price`,
`Dividends`,
`CorpAdj`,
`DividendAdj`,
`lnDeltaNAV`,
`lnDeltaOSEBX`,
`lnDeltaOBX`,
`lnDeltaOSEFX`,
`SMB`,
`HML`,
`LIQ`,
`MOM`,
`ID`
    FROM `OSE`.`mutualfund`