public void CategoriseBergTickersIntoTorontoAssetTypes(DateTime effectiveDate) { var mgr = new TorontoViewManager(); var tickers = mgr.GetBergMonikersFromDataWarehouse(effectiveDate); foreach (var ticker in tickers) { var thisBergId = new BergTicker(ticker.Key); var fieldList = ticker.Value; var sql = new StringBuilder(); sql.AppendFormat("update bloombergdatawarehouse set tor_longtype = '{0}',", thisBergId.TorLongType); sql.AppendFormat("tor_moniker_lookup = '{0}',", thisBergId.TorTickerLookup); sql.AppendFormat("berg_id_type = '{0}',", thisBergId.BergIdType); sql.AppendFormat("TOR_ID = '{0}',", thisBergId.TorId); sql.AppendFormat("TOR_pulltype = '{0}',", thisBergId.TorPullType); sql.AppendFormat("tor_moniker_lookup2 = '{0}',", thisBergId.TorTickerLookup2); sql.AppendFormat("REQ_DATA_SECURITY_MASTER = '{0}',", RequiresBloombergLicenseSecurityMaster(fieldList, thisBergId.TorPullType == "E") ? "Y" : "N"); sql.AppendFormat("REQ_DATA_DERIVED_INTRADAY= '{0}',", RequiresBloombergLicenseDerivedDataIntraday(fieldList) ? "Y" : "N"); sql.AppendFormat("REQ_DATA_DERIVED_EOD = '{0}',", RequiresBloombergLicenseDerivedDataEod(fieldList) ? "Y" : "N"); sql.AppendFormat("REQ_DATA_PRICING_INTRADAY= '{0}',", RequiresBloombergLicensePricingDataIntraday(fieldList, thisBergId.TorPullType == "E") ? "Y" : "N"); sql.AppendFormat("REQ_DATA_PRICING_EOD = '{0}',", RequiresBloombergLicensePricingDataEod(fieldList) ? "Y" : "N"); sql.AppendFormat("REQ_DATA_ESTIMATES = '{0}',", RequiresBloombergLicenseEstimates(fieldList) ? "Y" : "N"); sql.AppendFormat("REQ_DATA_CREDIT_RISK = '{0}'", RequiresBloombergLicenseCreditRisk(fieldList) ? "Y" : "N"); sql.AppendFormat(" where berg_moniker = '{0}' and effective_date='{1:ddMMMyyyy}'", ticker.Key, effectiveDate); Utils.DbController.ExecuteNonQuery(sql.ToString()); } }
public string GetTorontoId(BergTicker bergTicker) { string ret = bergTicker.BergTickerClean; if (bergTicker.TorLongType.StartsWith("UNKNOWN BB_GLOBAL")) { return(String.Format("{0} | {1}", bergTicker.BergTickerClean, bergTicker.BergIdType)); } if (bergTicker.TorLongType.StartsWith("FI ")) { return(string.IsNullOrEmpty(bergTicker.TorTickerLookup) ? string.Empty : String.Format("{0} | {1}", bergTicker.TorTickerLookup, bergTicker.BergIdType)); } if ((bergTicker.BergIdType.Equals("SEDOL1") && bergTicker.TorLongType.StartsWith("EQUITY"))) { return(String.Format("{0} {1} | SEDOL1", bergTicker.TorTickerLookup, bergTicker.TorTickerLookup2.Replace("SEDOL1", ""))); } if (bergTicker.BergIdType.Equals("BB_GLOBAL")) { return(String.Format("{0} | BB_GLOBAL", bergTicker.TorTickerLookup)); } if (bergTicker.TorLongType.StartsWith("FUTURE")) { ret = bergTicker.BergTickerClean; } if (bergTicker.TorLongType.StartsWith("OPTION")) { ret = bergTicker.BergTickerClean; } if (bergTicker.TorLongType.StartsWith("RATES")) { ret = bergTicker.BergTickerClean; ret = Regex.Replace(ret, " CURNCY", " Crncy", RegexOptions.IgnoreCase); } if (bergTicker.TorLongType.StartsWith("RATES LIBOR")) { ret = Regex.Replace(ret, " INDEX", " Comdty", RegexOptions.IgnoreCase); } //title case all the bloomberg suffixes foreach (var suffix in KnownBloombergSuffixes()) { ret = Regex.Replace(ret, " " + suffix, " " + new CultureInfo("en-US", false).TextInfo.ToTitleCase(suffix.ToLower()), RegexOptions.IgnoreCase); } //everything failed. dont return just the pipe if (string.IsNullOrEmpty(ret.Replace("|", "").Trim())) { return(string.Empty); } return(ret); }
public void GetDataWarehouseRequestItemsForEquitiesOnlyFromLiveAndProcessThemInDevAndCostThem() { var myList = new List<RequestItemMini>(); //override and go to prod. var prodDb = @"Data Source=minky;Initial Catalog=bloomberg;Integrated Security=SSPI"; using (SqlConnection connection = new SqlConnection(prodDb)) { connection.Open(); // using (SqlCommand command = new SqlCommand("select distinct bbticker,bbfieldlist,requesttype,UserId from BloombergDataRequestItem where insertedwhen between '1sep14' and '30sep14'", connection)) using (SqlCommand command = new SqlCommand("select distinct bbticker,bbfieldlist,requesttype,UserId from BloombergDataRequestItem", connection)) { using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { myList.Add(new RequestItemMini() { bbticker = reader[0].ToString(), FieldList = reader[1].ToString(), RequestType = reader[2].ToString(), UserId = reader[3].ToString() }); } } } } foreach (var item in myList) { //if (new BergTicker(item.bbticker).TorPullType == "E") //{ string source; if (!item.IsForLegacyBloombergAPI()) //if (!item.IsForLegacyBloombergAPI() && !item.IsForBloombergAdHoc()) { var t = new BergTicker(item.bbticker); foreach (var field in item.FieldList.Split(',')) { source = item.IsForBloombergAdHoc() ? "adhoc," : "warehouse,"; Console.WriteLine(source + item.bbticker + "," + field + "," + t.TorPullType + "," + item.UserId); } } //} } }
public void BlankTorontoIDTest() { var t = new BergTicker("CA135087B1600 Corp"); }