#xbrl — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #xbrl, aggregated by home.social.
-
#XBRL aepiot.com?q=XBRL #PYRGULINA #HONMUNGENSIS headlines-world.com?q=PYRGULINA%... #SOUTH #MIAMI #FLORIDA aepiot.ro?q=SOUTH%20MI... aéPiot - MultiSearch Tag Explorer: allgraph.ro
MultiSearch Tag Explorer -
The last two months I have been typing a relatively short introduction to XBRL from a technical point of view. The need to knows of the XML underneath, how a taxonomy is built and how to create an instance.
Intended audience: developers that have to deal with XBRL.You can grab a copy here: https://cooljapan.nl/xbrl-quickguide.pdf
-
The last two months I have been typing a relatively short introduction to XBRL from a technical point of view. The need to knows of the XML underneath, how a taxonomy is built and how to create an instance.
Intended audience: developers that have to deal with XBRL.You can grab a copy here: https://cooljapan.nl/xbrl-quickguide.pdf
-
Оптимизация обработки больших отчетов в .NET Core: от памяти к потокам
Оптимизация обработки больших отчетов в .NET Core: от памяти к потокам Отчёты росли, память заканчивалась. Пришлось отказаться от словарей в пользу потоковой сериализации JSON. Делюсь, как реализовал запись отчёта «на лету» и заставил.NET работать с гигабайтами данных без OutOfMemory.
https://habr.com/ru/articles/967432/
#NET #c# #сериализация #streaming #оптимизация #производительность #архитектура #xbrl #работа_с_памятью #json
-
Мощь XBRL в мире данных: автоматизируем проверку отчетности с помощью SQL-формул
Всем привет! В первой части https://habr.com/ru/articles/958356/ мы познакомились с форматом XBRL-CSV2, который позволяет упаковать сложность XBRL-отчетности в простые и удобные для обработки CSV-таблицы. Мы обсудили, как данные и их метаописания (маппинг) преобразуются из XML-представления в реляционное. Но сбор данных — это только половина дела. Вторая, не менее важная часть — это их проверка на целостность, непротиворечивость и соответствие бизнес-правилам. В классическом XBRL за это отвечает формульный слой (Formula Layer). Сегодня мы поговорим о том, как мы превратили эти формулы в исполняемые SQL-скрипты, создав так называемый «слой отделяемых формул» .
-
So now I'm the sucker who has read almost all the specifications. (1 spec to go) Time to start all over again now that the overview is complete. Also time for my pension and let someone else read through it all over again. #xbrl #reporting #datamodeling #knowledge
-
Представляем XBRL-CSV — машиночитаемую отчетность в формате для людей
Примечание: Статья посвящена формату XBRL-CSV2 (тэг "@context":"www.cbr.ru/xbrl_csv2" ). Авторство формата принадлежит Банку России. Автор статьи — архитектор, принимавший участие в разработке формата в качестве технического специалиста. Введение . Банк России использует стандарт XBRL для сбора отчетности от некредитных финансовых организаций. Несмотря на всю продуманность XBRL, при формировании и обработке отчетности возникает проблема, связанная с реестровыми формами. Эти формы содержат гиперкубы с открытыми осями. При большой вариативности значений таких осей реестровые отчеты становятся чрезвычайно объемными. Решение этой проблемы — создание производного от XBRL-XML формата: XBRL-CSV. Основная предпосылка: CSV органически приспособлен для хранения реестровых форм. Открытые оси выносятся в начальные колонки, а комбинации значений ячеек открытых осей в каждой строке образуют составной открытый ключ, однозначно идентифицирующий запись. Остальные колонки — это данные, которые определяют три аспекта показателя:
-
Парсинг pdf-отчётов публичных компаний для получения трейдерских инсайтов
Здравствуйте! В этой статье рассмотрим, как с помощью Python мониторить сайты компаний, парсить отчёты из PDF, извлекать ключевые данные и отправлять обработанные результаты в Telegram. Публичные компании обязаны публиковать свою отчётность (финансовые результаты, годовые отчёты, пресс-релизы) на своих сайтах, часто в формате PDF. Для трейдера или инвестора скорость получения и анализа этой информации критически важна: тот, кто первым увидит тренд или аномалию в отчёте, может принять лучшее решение и получить преимущество на рынке. Мы создадим скрипт на Python, который будет скачивать с сайта (разберём на примере Яндекс) отчёт в формате PDF, преобразовывать неструктурированный текст в структурированные данные, извлекать ключевые метрики (выручка, чистая прибыль) и отправлять сжатый инсайт в Telegram-бот.
https://habr.com/ru/companies/amvera/articles/949966/
#парсинг_pdf #xbrl #сигналы_для_трейдинга #мониторинг_отчетов #извлечение_данных #сервис_для_трейдинга #bloomberg_terminal
-
University of Michigan: U-M develops free tool to empower municipalities, modernize financial reporting. “When Congress passed the Financial Data and Transparency Act in 2022, it required most municipalities in the U.S. to modernize and digitize their financial reports. This is a heavy lift for small towns and school districts, most of which still report their financial information in PDF […]
-
@divclassbutton There is a german #XBRL book, but the code base is very small. https://dpunkt.de/produkt/extensible-business-reporting-language/
-
@divclassbutton There is a german #XBRL book, but the code base is very small. https://dpunkt.de/produkt/extensible-business-reporting-language/
-
Bit of a wild shot in the dark, but can anyone recommend me some reading on #XBRL , specifically I want to learn more about how Global Ledger works if there is anything out there?
-
Bit of a wild shot in the dark, but can anyone recommend me some reading on #XBRL , specifically I want to learn more about how Global Ledger works if there is anything out there?
-
FERC to start distributing their largest dataset in the least convenient possible format. The EQR is already ~100GB in uncompressed CSVs. In XBRL that would be maybe a TB? With the XML of each filing having to be parsed individually are we going to have to spin up a whole cluster just to get it converted to Parquet in less than a day?
https://www.jdsupra.com/legalnews/ferc-proposes-overhauling-electronic-4199806/
-
FERC to start distributing their largest dataset in the least convenient possible format. The EQR is already ~100GB in uncompressed CSVs. In XBRL that would be maybe a TB? With the XML of each filing having to be parsed individually are we going to have to spin up a whole cluster just to get it converted to Parquet in less than a day?
https://www.jdsupra.com/legalnews/ferc-proposes-overhauling-electronic-4199806/
-
Very excited to announce v2024 of our ALTOVA software which introduces brand new #AI Assistants in multiple products as well as long-awaited support for #PDF data integration in MapForce. Other features include Markdown editing support, split output preview for business report creation, support for new #XBRL standards, and much more.
https://www.altova.com/blog/ai-integration-pdf-data-mapping-in-version-2024/ -
Very excited to announce v2024 of our ALTOVA software which introduces brand new #AI Assistants in multiple products as well as long-awaited support for #PDF data integration in MapForce. Other features include Markdown editing support, split output preview for business report creation, support for new #XBRL standards, and much more.
https://www.altova.com/blog/ai-integration-pdf-data-mapping-in-version-2024/ -
Another update to our #FERC #XBRL extractor (v1.2.0).
It turns out that the same utility can refile the same form multiple times per day, and not all facts may be contained in every filing, so deduplicating the data is non-trivial, and best done later in the ETL process. So now the extracted SQLite DB is a more complete (and more complex) conversion of every piece of information contained in the XBRL RSS feeds, even if it's duplicative or internally inconsistent.
https://github.com/catalyst-cooperative/ferc-xbrl-extractor/releases/tag/v1.2.0
-
Another update to our #FERC #XBRL extractor (v1.2.0).
It turns out that the same utility can refile the same form multiple times per day, and not all facts may be contained in every filing, so deduplicating the data is non-trivial, and best done later in the ETL process. So now the extracted SQLite DB is a more complete (and more complex) conversion of every piece of information contained in the XBRL RSS feeds, even if it's duplicative or internally inconsistent.
https://github.com/catalyst-cooperative/ferc-xbrl-extractor/releases/tag/v1.2.0
-
This will excite only a very niche audience, but we've released v1.0 of our #FERC #XBRL extraction library, which consumes the taxonomies and filings published by FERC via RSS and uses them to build #SQLite databases that are much more amenable to analytical usage. it works for FERC Forms 1, 2, 6, 60, and 714 which started using XBRL in 2021. We're now working on integrating the 2022 data.
-
This will excite only a very niche audience, but we've released v1.0 of our #FERC #XBRL extraction library, which consumes the taxonomies and filings published by FERC via RSS and uses them to build #SQLite databases that are much more amenable to analytical usage. it works for FERC Forms 1, 2, 6, 60, and 714 which started using XBRL in 2021. We're now working on integrating the 2022 data.
-
The FERC data mess is never going to end. 😭
Last week a user found some randomly missing values in the SQLite DB we generate from FERC's XBRL that *do* appear in the PDFs generated by the FERC eLibrary. It looks like this is because utilities are submitting XBRL that doesn't conform to the taxonomy, but FERC still accepts the filings. This affects ~7% of the 2.2 million values reported in the 2021 Form 1.
-
The FERC data mess is never going to end. 😭
Last week a user found some randomly missing values in the SQLite DB we generate from FERC's XBRL that *do* appear in the PDFs generated by the FERC eLibrary. It looks like this is because utilities are submitting XBRL that doesn't conform to the taxonomy, but FERC still accepts the filings. This affects ~7% of the 2.2 million values reported in the 2021 Form 1.
-
Accidentally dragged my finger too long while browsing a site via #Brave and up popped up an “inline #XBRL viewer.” Whaaaa? Then I remembered: “#RDFa for business.” Amazingly still a thing, even after 20+ years.. #SemanticWeb @semanticweb
-
Accidentally dragged my finger too long while browsing a site via #Brave and up popped up an “inline #XBRL viewer.” Whaaaa? Then I remembered: “#RDFa for business.” Amazingly still a thing, even after 20+ years.. #SemanticWeb @semanticweb
-
An #introduction appears to be in order:
#Entrepreneur #Investor #Co-Founder & #CEO of #Altova
District Governor of #Rotary District 7930
You might remember me as the co-author of #XMLSpy
Interests: #MobileAppDevelopment, #Drones, #Tech, #Science, #Space, #IOT, #JSON, #XBRL, #XML, #XPATH, #XQUERY, #XSLT, #XMLSCHEMA, and related technologies
Hobbies:
#Skiing, #Boating, #Traveling, #Reading, #Photography -
An #introduction appears to be in order:
#Entrepreneur #Investor #Co-Founder & #CEO of #Altova
District Governor of #Rotary District 7930
You might remember me as the co-author of #XMLSpy
Interests: #MobileAppDevelopment, #Drones, #Tech, #Science, #Space, #IOT, #JSON, #XBRL, #XML, #XPATH, #XQUERY, #XSLT, #XMLSCHEMA, and related technologies
Hobbies:
#Skiing, #Boating, #Traveling, #Reading, #Photography -
Woo! Draft deployment of our extracted #FERC #XBRL data using @simon's #Datasette. Including 2021 data for FERC forms 1, 2, 6, 60, and 714. Still need to clean up the metadata, but hey it's a relational DB usable for analysis and transformation... not a bunch-o-gigabytes of XML. #sqlite #OpenData #EnergyTwitter #EnergyMastodon #PUDL
https://data.catalyst.coop/ -
Woo! Draft deployment of our extracted #FERC #XBRL data using @simon's #Datasette. Including 2021 data for FERC forms 1, 2, 6, 60, and 714. Still need to clean up the metadata, but hey it's a relational DB usable for analysis and transformation... not a bunch-o-gigabytes of XML. #sqlite #OpenData #EnergyTwitter #EnergyMastodon #PUDL
https://data.catalyst.coop/ -
@praxis Well, I worked for about 10 years in the #MapForce Team of #Altova https://www.altova.com/mapforce and I simply loved to integrate various standards like #XBRL #OOXML (Excel) and the internal engine for executing mapping. Furthermore code generators for #CSharp , #Java, #Cpp and exotic stuff like #XSLT and even #XQuery.
In a #ComputerVision startup company (2000-2006) I played around with #ObjectDetection #Fingerprint and used #SupportVectorMachine which were modern in that years.
-
@praxis Well, I worked for about 10 years in the #MapForce Team of #Altova https://www.altova.com/mapforce and I simply loved to integrate various standards like #XBRL #OOXML (Excel) and the internal engine for executing mapping. Furthermore code generators for #CSharp , #Java, #Cpp and exotic stuff like #XSLT and even #XQuery.
In a #ComputerVision startup company (2000-2006) I played around with #ObjectDetection #Fingerprint and used #SupportVectorMachine which were modern in that years.
-
I am an energy economist at #FERC, a smaller US agency. I work on improving the #data my agency collects, making it better before we receive it, & increasing the transparency for the public. FERC does a lot of high profile things with #energy specifically with #LNG but I don't get involved in that work.
I'm into #LGBTQ #politics #democrats, #videogames #art #progressive #travel #broadway #XBRL #books #liberal #mentalhealth #xbox #washingtondc #followfriday #followback
-
I am an energy economist at #FERC, a smaller US agency. I work on improving the #data my agency collects, making it better before we receive it, & increasing the transparency for the public. FERC does a lot of high profile things with #energy specifically with #LNG but I don't get involved in that work.
I'm into #LGBTQ #politics #democrats, #videogames #art #progressive #travel #broadway #XBRL #books #liberal #mentalhealth #xbox #washingtondc #followfriday #followback
-
The 2021 #FERC Form 1 data has been more recalcitrant, since they've switched to using #XBRL for reporting (after 27 years of Visual FoxPro...), but we're close!
It looks like there's enough structured information in the XBRL taxonomies that we can reproduce all the calculations and tag the data with the relevant FERC accounting categories.
-
My annual, what's going on with #XBRL and #LinkedData related demo. Google: $GOOG #Finance #SemanticWeb #BigData
