Skip to main content

Notifications

Power Automate - Using Connectors
Answered

Stock Price Source?

(0) ShareShare
ReportReport
Posted on by

I am looking to store stock price data for our company's stock (NYSE) in a SharePoint list and also display the current value on our intranet's home page.  I had it working via Power Automate by following these directions but discovered that the stock price source, Alpha Vantage, now only gives the prior day's closing price, unless you want to switch to their paid provider partner.

 

Does anyone know of a better stock price source?  I am only pulling the price every 10 minutes while the market is open, so only about 1,050 pulls a month (6 pulls an hour * 7 hours a day * 25 days a month).  So it does not need to be realtime.

 

I am wondering if there is a way to screen scrape it from the Yahoo Finance page, but I've no experience with that. 🙁

  • Ukiman1014 Profile Picture
    Ukiman1014 on at
    Re: Stock Price Source?

    Okay, thank you @CFernandes and @abm .  I'll check out some of those searches.  I'd still like to post back here what I end up using, just to finish out the question and maybe assist another P.A. user who may search here.

  • Verified answer
    CFernandes Profile Picture
    CFernandes 8,146 on at
    Re: Stock Price Source?

    @Ukiman1014 

     

    Hey Mate,

     

    I agree with @abm  the Power Automate community will not be the best place to ask such type of question.

     

    I would suggest, just google it https://www.google.com/search?q=stock+price+rest+api 

     

    OR post a question in Quora https://www.quora.com/  You can see similar question Quora has got a lot of ideas and inputs (https://www.quora.com/What-are-some-good-APIs-to-get-real-time-stock-quotes)

     

    If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

     

  • abm abm Profile Picture
    abm abm 32,291 on at
    Re: Stock Price Source?

    Hi @Ukiman1014 

     

    What I meant is if your question is regarding how to use a Power Automate action then this is the forum to use. Your question is which API you can use for pulling a live stock update. This is mainly third party providers API which Power Automate community won't be able to answer it. If you have trouble using the API regarding HTTP, authentications, Parse JSON, etc definitely this is the right forum. 

     

    Thanks

  • Ukiman1014 Profile Picture
    Ukiman1014 on at
    Re: Stock Price Source?

    Hi @abm,

     

    Can you please advise what other forum to use here?  I am using Power Automate to pull down stock prices and save them in a SharePoint list and am enquiring for a good source of data.  The article that I used to create my current flow is based in Power Automate, so I would think this is relevant.

     

    I am not a developer, I am a Power Automate user.  I am asking the Power Automate community for some help.  Is there a different PA forum that I should be using?

     

    Thanks.

     

     

  • abm abm Profile Picture
    abm abm 32,291 on at
    Re: Stock Price Source?

    Hi @Ukiman1014 

     

    This forum is related to Power Automate community questions. The question regarding your API outside the domain knowledge of PA. Hopefully a better Google search or other communities could help you in this matter.

     

    Thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard

Featured topics