(MS Power Automate Desktop)RPA to record NASDAQ stock price every day

Let's implement an RPA that records NASDAQ stock prices every day.

(The scheduler allows you to implement it automatically at any time based on specific conditions.

I'll post how to set up the scheduler next time.)

 

 order of "flow" is 

Run Chrome -> Import Data -> Write to Excel

 

---

 

1. Run Chrome

 

Please search for 'CHROME' and drag 'Launch New Chrome' to empty space.

 

 

 

 

https://finance.daum.net/global/quotes/US.COMP

해외 시세 | 다음 금융

Please enter the address and set the window status to Maximize

 

 

---

 

 

2. Import Data

 

Search for 'extract data from web page' and drag 'extract data  from web page' to empty space

 

 

 

It's important from now on. Please follow the screenshot
As soon as the following screen appears, open the next financial screen window

 

 

 

And if you mouse over the date yesterday, it'll be red

 

 

Right-click -> Extract Element Values -> Text Click

 

 

 

Please do the same for stock prices.

 

 

 

 

If these five data are extracted, it's a success.

 

 

 

---

 

3. Write to Excel

 

Search for 'EXCEL' and drag 'Launch Excel' to empty space

 

 

 

'SAVE' Click

 

 

Drag 'Write to Excel Worksheet' to blank space

 

 

 

 

We only need NASDAQ's stock price.
So we're only going to record NASDAQ's stock price from the extracted data.
Please set it the same as the captured version.

 

 

Drag 'Close Excel' to an empty space

 

 

 

You can specify the route as you like.
However, the file title is given as a date to indicate the date.

 

 

Insert 'Close Web Browser' in the last row. Then the chromium closes.


Now let's get the flow

---

Result

 

 

There are many ways to accumulate data in one file or send it to your own email.
I've implemented it in the simplest way possible to explain.
Please refer to the information and make the results you want

Thank you.