Icon

finance-data-retrieval-30576

There has been no description set for this workflow's metadata.

* Navigate to finanance data page which contains tablewith quarterly financial figures* Click on “Show more” link of the table, until there’s nomore data* Use the Table Extractor node to convert the HTML tableinto a KNIME table* Perform some final regex extraction to clean up thenumbersSee KNIME forum post:https://forum.knime.com/t/finance-data-retrieval/30576Requires Selenium Nodes 4.7+, Palladian Nodes Node 1Navigate tohttps://www.investing.com/equities/coty-inc-earningsAccept cookiesThis loop willkeep on clickingthe “Show More”link until it disappears(and the table showsall the data)Extract the“Show More”linkNode 6Determineif link is visible --this triggers theeither first or secondbranch in the CASEnodeOnly perform the“Click” action, if the link is visibleNode 9Node 10End the loop based on the “continue” condition -- if “Show More” isno longer visible, stop loopingNode 12The rest is easy:Just enter a CSSselector which pointsto the table, and let the Table Extractordo its workExtract EPS forecast(and remove junk)Extract Revenue forecast(and remove junk)Node 17Wait a bit longer,until the last row datahas arrived Start WebDriver Navigate Click Generic Loop Start Find Elements Click Extract CSSProperty CASE SwitchData (Start) Rule Engine Table Rowto Variable Variable ConditionLoop End CASE SwitchData (End) Table Extractor Regex Extractor Regex Extractor Column Resorter Wait * Navigate to finanance data page which contains tablewith quarterly financial figures* Click on “Show more” link of the table, until there’s nomore data* Use the Table Extractor node to convert the HTML tableinto a KNIME table* Perform some final regex extraction to clean up thenumbersSee KNIME forum post:https://forum.knime.com/t/finance-data-retrieval/30576Requires Selenium Nodes 4.7+, Palladian Nodes Node 1Navigate tohttps://www.investing.com/equities/coty-inc-earningsAccept cookiesThis loop willkeep on clickingthe “Show More”link until it disappears(and the table showsall the data)Extract the“Show More”linkNode 6Determineif link is visible --this triggers theeither first or secondbranch in the CASEnodeOnly perform the“Click” action, if the link is visibleNode 9Node 10End the loop based on the “continue” condition -- if “Show More” isno longer visible, stop loopingNode 12The rest is easy:Just enter a CSSselector which pointsto the table, and let the Table Extractordo its workExtract EPS forecast(and remove junk)Extract Revenue forecast(and remove junk)Node 17Wait a bit longer,until the last row datahas arrived Start WebDriver Navigate Click Generic Loop Start Find Elements Click Extract CSSProperty CASE SwitchData (Start) Rule Engine Table Rowto Variable Variable ConditionLoop End CASE SwitchData (End) Table Extractor Regex Extractor Regex Extractor Column Resorter Wait

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Philipp Katz
Created at: 2021-02-13
On NodePit since: 2021-02-13
Last update: 2024-11-17
Created with KNIME version: v4.2.3
Tags: htmltableextractionseleniumfinancedata
NodePit Exclusive Only available on NodePit

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!