7 Messages
Digest #3199
Messages
Fri Oct 3, 2014 3:16 pm (PDT) . Posted by:
t.palm27
Tony,
I use 7-zip and it worked just fine! Thanks a ton.
-Trent
I use 7-zip and it worked just fine! Thanks a ton.
-Trent
Sat Oct 4, 2014 8:57 am (PDT) . Posted by:
cgrablew
Randy,
I have been using the Table Load version to get the financial data into my spreadsheet for a number of years. It worked fine last week now the majority of the fields produced ERRORs. I suspect something has changed on the website. Any idea of how to fix the problem. I've attached the spreadsheet and if you looked under the Webdata tab you'll see the problem.
Thanks,
Chuck Grablewski
cgrablew@gmail.com
I have been using the Table Load version to get the financial data into my spreadsheet for a number of years. It worked fine last week now the majority of the fields produced ERRORs. I suspect something has changed on the website. Any idea of how to fix the problem. I've attached the spreadsheet and if you looked under the Webdata tab you'll see the problem.
Thanks,
Chuck Grablewski
cgrablew@gmail.com
Attachment(s) from
1 of 1 File(s)
Sat Oct 4, 2014 9:01 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/27031
On Sat, Oct 4, 2014 at 8:57 AM, cgrablew@... wrote:
> I have been using the Table Load version to get the financial data into
> my spreadsheet for a number of years. It worked fine last week now the
> majority of the fields produced ERRORs. I suspect something has changed on
> the website. Any idea of how to fix the problem. I've attached the
> spreadsheet and if you looked under the Webdata tab you'll see the problem.
>
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/27031
On Sat, Oct 4, 2014 at 8:57 AM, cgrablew@... wrote:
> I have been using the Table Load version to get the financial data into
> my spreadsheet for a number of years. It worked fine last week now the
> majority of the fields produced ERRORs. I suspect something has changed on
> the website. Any idea of how to fix the problem. I've attached the
> spreadsheet and if you looked under the Webdata tab you'll see the problem.
>
Sat Oct 4, 2014 2:31 pm (PDT) . Posted by:
rharmelink
FYI -- Someone over on the Motley Fool boards sent a note to Verus Analytics asking about the situation. Here is the response from VA that they posted on TMF:
"Hi Dave,
We were as surprised as you today. Microsoft failed to notify us that they wouldn't be including StockScouter in the new MSN Money website. It's surprising because it generates a lot of interest and page views. And, the editors that run MSN Money fought hard for it but the corporate business development team made the decision to exclude it.
We're in the process of reviewing our options for distributing the StockScouter scores but unfortunately we cannot negotiate with other finance websites until Microsoft has officially terminated our contract (they've yet to do so).
We will save your contact information so that we can update you once we know more. We're going to do everything possible find another home for StockScouter.
Kind regards,
Verus Analytics"
---In smf_addin@yahoogroups.com, <barryb47@gmail.com> wrote :
Does anyone know if another site picked up StockScouter? Does anyone have a "similar" metric?
Thank you,
Barry
"Hi Dave,
We were as surprised as you today. Microsoft failed to notify us that they wouldn't be including StockScouter in the new MSN Money website. It's surprising because it generates a lot of interest and page views. And, the editors that run MSN Money fought hard for it but the corporate business development team made the decision to exclude it.
We're in the process of reviewing our options for distributing the StockScouter scores but unfortunately we cannot negotiate with other finance websites until Microsoft has officially terminated our contract (they've yet to do so).
We will save your contact information so that we can update you once we know more. We're going to do everything possible find another home for StockScouter.
Kind regards,
Verus Analytics"
---In smf_addin@yahoogroups.com, <barryb47@gmail.com> wrote :
Does anyone know if another site picked up StockScouter? Does anyone have a "similar" metric?
Thank you,
Barry
Sat Oct 4, 2014 4:22 pm (PDT) . Posted by:
vishal.nathu
Hi Randy,
Thanks for this awesome plugin and support platform.
I'm trying to process the ticker, industry and sector p/e from Reuters.
=RCHGetElementNumber(A22,13626) =RCHGetElementNumber(A22,13627) =RCHGetElementNumber(A22,13628)
when i process this over 2000 tickers, 500ish work with the rest erroring... I'm not sure why this is, I know when i try a errored one on its own it works.
please can you advise.
Thanks for this awesome plugin and support platform.
I'm trying to process the ticker, industry and sector p/e from Reuters.
=RCHGetElementNumbe
when i process this over 2000 tickers, 500ish work with the rest erroring... I'm not sure why this is, I know when i try a errored one on its own it works.
please can you advise.
Sat Oct 4, 2014 4:32 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The add-in is meant as an ad hoc data retrieval tool, not one to build
databases with. It has a built-in limit of 1000 web pages per "session",
because it saves web pages internally before extracting the data, and there
are only 1000 slots for storing web pages.
I really don't want to see the free data services overloaded with web page
requests, because they could easily change the web pages so that the add-in
couldn't get at the data. It was a dilemma I pondered on when I decided to
share the add-in -- I had originally developed it for my own usage.
But if you're erroring out after 500 tickers, each ticker must be grabbing
data from two different web pages.
If you really do need that much data, you can grab data for 500 tickers,
convert those to values, run the smfForceRecalculation macro to purge all
of the saved web pages, then repeat those steps three more times.
On Sat, Oct 4, 2014 at 3:11 PM, vishal.nathu@yahoo.co.uk [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> I'm trying to process the ticker, industry and sector p/e from Reuters.
> =RCHGetElementNumber(A22,13626) =RCHGetElementNumber(A22,13627)
> =RCHGetElementNumber(A22,13628)
>
> when i process this over 2000 tickers, 500ish work with the rest
> erroring... I'm not sure why this is, I know when i try a errored one on
> its own it works.
>
> please can you advise.
>
databases with. It has a built-in limit of 1000 web pages per "session",
because it saves web pages internally before extracting the data, and there
are only 1000 slots for storing web pages.
I really don't want to see the free data services overloaded with web page
requests, because they could easily change the web pages so that the add-in
couldn't get at the data. It was a dilemma I pondered on when I decided to
share the add-in -- I had originally developed it for my own usage.
But if you're erroring out after 500 tickers, each ticker must be grabbing
data from two different web pages.
If you really do need that much data, you can grab data for 500 tickers,
convert those to values, run the smfForceRecalculation macro to purge all
of the saved web pages, then repeat those steps three more times.
On Sat, Oct 4, 2014 at 3:11 PM, vishal.nathu@yahoo.co.uk [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> I'm trying to process the ticker, industry and sector p/e from Reuters.
> =RCHGetElementNumbe
> =RCHGetElementNumbe
>
> when i process this over 2000 tickers, 500ish work with the rest
> erroring... I'm not sure why this is, I know when i try a errored one on
> its own it works.
>
> please can you advise.
>
Sat Oct 4, 2014 5:30 pm (PDT) . Posted by:
"Randy Randall" randyr_cds
You can get all of the data you need with finviz with 3 internet access.
Place of of these in their own worksheet. You can then create a 4th
worksheet and use excel's "VLOOKUP" function to get the values you need
from your "Stock", "Sector", and "Industry" worksheets.
I don't know of all of the tickers you you have are in finviz's database,
or how they compare to Reuter's.
PE for all of the stocks in Finviz's (www.finviz.com) database:
finviz.com/export.ashx?v=111
PE for all industries:
finviz.com/grp_export.ashx?g=industry&v=120&o=name
PE for all sectors:
finviz.com/grp_export.ashx?g=sector&v=120&o=name
On Sat, Oct 4, 2014 at 6:11 PM, vishal.nathu@yahoo.co.uk [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
>
> Hi Randy,
>
>
> Thanks for this awesome plugin and support platform.
>
>
> I'm trying to process the ticker, industry and sector p/e from Reuters.
>
> =RCHGetElementNumber(A22,13626) =RCHGetElementNumber(A22,13627)
> =RCHGetElementNumber(A22,13628)
>
>
>
> when i process this over 2000 tickers, 500ish work with the rest
> erroring... I'm not sure why this is, I know when i try a errored one on
> its own it works.
>
>
> please can you advise.
>
>
>
>
>
Place of of these in their own worksheet. You can then create a 4th
worksheet and use excel's "VLOOKUP" function to get the values you need
from your "Stock", "Sector", and "Industry" worksheets.
I don't know of all of the tickers you you have are in finviz's database,
or how they compare to Reuter's.
PE for all of the stocks in Finviz's (www.finviz.com) database:
finviz.com/export.ashx?v=111
PE for all industries:
finviz.com/grp_export.ashx?g=industry&v=120&o=name
PE for all sectors:
finviz.com/grp_export.ashx?g=sector&v=120&o=name
On Sat, Oct 4, 2014 at 6:11 PM, vishal.nathu@yahoo.co.uk [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
>
> Hi Randy,
>
>
> Thanks for this awesome plugin and support platform.
>
>
> I'm trying to process the ticker, industry and sector p/e from Reuters.
>
> =RCHGetElementNumbe
> =RCHGetElementNumbe
>
>
>
> when i process this over 2000 tickers, 500ish work with the rest
> erroring... I'm not sure why this is, I know when i try a errored one on
> its own it works.
>
>
> please can you advise.
>
>
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar