Go Premium for a chance to win a PS4. Enter to Win

x

Spreadsheets

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.

Share tech news, updates, or what's on your mind.

Sign up to Post

I am putting the finishing touches on a tutorial about how to use R programming interfaced with MS-Excel. I decided to show how to obtain stock prices from Yahoo Finance. I realize that this can be done directly in Excel. However, R has some great libraries that make getting prices from third-party providers seamless. But, as you know, R is weak in its front-end feature. Besides, people who use spreadsheets regularly (or should I say religiously) can now take advantage of these libraries with the interface. They get the benefit of R without having to give up Excel. That's a win-win in my book.

I was wondering if this concept seems like something you would want to learn. There are many libraries (packages) developed in R and more are being developed constantly. Let me know if this sounds like a concept you want to learn
3
 
LVL 35

Expert Comment

by:[ fanpages ]
Hi James,

Your article, "Why R Programming Will Become Your Go To Language", has piqued my interest in learning more so, yes, the suggestion of a tutorial for an 'R' interface with MS-Excel is certainly something I would wish to read.

Thank you :)
0
Ask an Anonymous Question!
LVL 11
Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Oy... You ever make some changes to the underlying data columns in a spreadsheet and then not realize that it inadvertently messed up a whole bunch of other pivot tables and charts as a result? Well, I just did... Fortunately, the Google Sheets revision history feature is pretty darn good and just saved me from having to do a bunch of annoying fixes. Thanks, Google!
3
 
LVL 7

Author Comment

by:Brian Matis
@Kyle
Undo buttons are the best.
I kid you not, but whenever I do anything klutzy in real life (knock over a mug, bang my shin on something, etc.) I mentally try to hit Ctrl-Z. Sadly, it never works... ;-)
1
 
LVL 17

Expert Comment

by:Kyle Santos
Truth
1
Keyboard shortcuts in Google Sheets for inserting a new row:

In Chrome on Windows or Linux:
  • Alt + I, then R
In IE or Firefox on Windows or Linux:
  • Alt + Shift + I, then R
On a mac:
  • Ctrl + Option + I, then R

Just remember I for Insert and R for row.
2
 
LVL 7

Expert Comment

by:Brian Matis
It's funny... I'm incredibly used to using keyboard shortcuts at the OS level and in desktop apps, but I often don't think to check for keyboard shortcuts in web apps. JIRA has been the one major exception—at some point early on in my use of it, they did a good job of encouraging shortcut usage—but this is a great reminder to investigate keyboard shortcut support in other common web apps.
0
 
LVL 10

Author Comment

by:Brandon Lyon
I just got tired of right clicking and selecting insert new line all the time. It's an operation I do frequently on one of my sheets in particular.
1

Spreadsheets

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.