Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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