5 Messages
Digest #3519
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
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?
>
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
> "=smfGetTagCon
> 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 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
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 ?
>
>
Portfolio123.
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'
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:
Posting Komentar