Live Stock Prices in Excel for Free WITHOUT Microsoft 365 Account

Ryan, here with portfolio builds, today I'm going to show you how to get

free

real

stock

data in Excel, in a very easy way. This is something I've searched on YouTube many times over the last two years and never really. I found a satisfactory explanation on how to do this now. If you're like me, you're probably banging your head against the wall wondering if this is even possible. Well, today I will show you that it is and that it is very easy. Get started. I have found the easiest way to get

stock

prices

for

free

in Excel.

It is to use this service provider called iex cloud. Now I have not been paid anything for making this video. I just enjoy the product and it's useful for my purposes so we'll post the link to the home page in the description so what you're going to do is go to this pricing tab and then you'll see at the bottom it says start free 50,000 top messages per month. those are the API requests, so you will press this home button once you have registered, then it will take you to this home page and you can go to the API tokens.

Now this is your secret token, so don't show it. this for anyone or share it with someone if you press regenerate so you can copy it here now we're going to take this and move into Excel. I'll paste it into the project that I set up beforehand and one thing that's happening To be really helpful, there's this documentation on their website called Excel. How I'll post this in the description too so it's really easy. Look, this is if I want to get the latest Apple stock price, I'll just copy it. this formula here and I see that I have Apple in my wallet, so I'm going to paste the formula here.

What I wanted to do in this video is show you how you could go about, let's say you have a stock portfolio and you want to just bring

live

prices

into Excel to value them, so that's today's example so you can see in this formula that says your token here, so if you were to take this token and paste it over the words your token here, then We'll see that you have Apple stock for free

live

in Excel, but we want to make this formula more dynamic if we're going to value a portfolio , so I'll show you how to do it right now, let's say. we have 40 shares of 10 or 40 shares of tesla 15 of

microsoft

102 of apple and 5 of walmart for example now let's make this formula dynamic so we are going to concatenate this text so that we can drag and drop for a complete portfolio like this Right in this formula of web service, I'm going to use concatenate.

Now, the first string we need to isolate is where our individual stock is referenced. You can see they're coded in Apple and we want this to be dynamic, so I'm. I'm going to reference the actions here so we can drag this formula later, then I'm going to put the following text string in quotes and we have to stop after the token is equal because that's where we want to put our own token now instead of actually copy and paste the token I'm going to reference this dynamically this could be useful if you're regenerating the token and using a different one so here we go our formula is dynamic we can drag and drop the stock prices and there we are. have all of this, um, live for free in Excel.

You can get fifty thousand of these requests a month now if I want to value the entire position, I'll just do it based on the value or number of shares multiplied by the share price. and I'll drag this down, paste formulas and now we'll add up the total portfolio value and there we have the live portfolio evaluation in Excel for free. If you enjoyed the video please leave a like and if you want to see more videos. so in the future please subscribe to the channel thank you