Selasa, 22 September 2015

[smf_addin] Digest Number 3519

5 Messages

Digest #3519
1b
Re: Changes at Investors.com by "Randy Harmelink" rharmelink
2a
back testing models by samil_beret
2b
Re: back testing models by "Randy Harmelink" rharmelink

Messages

Mon Sep 21, 2015 5:42 am (PDT) . Posted by:

sirons1962

I have a sheet programmed to help "grade" a stock and one of the pieces it uses in whether the stock is on the NYSE or NASDAQ. Before the recent changes at investors.com I used to use "=smfGetTagContent(URLCheckup,"span",9)" and it would show either the NYSE or NASDAQ. Now it shows the name of the stock I am looking up.

I tried to search for another way to extract this but I am having no luck.

Anyone have an idea?

Thanks


Mon Sep 21, 2015 8:27 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Stock exchange is already contained with the URLCheckup cell that you are
using. Just extract it from there:

=smfStrExtr(URLCheckup,"checkup/","-")

Or just use a variation of the formula from the IBD template that is used
to create the URL:

=smfStrExtr(RCHGetWebData("
http://www.investors.com/search/searchresults.aspx?Ntt=
"&B2,"/quotes/"),"/quotes/","-")

On Mon, Sep 21, 2015 at 5:42 AM, sirons1962@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I have a sheet programmed to help "grade" a stock and one of the pieces it
> uses in whether the stock is on the NYSE or NASDAQ. Before the recent
> changes at investors.com I used to use
> "=smfGetTagContent(URLCheckup,"span",9)" and it would show either the NYSE
> or NASDAQ. Now it shows the name of the stock I am looking up.
>
> I tried to search for another way to extract this but I am having no luck.
>
> Anyone have an idea?
>

Mon Sep 21, 2015 8:38 am (PDT) . Posted by:

sirons1962

That worked, thank you Randy!

Mon Sep 21, 2015 10:45 am (PDT) . Posted by:

samil_beret

Hi Randy


I would like to back-test a few models correlating stock price to historical fiancial ratios going back 10 years [ for example enterprise value/EBIDTA, free cash flow, REQ etc]. How can I retrieve these financial ratios quarterly for the past 10 years ?
Thanks for your help


Best Regards
Samil Beret

Mon Sep 21, 2015 4:15 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

If you're serious about back-testing, I would suggest using
Portfolio123.com. Just do the free trial and test out the things you need.
The big advantage there is that all of the data is "point in time".
Otherwise, you'd need to retrieve data from something like AdvFN or
GuruFocus (subscription needed), which will have quarterly data often
restated, so your backtesting isn't valid, because that information
wouldn't have existed when you were making your investment decisions.

Plus, you shouldn't be building databases using the add-in. Which is what
you'd need to do backtesting of that type. It isn't fair to the free data
providers, and I wouldn't want them having a motivation to shut down access
to their data with a tool like the add-in.

On Mon, Sep 21, 2015 at 10:45 AM, sberet@... wrote:

> I would like to back-test a few models correlating stock price to
> historical fiancial ratios going back 10 years [ for example enterprise
> value/EBIDTA, free cash flow, REQ etc]. How can I retrieve these financial
> ratios quarterly for the past 10 years ?
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar