Пример #1
0
        /// <summary>
        /// Parses the web response html content from <see cref="SecForm.HtmlFormLink"/> 
        /// locating the .xml Uri therein.
        /// </summary>
        /// <param name="webResponseBody"></param>
        /// <param name="srcUri"></param>
        /// <param name="pc"></param>
        /// <returns></returns>
        public static bool TryGetXmlLink(object webResponseBody, Uri srcUri, ref PublicCorporation pc)
        {
            var pcAnnualRpt = pc.SecReports?.FirstOrDefault(x => x.HtmlFormLink == srcUri);
            if (pcAnnualRpt == null)
                return false;
            var myDynData = Etx.DynamicDataFactory(srcUri);
            var myDynDataRslt = myDynData.ParseContent(webResponseBody);
            if (myDynDataRslt == null || !myDynDataRslt.Any())
                return false;

            var xrblUriStr = myDynDataRslt.First().XrblUri;

            pcAnnualRpt.XmlLink = new Uri(xrblUriStr);
            var irsId = myDynDataRslt.First().IrsId as string;
            if(!string.IsNullOrWhiteSpace(irsId))
                pc.EIN = new EmployerIdentificationNumber {Value = irsId};

            return true;
        }
Пример #2
0
        /// <summary>
        /// Merges the XBRL xml from the SEC filing for the given <see cref="pc"/> 
        /// </summary>
        /// <param name="webResponseBody">The raw XML content from the SEC</param>
        /// <param name="srcUri"></param>
        /// <param name="pc"></param>
        /// <returns></returns>
        public static bool TryMergeXbrlInto10K(object webResponseBody, Uri srcUri, ref PublicCorporation pc)
        {
            var rptTenK =
                pc?.SecReports.FirstOrDefault(x => x is Form10K && ((Form10K)x).XmlLink == srcUri) as Form10K;
            if (rptTenK == null)
                return false;

            var myDynData = Etx.DynamicDataFactory(srcUri);
            var myDynDataRslt = myDynData.ParseContent(webResponseBody);
            if (myDynDataRslt == null || !myDynDataRslt.Any())
                return false;

            if (rptTenK.FinancialData == null)
                rptTenK.FinancialData = new ComFinancialData
                {
                    Assets = new NetConAssets(),
                    Income = new NetConIncome()
                };

            var xbrlDyn = myDynDataRslt.First();
            var cik = xbrlDyn.Cik;
            if (pc.CIK.Value != cik)
                return false;
            if (rptTenK.CIK == null)
                rptTenK.CIK = new CentralIndexKey {Value = cik};

            var ticker = xbrlDyn.Ticker ??
                         srcUri?.LocalPath.Split('/').LastOrDefault()?.Split('-').FirstOrDefault()?.ToUpper();

            if (ticker != null &&
                pc.TickerSymbols.All(x => !string.Equals(x.Symbol, ticker, StringComparison.OrdinalIgnoreCase)))
            {
                ticker = ticker.ToUpper();
                pc.TickerSymbols.Add(new Ticker {Symbol = ticker, Country = "USA"});
            }

            var legalName = xbrlDyn.Name;
            pc.UpsertName(KindsOfNames.Legal, legalName);

            rptTenK.FinancialData.NumOfShares = xbrlDyn.NumOfShares;
            if (xbrlDyn.EndOfYear > 0)
                pc.FiscalYearEndDay = xbrlDyn.EndOfYear;

            var assets = xbrlDyn.Assets as List<Tuple<int, decimal>>;
            var rptVal = assets?.OrderByDescending(x => x.Item1).FirstOrDefault();
            if (rptVal != null)
            {
                rptTenK.FinancialData.Assets.TotalAssets = new Pecuniam(rptVal.Item2);
                rptTenK.FinancialData.FiscalYear = rptTenK.FinancialData.FiscalYear < rptVal.Item1
                    ? rptVal.Item1
                    : rptTenK.FinancialData.FiscalYear;
            }

            var lias = xbrlDyn.Liabilities as List<Tuple<int, decimal>>;
            rptVal = lias?.OrderByDescending(x => x.Item1).FirstOrDefault();
            if (rptVal != null)
            {
                rptTenK.FinancialData.Assets.TotalLiabilities = new Pecuniam(rptVal.Item2);
                rptTenK.FinancialData.FiscalYear = rptTenK.FinancialData.FiscalYear < rptVal.Item1
                    ? rptVal.Item1
                    : rptTenK.FinancialData.FiscalYear;
            }

            var nis = xbrlDyn.NetIncome as List<Tuple<int, decimal>>;
            rptVal = nis?.OrderByDescending(x => x.Item1).FirstOrDefault();
            if (rptVal != null)
            {
                rptTenK.FinancialData.Income.NetIncome = new Pecuniam(rptVal.Item2);
                rptTenK.FinancialData.FiscalYear = rptTenK.FinancialData.FiscalYear < rptVal.Item1
                    ? rptVal.Item1
                    : rptTenK.FinancialData.FiscalYear;
            }

            var ois = xbrlDyn.OperatingIncome as List<Tuple<int, decimal>>;
            rptVal = ois?.OrderByDescending(x => x.Item1).FirstOrDefault();
            if (rptVal != null)
            {
                rptTenK.FinancialData.Income.OperatingIncome = new Pecuniam(rptVal.Item2);
                rptTenK.FinancialData.FiscalYear = rptTenK.FinancialData.FiscalYear < rptVal.Item1
                    ? rptVal.Item1
                    : rptTenK.FinancialData.FiscalYear;
            }

            var revs = xbrlDyn.Revenue as List<Tuple<int, decimal>>;
            rptVal = revs?.OrderByDescending(x => x.Item1).FirstOrDefault();
            if (rptVal != null)
            {
                rptTenK.FinancialData.Income.Revenue = new Pecuniam(rptVal.Item2);
                rptTenK.FinancialData.FiscalYear = rptTenK.FinancialData.FiscalYear < rptVal.Item1
                    ? rptVal.Item1
                    : rptTenK.FinancialData.FiscalYear;
            }

            rptTenK.FinancialData.Income.Src = srcUri.ToString();
            rptTenK.FinancialData.Assets.Src = srcUri.ToString();

            return true;
        }
Пример #3
0
        public void TestTryGetCorpData()
        {
            var xmlContent = System.IO.File.ReadAllText(SEC_BY_CIK_XML_PATH);

            var testResultOut = new PublicCorporation();
            var testResult = NoFuture.Rand.Gov.Sec.Edgar.TryParseCorpData(xmlContent,
                new Uri(
                    "http://www.sec.gov/cgi-bin/browse-edgar?action=getcompany&CIK=041215216456&type=10-K&dateb=&owner=exclude&count=100&output=atom"),
                ref testResultOut);

            Assert.IsTrue(testResult);
            Assert.IsNotNull(testResultOut);

            Assert.AreEqual("0000717538", testResultOut.CIK.Value);
            Assert.AreEqual("6021", testResultOut.SIC.Value);
            Assert.AreEqual("ARROW FINANCIAL CORP", testResultOut.Name);

            Assert.IsNotNull(testResultOut.MailingAddress);
            Assert.IsNotNull(testResultOut.BusinessAddress);

            Assert.AreEqual("250", testResultOut.BusinessAddress.Item1.PostBox);
            Assert.AreEqual("GLEN", testResultOut.BusinessAddress.Item1.StreetName);
            Assert.AreEqual("ST", testResultOut.BusinessAddress.Item1.StreetKind);

            Assert.AreEqual("250", testResultOut.MailingAddress.Item1.PostBox);
            //Assert.AreEqual("GLEN STREET", testResultOut.MailingAddress.Item1.StreetName);

            Assert.AreEqual("GLENS FALLS", testResultOut.BusinessAddress.Item2.City);
            Assert.AreEqual("NY", testResultOut.BusinessAddress.Item2.PostalState);
            Assert.AreEqual("12801", testResultOut.BusinessAddress.Item2.ZipCode);

            Assert.AreEqual("GLENS FALLS", testResultOut.MailingAddress.Item2.City);
            Assert.AreEqual("NY", testResultOut.MailingAddress.Item2.PostalState);
            Assert.AreEqual("12801", testResultOut.MailingAddress.Item2.ZipCode);

            Assert.IsNotNull(testResultOut.Phone);
            Assert.IsNotNull(testResultOut.Phone[0]);
            Assert.AreEqual("518", testResultOut.Phone[0].AreaCode);
            Assert.AreEqual("415", testResultOut.Phone[0].CentralOfficeCode);
            Assert.AreEqual("4299", testResultOut.Phone[0].SubscriberNumber);
        }
Пример #4
0
        /// <summary>
        /// Merges the ticker symbol data contained in <see cref="webResponseBody"/> into the instance of <see cref="PublicCorporation"/>
        /// </summary>
        /// <param name="webResponseBody"></param>
        /// <param name="srcUri"></param>
        /// <param name="pc"></param>
        /// <returns></returns>
        public static bool TryMergeTickerLookup(object webResponseBody, Uri srcUri, ref PublicCorporation pc)
        {
            try
            {
                var myDynData = Etx.DynamicDataFactory(srcUri);
                var myDynDataRslt = myDynData.ParseContent(webResponseBody);
                if (myDynDataRslt == null)
                    return false;

                foreach (var dd in myDynDataRslt)
                {
                    var existing = pc.TickerSymbols.FirstOrDefault(x => x.Symbol == dd.Symbol && x.Country == dd.Country);
                    if (existing != null)
                    {
                        existing.Src = myDynData.SourceUri.ToString();
                        existing.InstrumentType = dd.InstrumentType;
                        continue;
                    }
                    pc.TickerSymbols.Add(new Ticker
                    {
                        Symbol = dd.Symbol,
                        InstrumentType = dd.InstrumentType,
                        Country = dd.Country,
                        Src = myDynData.SourceUri.ToString()
                    });
                }

                return pc.TickerSymbols.Count > 0;
            }
            catch
            {
                return false;
            }
        }
Пример #5
0
 public static Uri GetUri(PublicCorporation com)
 {
     return new Uri("http://www.bloomberg.com/markets/symbolsearch?query=" + com.UrlEncodedName + "&commit=Find+Symbols");
 }