FYI AlphaVantage API has now made some of the features in this video part of their PAID plan, so not everything is entirely free at this point! Part 2 Available Here: Using the Data for a one page stock screening tool! th-cam.com/video/W0rraiHSZlA/w-d-xo.html
Great video. I'm about to take my PL-300 and wanted to get my hands on a good project for experience -> led me to a financial dashboard -> led me to this video. Subscribed to your channel. I'm going to attempt to recreate this process later, I'll keep you posted. Thanks, Keith
Check your syntax again in the advanced editor, compare it directly to the template you can download from the link above. Hard to troubleshoot without directly looking at your code, good luck!
Hey Sagnik! Fastest way is to just download the free template, link in description, then open powerquery and the specific table and code for the company overview api response
I have some more questions, about how to visualize and don't overload the .ipbix: 1/Timeline values for several tickers, or even extend it further for tickers in one line chart? 2/Visualize the tickers values on the timeline plus sma_12, des_12, tes_12 and so on. 3/ Have be sma_12, des_12, tes_12 calculated in clouds?
They have a freemium model and everything I did in the video was using the free offerings, of course you have to submit your email to them as well as state you are not using it for commercial purposes
hello a very nice and detailed video sir, Though I am facing a challenge while coding the m code in advance editor I am getting the following error message: "This API function (TIME_SERIES_DAILY_ADJUSTEDSUMBOL=AAPLOUTPUTSIZE=FULL) does not exist." Can you help me with it?
Just confirmed.... indeed some of the API endpoints used in this video have been moved from free to paid by AlphaVantage.... well, they know they have a good product! figured it was about time!
FYI AlphaVantage API has now made some of the features in this video part of their PAID plan, so not everything is entirely free at this point!
Part 2 Available Here: Using the Data for a one page stock screening tool! th-cam.com/video/W0rraiHSZlA/w-d-xo.html
Noooooo... But I mean, how could they NOT monetize that?
Supper Helpful. Thank you so much
That was so good!
I am starting to get to know Power BI (coming from advanced excel) and this video was perfect! Really clear and lots of content :)
Great video. I'm about to take my PL-300 and wanted to get my hands on a good project for experience -> led me to a financial dashboard -> led me to this video.
Subscribed to your channel. I'm going to attempt to recreate this process later, I'll keep you posted.
Thanks,
Keith
Super helpful! Thank you.
Can you give the code from 3:30? I cant find it.
Can download the .pbix at ptarmy.com/joinus
@@Ptarmy_ All the data is for free? I got a message that i need a premium membership or did i just pass that 25 API requests/day mark?
I am gettin a 'parameter apikey is invalid or missing', though i used the sam way and copied it directly. What could that be?
Check your syntax again in the advanced editor, compare it directly to the template you can download from the link above. Hard to troubleshoot without directly looking at your code, good luck!
Hey there! How do I get the company overview query?
Hey Sagnik! Fastest way is to just download the free template, link in description, then open powerquery and the specific table and code for the company overview api response
Hey thanks ! Whats the name of the template?@@Ptarmy_
Just uploaded, in folder #9 "Intro to Stock Data", be sure to add your own API key in this as I deleted mine!@@sagniksengupta3212
Good video, have a question I generated key, inserted it in basic configuration without a password. --> done, why my access can be forbidden?
I have some more questions, about how to visualize and don't overload the .ipbix:
1/Timeline values for several tickers, or even extend it further for tickers in one line chart?
2/Visualize the tickers values on the timeline plus sma_12, des_12, tes_12 and so on.
3/ Have be sma_12, des_12, tes_12 calculated in clouds?
Do I need the premium membership for alphavantage? The query doesn't seem to run without it
They have a freemium model and everything I did in the video was using the free offerings, of course you have to submit your email to them as well as state you are not using it for commercial purposes
@@Ptarmy_ Great. Thanks. It's working now
hello a very nice and detailed video sir, Though I am facing a challenge while coding the m code in advance editor I am getting the following error message: "This API function (TIME_SERIES_DAILY_ADJUSTEDSUMBOL=AAPLOUTPUTSIZE=FULL) does not exist."
Can you help me with it?
Hi, when I fill in the query it states that “this is the premium endpoint” rather that granting me acces. Any ideas on how to fix this?
Everything in the video was done using the free api and I don’t think they’ve changed what’s available recently, so should not need the premium!
@@Ptarmy_ Hi, thanks for the reaction man! Appreciate it. I don't have a premium BI license, so maybe it depends on that. Good video anyways! ;)
Ah that might be it.... crud, this isnt the last API i'll be using for investment related analysis in a BI tool though so check back!@@nielslubse6401
Just confirmed.... indeed some of the API endpoints used in this video have been moved from free to paid by AlphaVantage.... well, they know they have a good product! figured it was about time!
update :- just finished building this part 1 , moving to part 2
Hope it all turns out awesome!