|
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
FROM `OSE`.`equity`
Table "AllISINS" (All ISINs)
SELECT
FROM `OSE`.`AllISINS`
Table "factors" (Equity factors)
SELECT
FROM `OSE`.`factors`
Table "account" (Accounting)
SELECT
FROM `OSE`.`account`
Table "equityindex_linked" (equityindex_linked)
SELECT
FROM `OSE`.`equityindex_linked`
Table "bondindex" (Bonds Index)
SELECT
FROM `OSE`.`bondindex`
Table "WarrantsInfo" (Warrants info)
SELECT
FROM `OSE`.`WarrantsInfo`
Table "Warrants" (Warrants)
SELECT
FROM `OSE`.`Warrants`
Table "BondInfo" (Bonds Info)
SELECT
FROM `OSE`.`BondInfo`
Table "FutureForwards" (Futures and forwards)
SELECT
FROM `OSE`.`FutureForwards`
Table "bonds" (Bonds)
SELECT
FROM `OSE`.`bonds`
Table "options" (Options)
SELECT
FROM `OSE`.`options`
Table "mutualfund" (Mutual funds)
SELECT
FROM `OSE`.`mutualfund`
Table "SecuritiesInfo" (Stocks info)
SELECT
FROM `OSE`.`SecuritiesInfo`
Table "equityindex" (Stocks indicies)
SELECT
FROM `OSE`.`equityindex`
Table "newsweb" (News bulletins)
SELECT
FROM `OSE`.`newsweb`
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`, |
| `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` |
Table "AllISINS" (All ISINs)
SELECT
| `Name`, |
| `Internal code`, |
| `SecurityId`, |
| `ISIN` |
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` |
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` |
Table "equityindex_linked" (equityindex_linked)
SELECT
| `Date`, |
| `OSEBXLinked`, |
| `OBXLinked`, |
| `OSEFXLinked`, |
| `ID` |
Table "bondindex" (Bonds Index)
SELECT
| `Date`, |
| `SecurityId`, |
| `Symbol`, |
| `Name`, |
| `IndexType`, |
| `Open`, |
| `High`, |
| `Low`, |
| `Close`, |
| `OpenYield`, |
| `CloseYield`, |
| `OpenDuration`, |
| `CloseDuration` |
Table "WarrantsInfo" (Warrants info)
SELECT
| `FromDate`, |
| `ToDate`, |
| `SecurityId`, |
| `Symbol`, |
| `CompanyId`, |
| `CurrencyCode`, |
| `SubscriptionPrice`, |
| `WarrantType`, |
| `UnderlyingSecurity`, |
| `TermsShares`, |
| `WarrantsIssued`, |
| `TermsWarrants`, |
| `SecurityType`, |
| `ISIN`, |
| `SecurityName`, |
| `Currency`, |
| `Exchange`, |
| `EquityClassId`, |
| `Description` |
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` |
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` |
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` |
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` |
Table "options" (Options)
SELECT
| `Date`, |
| `SecurityID`, |
| `Symbol`, |
| `ISIN`, |
| `Name`, |
| `ExpirationDate`, |
| `UnderlyingSID`, |
| `UnderlyingISIN`, |
| `UnderlyingName`, |
| `UnderlyingSymbol`, |
| `BestBidPrice`, |
| `BestAskPrice`, |
| `Last`, |
| `Open`, |
| `High`, |
| `Low`, |
| `Volum`, |
| `OpenInterest`, |
| `Strike`, |
| `IsCall` |
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` |
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` |
Table "equityindex" (Stocks indicies)
SELECT
| `ID`, |
| `Date`, |
| `SecurityId`, |
| `Symbol`, |
| `Name`, |
| `Open`, |
| `High`, |
| `Low`, |
| `Last`, |
| `lnDelta` |
Table "newsweb" (News bulletins)
SELECT
| `publishTime`, |
| `NewsWebName`, |
| `EquityName`, |
| `EquitySecurityID`, |
| `CompanyId`, |
| `EquitySymbol`, |
| `EquityISIN`, |
| `issuerStatus`, |
| `title`, |
| `category`, |
| `market`, |
| `text` |
Warning: readfile(tail.html): Failed to open stream: No such file or directory in C:\inetpub\wwwroot\SAML\www\tabledefssel.php on line 430