Use power query in excel to retrieve data from the web, record macros and create a dynamic candlestick graph to track stocks in this action packed episode!
Smash like / subscribe or comment below if you think this was epic.
Making these videos require a lot of caffeine, please consider to buy me a coffee by following the link:
…
Check out my channel to gain some knowledge:
…
Check out my Facebook page and share my content by following the link:
Buckle-up and let's Excelerate!
Make It Happen With Excel recommend your channel. 🤗
Hi Stone, can we have live charts with duration of say 1,3,5,10,15 minutes duration for intraday trading?
Hello there and thank you for reaching out! I will definitely investigate and revert. A great suggestion for my next tutorial. Watch this space!
Hello There! I have just released a updated tutorial on candlestick charts with the timing function you have suggested. Please have a look and let me know what you think. https://youtu.be/tZux0TGwObM
Hi I did follow everything you said but cant use the graph macros it gives me a debug error
Hello Francisco, thank you for reaching out! I will check and send you the completed file. Hopefully this will work for you.
Hello Franciso,
Please see the link to the completed file as promised: https://drive.google.com/file/d/1agtLdef9ouOgDsHUF33cFlh0vtiXuv1t/view?usp=sharing
Kindly check if this version is working for you and remember to hit that Like and Subscribe!
Hi Stone, thank you so very much for this tutorial, I appreciate your work! I tried it for my own spread sheet and it worked! Wish you all the best, stay safe!
Hello Yves! I am so glad it worked for you! I am going to do a whole excel series on stocks and candlestick graphs. Aiming to build a trade bot in excel. Please let me know if you have any suggestions / requests on this! Have a great day 👍
Hi when we use the refresh button, the data gets refreshed. but it doesnt change the dates in the chart. how can we change that as well ?
Hello Samriddhi,
It may be a date setup difference. Please see the link to the completed file: https://drive.google.com/file/d/1agtLdef9ouOgDsHUF33cFlh0vtiXuv1t/view?usp=sharing
Kindly check if this version is working for you and remember to hit that Like and Subscribe!
Good video sir ….
Hi !!!! great learning full video ,your video make with pre recorded value OHLC , But I have one requirement i getting data in single cell from DDE link method in excel-2019 , which update in 3 second , I want to cached value in 5 minute intervals OHLC from a single cell ,Means value was at 10:00 am is 120.25, 10:01 am is 141.35, 10:03am is 158.12 and 10:05am is 114.85 , So final i want record in candle chart with open, high, low &close .
from India
Hi Neeraj, thank you for reaching out! Try my updated version with automatic updates! Hopefully this will help! https://youtu.be/tZux0TGwObM
Hi. Do you know how to add horizontal lines to the graphic? Lines for support and resistences?
hello Stone. Wil weet as ek a bedrag het van min=0.00000600 en max=0.0000130 how moet ek die rounddown en roundup maak, op rounddown doen ek g2,-8 en roundup h2,-8 maar dit lyk nie reg nie.