Skip to content

Instantly share code, notes, and snippets.

@dfinke

dfinke/GetStockQuoteInExcel

Last active October 17, 2017 22:08
Show Gist options
  • Save dfinke/ffa898749dd2daa86581f70c594d8798 to your computer and use it in GitHub Desktop.
Save dfinke/ffa898749dd2daa86581f70c594d8798 to your computer and use it in GitHub Desktop.
Download ZIP
PowerShell Azure function, demos HTTP and Queue trigger. Pulls stock data from Yahoo, creates and emails an Excel doc to the target email
Raw
GetStockQuoteInExcel
# Uses PowerShell in an Azure function to create an Excel file without Excel being installed
# Add your email
# paste in a browser
# wait for the email to show up
https://getstockquoteinexcel.azurewebsites.net/api/RequestExcelStockInfo?symbol=msft,xom,ge,ibm,jpm,fb&email="<<your email address>>"
@irwins
Copy link

irwins commented Oct 17, 2017

I got a message about XML File style...
image
I'm using Chrome. I don't know if that info helps...

The message did come through!
image

Nice!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment