[smf_addin] Digest Number 3036

EXCEL Stock Market Functions Add-in Group

3 Messages

Digest #3036

1a

Re: How do i extract 10-year financial data for my companies? by "Randy Harmelink" rharmelink

1b

Re: How do i extract 10-year financial data for my companies? by scott.vo@sbcglobal.net

2

Re: How do i extract 10-year financial data for my companies? [1 Att by "Linh Le" linhle1784

Messages

1a

Re: How do i extract 10-year financial data for my companies?

Mon Apr 7, 2014 11:23 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Just run the smfFixLinks macro from the add-in.

The unresolved links are probably because you have the add-in located in a
different location than the creator of the workbook. EXCEL saves a
hard-coded location of the add-in whenever it saves a file.

On Mon, Apr 7, 2014 at 11:16 PM, Linh Le <linhle1784@yahoo.com> wrote:

>
> I've tried both the templates available through your examples and those
> uploaded by the groups'. Excel prompt me to "update links" every time i
> open the sheets. I just want to be able to see the functions in order to
> replicate for my companies' financial statements.
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (7) . Top ^

1b

Re: How do i extract 10-year financial data for my companies?

Mon Apr 7, 2014 11:25 pm (PDT) . Posted by:

scott.vo@sbcglobal.net

Linh,
Here are the steps
Enable Content --> Edit Links --> Change Source --> Select the RCH_Stock_Market_Functions Add-in --> OK --> Close
You should be good to go.
Scott

Reply to sender . Reply to group . Reply via Web Post . All Messages (7) . Top ^

2

Re: How do i extract 10-year financial data for my companies? [1 Att

Mon Apr 7, 2014 11:31 pm (PDT) . Posted by:

"Linh Le" linhle1784

I have downloaded the add-in to Excel and i'm now trying to figure out how import 10-year financial statements from the either yahoo, reuters, or google finance into Excel using SMF to start practicing my valuation skills. How do i do that? Thank you. 
On Tuesday, April 8, 2014 12:23 AM, "scottvo001@yahoo.com" <scottvo001@yahoo.com> wrote:

 
[Attachment(s) from scottvo001@yahoo.com included below]
Linh,

Download RCH_Stock_Market_Functions, then follow these steps

Click Enable Content --> Edit Links --> Change Source --> Select the RCH_Stock_Market_Functions file --> OK --> Close

You should good to go.
Scott

Reply to sender . Reply to group . Reply via Web Post . All Messages (1) . Top ^

Visit Your Group

• New Members 49

• Privacy • Unsubscribe • Terms of Use