Learn Dashboards, Excel, Power BI, Power Query, Power Pivot
I've previously written about getting real time data (RTD) into Excel using Python. In this post I'm going to chart that data as it arrives in Excel. Think real-time stock price updates. The steps required to get this working are: Install Python and PyXLL. Write a Python function to get the real time data and …
If you need to plot data that has one variable where values can be the same or very similar, for example the age of a group of people, you'll likely end up with data points that are plotted over the top of each other. To make this type of plot easier to read and allow …
Last week I wrote about getting real time data into Excel using PyXLL and Python code. I described a way to do this using HTTP connections. HTTP is the type of connection your browser uses to read web pages. In this article I'm looking at using sockets to get real time data into Excel. Sockets …
Updated April 2020 Excel does support getting real time data into the worksheet with the RTD function, but this requires programming a COM server with which the RTD function communicates. Power BI is able to make use of streaming data via API connections or PubNub, but what if I just want to pull some live …
My last post looked at using Python to plot equations in Excel with DataNitro. In this one I want to look at writing UDFs in Python.with xlwings. Why Use Python for UDFs ? This is a question not just about UDFs but why use Python at all in Excel? I guess this depends on what …
Something I've wanted to do easily in Excel is plot equations. If I have something like 2x2 + 3x + 2, I want to see a plot or graph of the curve that the equation produces. I know there are ways to do this that involve producing a set of data points, and then using …
