Consuming yfinance data in Excel - Part II
Have you ever wanted access to yfinance data in an Excel spreadsheet? If so, this two-part blog may be of interest. It describes an approach using a Flask AP...
Posts by Tag
- Excel 6
- R 5
- r-project 5
- Python 4
- Office365 3
- yfinance 3
- cpp 2
- Flask 2
- finance 2
- Power Query 2
- Power Query M Language 2
- Web Connector 2
- Word 1
- cppwinrt 1
- winrt 1
- midl 1
- csharp 1
- winui3 1
- xaml 1
- SUM 1
- CHOOSECOLS 1
- FILTER 1
- LAMBDA 1
- Pivot Table 1
- PowerQuery 1
- VBA 1
- rcpp 1
- cplusplus 1
- WinUI 3.0 1
- C# 1
Excel
Building a Flask service to get yfinance data - Part I
Have you ever wanted access to yfinance data in an Excel spreadsheet? If so, this two-part blog may be of interest. It describes an approach using a Flask AP...
Python in Excel via Reticulate
This post describes a particular use-case for Python in Excel and how it was solved using the R package Reticulate 1.39.0 along with the ExcelRAddIn.A while ...
Office365 AddIns for R (Part III)
A while back, I introduced the ExcelRAddIn (Office365 AddIns for R (Part I)). This is an Office365 AddIn that allows you to evaluate an R-script from within ...
Adventures in Excel: Filtering and grouping data
This started off as a simple experiment and mushroomed. I have a card account, and I wanted to know how much I owed for the previous month. Simple enough. An...
Office365 AddIns for R (Part I)
I’d like to introduce a couple of Office365 add-ins for R that I have been working on recently. I read R-bloggers regularly and I thought these add-ins might...
R
Calling C++ functions from R using Rcpp
If you are an R/RStudio user and you are learning C/C++ then this blog post may be interesting. Suppose that you’ve written a function in C/C++ (or even a wh...
Python in Excel via Reticulate
This post describes a particular use-case for Python in Excel and how it was solved using the R package Reticulate 1.39.0 along with the ExcelRAddIn.A while ...
Office365 AddIns for R (Part III)
A while back, I introduced the ExcelRAddIn (Office365 AddIns for R (Part I)). This is an Office365 AddIn that allows you to evaluate an R-script from within ...
Office365 AddIns for R (Part II)
In the previous post Office365 AddIns for R (Part I), I introduced the ExcelRAddIn. In this post I would like to describe the RScriptAddIn for Word.
Office365 AddIns for R (Part I)
I’d like to introduce a couple of Office365 add-ins for R that I have been working on recently. I read R-bloggers regularly and I thought these add-ins might...
r-project
Calling C++ functions from R using Rcpp
If you are an R/RStudio user and you are learning C/C++ then this blog post may be interesting. Suppose that you’ve written a function in C/C++ (or even a wh...
Python in Excel via Reticulate
This post describes a particular use-case for Python in Excel and how it was solved using the R package Reticulate 1.39.0 along with the ExcelRAddIn.A while ...
Office365 AddIns for R (Part III)
A while back, I introduced the ExcelRAddIn (Office365 AddIns for R (Part I)). This is an Office365 AddIn that allows you to evaluate an R-script from within ...
Office365 AddIns for R (Part II)
In the previous post Office365 AddIns for R (Part I), I introduced the ExcelRAddIn. In this post I would like to describe the RScriptAddIn for Word.
Office365 AddIns for R (Part I)
I’d like to introduce a couple of Office365 add-ins for R that I have been working on recently. I read R-bloggers regularly and I thought these add-ins might...
Python
Consuming yfinance data in Excel - Part II
Have you ever wanted access to yfinance data in an Excel spreadsheet? If so, this two-part blog may be of interest. It describes an approach using a Flask AP...
Building a Flask service to get yfinance data - Part I
Have you ever wanted access to yfinance data in an Excel spreadsheet? If so, this two-part blog may be of interest. It describes an approach using a Flask AP...
Calling Python from C# using Python.NET
Recently, I’ve been using Python’s yfinance library to perform some simple portfolio analysis. Rather than using a Jupyter notebook to run the Python code an...
Python in Excel via Reticulate
This post describes a particular use-case for Python in Excel and how it was solved using the R package Reticulate 1.39.0 along with the ExcelRAddIn.A while ...
Office365
Office365 AddIns for R (Part III)
A while back, I introduced the ExcelRAddIn (Office365 AddIns for R (Part I)). This is an Office365 AddIn that allows you to evaluate an R-script from within ...
Office365 AddIns for R (Part II)
In the previous post Office365 AddIns for R (Part I), I introduced the ExcelRAddIn. In this post I would like to describe the RScriptAddIn for Word.
Office365 AddIns for R (Part I)
I’d like to introduce a couple of Office365 add-ins for R that I have been working on recently. I read R-bloggers regularly and I thought these add-ins might...
yfinance
Consuming yfinance data in Excel - Part II
Have you ever wanted access to yfinance data in an Excel spreadsheet? If so, this two-part blog may be of interest. It describes an approach using a Flask AP...
Building a Flask service to get yfinance data - Part I
Have you ever wanted access to yfinance data in an Excel spreadsheet? If so, this two-part blog may be of interest. It describes an approach using a Flask AP...
Calling Python from C# using Python.NET
Recently, I’ve been using Python’s yfinance library to perform some simple portfolio analysis. Rather than using a Jupyter notebook to run the Python code an...
cpp
Calling C++ functions from R using Rcpp
If you are an R/RStudio user and you are learning C/C++ then this blog post may be interesting. Suppose that you’ve written a function in C/C++ (or even a wh...
Consume a C++/WinRT component in a C# desktop application
I have a function called ‘GetDescriptiveStatistics’ that takes some data and returns summary statistics. The function is written in C++, and I want to call i...
Flask
Consuming yfinance data in Excel - Part II
Have you ever wanted access to yfinance data in an Excel spreadsheet? If so, this two-part blog may be of interest. It describes an approach using a Flask AP...
Building a Flask service to get yfinance data - Part I
Have you ever wanted access to yfinance data in an Excel spreadsheet? If so, this two-part blog may be of interest. It describes an approach using a Flask AP...
finance
Consuming yfinance data in Excel - Part II
Have you ever wanted access to yfinance data in an Excel spreadsheet? If so, this two-part blog may be of interest. It describes an approach using a Flask AP...
Building a Flask service to get yfinance data - Part I
Have you ever wanted access to yfinance data in an Excel spreadsheet? If so, this two-part blog may be of interest. It describes an approach using a Flask AP...
Power Query
Consuming yfinance data in Excel - Part II
Have you ever wanted access to yfinance data in an Excel spreadsheet? If so, this two-part blog may be of interest. It describes an approach using a Flask AP...
Building a Flask service to get yfinance data - Part I
Have you ever wanted access to yfinance data in an Excel spreadsheet? If so, this two-part blog may be of interest. It describes an approach using a Flask AP...
Power Query M Language
Consuming yfinance data in Excel - Part II
Have you ever wanted access to yfinance data in an Excel spreadsheet? If so, this two-part blog may be of interest. It describes an approach using a Flask AP...
Building a Flask service to get yfinance data - Part I
Have you ever wanted access to yfinance data in an Excel spreadsheet? If so, this two-part blog may be of interest. It describes an approach using a Flask AP...
Web Connector
Consuming yfinance data in Excel - Part II
Have you ever wanted access to yfinance data in an Excel spreadsheet? If so, this two-part blog may be of interest. It describes an approach using a Flask AP...
Building a Flask service to get yfinance data - Part I
Have you ever wanted access to yfinance data in an Excel spreadsheet? If so, this two-part blog may be of interest. It describes an approach using a Flask AP...
Word
Office365 AddIns for R (Part II)
In the previous post Office365 AddIns for R (Part I), I introduced the ExcelRAddIn. In this post I would like to describe the RScriptAddIn for Word.
cppwinrt
Consume a C++/WinRT component in a C# desktop application
I have a function called ‘GetDescriptiveStatistics’ that takes some data and returns summary statistics. The function is written in C++, and I want to call i...
winrt
Consume a C++/WinRT component in a C# desktop application
I have a function called ‘GetDescriptiveStatistics’ that takes some data and returns summary statistics. The function is written in C++, and I want to call i...
midl
Consume a C++/WinRT component in a C# desktop application
I have a function called ‘GetDescriptiveStatistics’ that takes some data and returns summary statistics. The function is written in C++, and I want to call i...
csharp
Consume a C++/WinRT component in a C# desktop application
I have a function called ‘GetDescriptiveStatistics’ that takes some data and returns summary statistics. The function is written in C++, and I want to call i...
winui3
Consume a C++/WinRT component in a C# desktop application
I have a function called ‘GetDescriptiveStatistics’ that takes some data and returns summary statistics. The function is written in C++, and I want to call i...
xaml
Consume a C++/WinRT component in a C# desktop application
I have a function called ‘GetDescriptiveStatistics’ that takes some data and returns summary statistics. The function is written in C++, and I want to call i...
SUM
Adventures in Excel: Filtering and grouping data
This started off as a simple experiment and mushroomed. I have a card account, and I wanted to know how much I owed for the previous month. Simple enough. An...
CHOOSECOLS
Adventures in Excel: Filtering and grouping data
This started off as a simple experiment and mushroomed. I have a card account, and I wanted to know how much I owed for the previous month. Simple enough. An...
FILTER
Adventures in Excel: Filtering and grouping data
This started off as a simple experiment and mushroomed. I have a card account, and I wanted to know how much I owed for the previous month. Simple enough. An...
LAMBDA
Adventures in Excel: Filtering and grouping data
This started off as a simple experiment and mushroomed. I have a card account, and I wanted to know how much I owed for the previous month. Simple enough. An...
Pivot Table
Adventures in Excel: Filtering and grouping data
This started off as a simple experiment and mushroomed. I have a card account, and I wanted to know how much I owed for the previous month. Simple enough. An...
PowerQuery
Adventures in Excel: Filtering and grouping data
This started off as a simple experiment and mushroomed. I have a card account, and I wanted to know how much I owed for the previous month. Simple enough. An...
VBA
Adventures in Excel: Filtering and grouping data
This started off as a simple experiment and mushroomed. I have a card account, and I wanted to know how much I owed for the previous month. Simple enough. An...
rcpp
Calling C++ functions from R using Rcpp
If you are an R/RStudio user and you are learning C/C++ then this blog post may be interesting. Suppose that you’ve written a function in C/C++ (or even a wh...
cplusplus
Calling C++ functions from R using Rcpp
If you are an R/RStudio user and you are learning C/C++ then this blog post may be interesting. Suppose that you’ve written a function in C/C++ (or even a wh...
WinUI 3.0
Calling Python from C# using Python.NET
Recently, I’ve been using Python’s yfinance library to perform some simple portfolio analysis. Rather than using a Jupyter notebook to run the Python code an...
C#
Calling Python from C# using Python.NET
Recently, I’ve been using Python’s yfinance library to perform some simple portfolio analysis. Rather than using a Jupyter notebook to run the Python code an...