Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Yahoo finance data download

Poonam5425
5 - Atom

Hi All,

 

I am trying to download data for various stocks from yahoo finance and wanted to have a web (API) name in front of the data.

e.g. for https://query1.finance.yahoo.com/v7/finance/download/ITC.BO?period1=1577836800&period2=1578009600&in...

I wanted to have the entire query name or atleast "ITC.BO" name present in my workflow.

workflow attached

Can someone please help? Thanks 🙂

2 REPLIES 2
pedrodrfaria
13 - Pulsar

Hi @Poonam5425 

 

I have attached a workflow that looks up the MV for the stock in question (multiple stocks) that includes the name of the ticker.

 

Pedro.

johanwilken
5 - Atom

Hi Pedro, how would one go about if I want to extract the income statement data in Excel from yahoo finance?

Thanks

Labels
Top Solution Authors