Senin, 29 Juni 2015

[smf_addin] Digest Number 3444

10 Messages

Digest #3444

Messages

Sun Jun 28, 2015 8:34 am (PDT) . Posted by:


Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.

File : /Uploads by forum members/Stock Review 2015.xlsm
Uploaded by : mrpatmcginnis <mrpatmcginnis@yahoo.com>
Description : Stock Valuation spreadsheet using Google financials and ignores years no longer supported. Change Ticker symbol in tab Rule1 - cell A1.(Includes work from others in group). Randy - hope you are well!

You can access this file at the URL:
https://groups.yahoo.com/neo/groups/smf_addin/files/Uploads%20by%20forum%20members/Stock%20Review%202015.xlsm

To learn more about file sharing for your group, please visit:
https://help.yahoo.com/kb/index?page=content&y=PROD_GRPS&locale=en_US&id=SLN15398

Regards,

mrpatmcginnis <mrpatmcginnis@yahoo.com>

Sun Jun 28, 2015 12:17 pm (PDT) . Posted by:

panda317

This file just gives me #NAME? for almost all the fields.

How do I fix that?

Sun Jun 28, 2015 12:53 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

That either means you don't have the add-in installed, or you have location
errors. For location errors, try running the smfFixLinks macro.

On Sun, Jun 28, 2015 at 12:16 PM, pat@... wrote:

>
> This file just gives me #NAME? for almost all the fields.
>
> How do I fix that?
>

Sun Jun 28, 2015 12:58 pm (PDT) . Posted by:

"Joseph McCarthy" mccarjb

I can tell you how I did it in Excel 2010. Assumes you already have the SMF Add-In installed.1) Open the spreadsheet2) Click on the "Enable Editing" link that should open at the top of the spreadsheet3) A window will open, click on the "Edit Links" button4) Once the "Edit Links" window opens, click on the "Change Source" button.5) Navigate to the location of your SMF Add-In file.6) Select RCH_Stock_Market_Functions, and click Okay.7) If the values in your spreadsheet don't update automatically, click on the "Update Values" button.8) Close the "Edit Links" window.
To: smf_addin@yahoogroups.com
From: smf_addin@yahoogroups.com
Date: Sun, 28 Jun 2015 12:16:59 -0700
Subject: [smf_addin] Re: New file uploaded to smf_addin

This file just gives me #NAME? for almost all the fields.

How do I fix that?

Sun Jun 28, 2015 2:55 pm (PDT) . Posted by:

panda317

Well, my other spreadsheet works just fine.

This new one does not.

I selected run macro, and pasted smfFixLinks in the macro name field and clicked run.

It still does not work.

Sun Jun 28, 2015 3:27 pm (PDT) . Posted by:

"Joseph McCarthy" mccarjb

What version of excel are you using (on the problem PC)?
To: smf_addin@yahoogroups.com
From: smf_addin@yahoogroups.com
Date: Sun, 28 Jun 2015 15:12:27 -0700
Subject: RE: [smf_addin] Re: New file uploaded to smf_addin

That did not work, either....

Sun Jun 28, 2015 8:28 pm (PDT) . Posted by:

panda317

Office Pro 2010

Excel Version 14.0.7151.5001 (32-bit)

Sun Jun 28, 2015 9:48 pm (PDT) . Posted by:

"Joseph McCarthy" mccarjb

I'm using Office 2010 on my desktop.- If the spreadsheet is open, click on Data, Edit Links. This will open the Edit Links window.- With the RCH_Stock_Market_Functions.xla file highlighted, look at the Location just below the windows horizontal scroll bar.- The file was originally set to use the .xla file at C:\Users\pat\Documents\SMF Add-in.- You need to change the source to get it to point to your SMF Add-in folder. I'm not sure where yours is installed. On my system it's C:\SMF Add-In. To make that change, click on the Change Source button, then navigate to your SMS Add-In folder, highlight the RCH_Stock_Market_Functions.xla file, and click OK. This will put you back at the Edit Links window.- Wait for a few moments and you should see the "Location:" entry pointing to your own SMF Add-In folder.- If the links don't update automatically, click on the Update Values button, then Close the Edit Links window.
To: smf_addin@yahoogroups.com
From: smf_addin@yahoogroups.com
Date: Sun, 28 Jun 2015 20:28:18 -0700
Subject: RE: [smf_addin] Re: New file uploaded to smf_addin

Office Pro 2010

Excel Version 14.0.7151.5001 (32-bit)

Sun Jun 28, 2015 10:43 pm (PDT) . Posted by:

raniersfury

I've been using a workbook from a couple years back that was retrieving 10 years of annual financial data from Gurufocus (most cells retrieving data using the =RCHGetTableCell("http://www.gurufocus.com/financials/"&Ticker,D$1,"except for per share",">"&$C$5) formulas for the income statement, balance sheet, cash flow statement, and per share data).


With the Gurufocus move to 15 year data, the spreadsheet has "crashed", meaning I get #VALUE!, error, and/or blank amounts for almost all fields, the period of which is now the first 10 of the 15 year period (i.e. no financial data for the most recent five years).


Any suggestions on a new formula to go about retrieving the most recent 10 years of financial data from Gurufocus?


Otherwise, is there a different workbook that pulls this 10 year data from another site? I think I moved to the Gurufocus workbook from ADVFN, when the ADVFN website changed their formatting.


Any formula updates, or different 10 year workbook suggestions would be appreciated.


Chuck

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar