1260 search results for "excel"

Yet another way to use R in Excel for .NET programmer

July 6, 2011
By
Yet another way to use R in Excel for .NET programmer

I wrote the article whose title is "Another way to use R in Excel for .NET programmer" last night.In that article, We need to use IDE to write C# program.On ther other hand, Excel-DNA give us easier way to create XLL.Let me show you one ...

Read more »

Another way to use R in Excel for .NET programmer

July 5, 2011
By
Another way to use R in Excel for .NET programmer

As you know, RExcel give us a way to combine R with Excel.But, It just bothering to install some COMs and maybe not be programming but excel manipulation!If you are a .NET programmer, there is another way to call R from Excel.I would like to ...

Read more »

Using R in Excel

Got to know a very cool tool to use R in Excel named RExcel, basically it provides an integration solution such that users can get data, run command in Excel the same way as in R, which is presumably good and convenient to present results to your coll...

Read more »

Example 8.37: Read sheets from an excel file

May 11, 2011
By
Example 8.37: Read sheets from an excel file

Microsoft Excel is an awkward tool for data analysis. However, it is a reasonable environment for recording and transfering data. In our consulting practice, people frequently send us data in .xls (from Excel 97-2003) or .xlsx (from Excel 2007 or 201...

Read more »

How to backtest a strategy in Excel

March 14, 2011
By

(This is a guest post by Damian from Skill Analytics and ETF Prophet) Let me start by saying that I’m not an expert in backtesting in Excel – there are a load of very smart bloggers out there that have, as I would say, “mad skillz” at working with Excel including (but not limited to) Michael Stokes over...

Read more »

How to backtest a strategy in Excel

March 14, 2011
By

(This is a guest post by Damian from Skill Analytics and ETF Prophet)Let me start by saying that I’m not an expert in backtesting in Excel – there are a load of very smart bloggers out there that have, as I would say, “mad skillz” at working with Excel including (but not limited to) Michael Stokes over...

Read more »

Moving from Excel to R

March 5, 2011
By

This first post of the Backtesting in Excel and R series will provide some resources to help smooth the transition from the familiarity and comfort of Excel to the potentially strange and intimidating world of R.I made my voyage from Excel to R more th...

Read more »

Moving from Excel to R

March 5, 2011
By

This first post of the Backtesting in Excel and R series will provide some resources to help smooth the transition from the familiarity and comfort of Excel to the potentially strange and intimidating world of R.I made my voyage from Excel to R more th...

Read more »

Backtesting in Excel and R

February 17, 2011
By

This post is the introduction to a series that will illustrate how to backtest the same strategy in Excel and R.  The impetus for this series started with this tweet by Jared Woodard at Condor Options.  After Soren Macbeth introduced us, Jare...

Read more »

Backtesting in Excel and R

February 17, 2011
By

This post is the introduction to a series that will illustrate how to backtest the same strategy in Excel and R.  The impetus for this series started with this tweet by Jared Woodard at Condor Options.  After Soren Macbeth introduced us, Jare...

Read more »