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.

Making a macro(stock prices) go from taking one user interfaced input to a list from excel

carl-meyer
7 - Meteor

Hello, so I'm working with Alberto's workflow the second one in the post from which deals with taking historical data from a stock: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Pull-Financial-amp-Crypto-Data-with-Al...

Within his Macro I can run it for any stock it prompts the user for and it only works for one stock at a time, however I want to change it so it takes a list of a stocks from an excel spread sheet and goes through gathering the data for each one. How would I go about achieving that result?

 

Here's the download to the workflow: https://gallery.alteryx.com/#!app/Stock-Time-Series/601d35d88a9337047042bb9d

Also here's my API key is if you need it: 

YRS4QBTQI7S8TW9P
1 REPLY 1
Tyro_abc
11 - Bolide

This Macro doesn't have an input anchor. So, I think you need to modify/edit that macro (Alberto's workflow).

 

Best Regards 

abc

Labels