Need for information in order to answer your request.

Please provide details.

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of crforster1@yahoo.com
Sent: Tuesday, April 15, 2014 3:42 AM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] Cash Flow_17S (update)

Hi Kermit,

I'm also having trouble, but i think that the site links have changed for msn? any work around for this?

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

1c

Re: Cash Flow_17S (update)

Tue Apr 15, 2014 8:23 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I looked at it at one point and gave up. The site links are easy to change
-- just do a "find and replace all" of the URLs. I think that gets you
about 80% of the way there.

However, MSN also changed up the available line items and their labels.
That was the difficult part.

On Tue, Apr 15, 2014 at 12:42 AM, <crforster1@yahoo.com> wrote:

>
> I'm also having trouble, but i think that the site links have changed for
> msn? any work around for this?
>
>

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

1d

Re: Cash Flow_17S (update)

Tue Apr 15, 2014 9:35 am (PDT) . Posted by:

"Rob Kennedy" manhattancollegejaspers

Your name is Kermit??? LMAO!!!

> On Apr 15, 2014, at 10:59 AM, "Kermit W. Prather" <kermitp@tampabay.rr.com> wrote:
>
> Need for information in order to answer your request.
>
>
>
> Please provide details.
>
>
>
> From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of crforster1@yahoo.com
> Sent: Tuesday, April 15, 2014 3:42 AM
> To: smf_addin@yahoogroups.com
> Subject: RE: [smf_addin] Cash Flow_17S (update)
>
>
>
>
>
> Hi Kermit,
>
>
>
> I'm also having trouble, but i think that the site links have changed for msn? any work around for this?
>
>
>
>
>
>
>

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

1e

Re: Cash Flow_17S (update)

Tue Apr 15, 2014 1:13 pm (PDT) . Posted by:

"Kermit W. Prather" kermitpra

YEP! And I had the nickname "Green Frog" long before that toad showed up.

Have a nice day, happy to be your entertainment.

KERMIT

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Rob Kennedy
Sent: Tuesday, April 15, 2014 12:09 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Cash Flow_17S (update)

Your name is Kermit??? LMAO!!!

On Apr 15, 2014, at 10:59 AM, "Kermit W. Prather" <kermitp@tampabay.rr.com> wrote:

Need for information in order to answer your request.

Please provide details.

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of crforster1@yahoo.com
Sent: Tuesday, April 15, 2014 3:42 AM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] Cash Flow_17S (update)

Hi Kermit,

I'm also having trouble, but i think that the site links have changed for msn? any work around for this?

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

2a

Spreadsheet Cash Flow_17S (update)

Tue Apr 15, 2014 8:21 am (PDT) . Posted by:

crforster1

Hi All,

I would like to first say that these sheet by all are fantastic!

So far, I've been able to get most of the sheets working. I've installed everything correctly, but i'm not sure about if I have updated the text documents in the add in download correctly.

In the workbook, sheet "Financials Import" I have the following original formulas but i'm not sure how to update them as I believe the website has been updated:

=RCHGetTableCell("http://moneycentral.msn.com/investor/invsub/results/statemnt.aspx?lstStatement=Income&stmtView=Ann&Symbol="&Ticker, 5,"Period Length")

Can anyone pls advise how i might correct this and also update for the sheets?

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

2b

Re: Spreadsheet Cash Flow_17S (update)

Tue Apr 15, 2014 8:29 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

That's one of those that is an issue, because "Period Length" is no longer
a line item on the MSN financial statements page. Since it's annual, you
could just hard-code 12 there. That assumption will be valid 99.9% of the
time.

In any case, getting "Period Ending" from the new web site would be
something like:

=RCHGetTableCell("
http://investing.money.msn.com/investments/stock-income-statement/?symbol="&C6,
5,"Period End Date")

So, you could do a "find and replace all" of:

http://moneycentral.msn.com/investor/invsub/results/statemnt.aspx?lstStatement=Income&stmtView=Ann&Symbol=

...to:

http://investing.money.msn.com/investments/stock-income-statement/?symbol=

...to correct all URLs of the annual income statement formulas.

But that still leaves a number of manual corrections.

On Tue, Apr 15, 2014 at 12:40 AM, <crforster1@yahoo.com> wrote:

>
> I would like to first say that these sheet by all are fantastic!
>
> So far, I've been able to get most of the sheets working. I've installed
> everything correctly, but i'm not sure about if I have updated the text
> documents in the add in download correctly.
>
> In the workbook, sheet "Financials Import" I have the following original
> formulas but i'm not sure how to update them as I believe the website has
> been updated:
>
> =RCHGetTableCell("
> http://moneycentral.msn.com/investor/invsub/results/statemnt.aspx?lstStatement=Income&stmtView=Ann&Symbol="&Ticker,
> 5,"Period Length")
>
> Can anyone pls advise how i might correct this and also update for the
> sheets?
>

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

2c

Re: Spreadsheet Cash Flow_17S (update)

Tue Apr 15, 2014 11:09 am (PDT) . Posted by:

"Colin Forster" crforster1

Many thanks Randy! Really appreciate it.
On Tuesday, April 15, 2014 4:29 PM, Randy Harmelink <rharmelink@gmail.com> wrote:

That's one of those that is an issue, because "Period Length" is no longer a line item on the MSN financial statements page. Since it's annual, you could just hard-code 12 there. That assumption will be valid 99.9% of the time.

In any case, getting "Period Ending" from the new web site would be something like:

=RCHGetTableCell("http://investing.money.msn.com/investments/stock-income-statement/?symbol="&C6, 5,"Period End Date")

So, you could do a "find and replace all" of:

http://moneycentral.msn.com/investor/invsub/results/statemnt.aspx?lstStatement=Income&stmtView=Ann&Symbol=

...to:

http://investing.money.msn.com/investments/stock-income-statement/?symbol=

...to correct all URLs of the annual income statement formulas.

But that still leaves a number of manual corrections.

On Tue, Apr 15, 2014 at 12:40 AM, <crforster1@yahoo.com> wrote:

>
>I would like to first say that these sheet by all are fantastic!
>
>
>So far, I've been able to get most of the sheets working. I've installed everything correctly, but i'm not sure about if I have updated the text documents in the add in download correctly.
>
>
>In the workbook, sheet "Financials Import" I have the following original formulas but i'm not sure how to update them as I believe the website has been updated:
>
>
> =RCHGetTableCell("http://moneycentral.msn.com/investor/invsub/results/statemnt.aspx?lstStatement=Income&stmtView=Ann&Symbol="&Ticker, 5,"Period Length")
>
>
>Can anyone pls advise how i might correct this and also update for the sheets?
>

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

3a

FWallStreet spreadsheets, anyone could reupload pls?

Tue Apr 15, 2014 6:15 pm (PDT) . Posted by:

spanish_biker79

Hello guys,
I saw online that Joe Ponzio from FWallStreet provided with a few free spreadsheets a few years ago. It seems that some of them, like DCF_FWallStreet.xls, was uploaded to the group in the past as well, but cannot find a copy anywhere.

Anyone having a copy that could re-upload or send me by email please?

Much appreciated,
M.

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

3b

Re: FWallStreet spreadsheets, anyone could reupload pls?

Tue Apr 15, 2014 6:18 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

They were deleted by the original uploader several years ago, so I assume
he doesn't want them posted here.

On Tue, Apr 15, 2014 at 5:40 PM, <apriliapegaso28@hotmail.com> wrote:

>
> I saw online that Joe Ponzio from FWallStreet provided with a few free
> spreadsheets a few years ago. It seems that some of them, like
> DCF_FWallStreet.xls, was uploaded to the group in the past as well, but
> cannot find a copy anywhere.
>
> Anyone having a copy that could re-upload or send me by email please?
>
>