Messages In This Digest (5 Messages)
- 1a.
- Re: Get data for over 3000 companies? - Follow up From: Ron Spruell
- 2a.
- Why isn't it signed in? From: chaim422
- 2b.
- Re: Why isn't it signed in? From: Randy Harmelink
- 2c.
- Re: Why isn't it signed in? From: savantllc
- 2d.
- Re: Why isn't it signed in? From: Randy Harmelink
Messages
- 1a.
-
Re: Get data for over 3000 companies? - Follow up
Posted by: "Ron Spruell" hashky@yahoo.com hashky
Wed Oct 26, 2011 9:31 am (PDT)
Randy -
I bought and installed Excel 2010. That solved the problems. I am lost in the new "Ribbon" interface, but time should cure my confusion. I will be working on this spreadsheet as soon as I get used to the interface.
Ron
>____________________ _________ ___
>From: Randy Harmelink <rharmelink@gmail.com >
>To: smf_addin@yahoogroups.com
>Sent: Friday, October 14, 2011 11:42 PM
>Subject: Re: [smf_addin] Get data for over 3000 companies?
>
>
>
>I think it's an EXCEL 2003 problem. I just got rid of the function and kept just:
>
>="http://finviz.com/export. "&smfJoin(A8:ashx?v=151& T= A56,",")& "&c="&smfJoin( B6:C6,"," )
>
>That string is exactly 255 bytes long. I doubt that is a coincidence. My bet would be that if that string gets longer than 255 bytes, EXCEL 2003 has a problem. Try these two functions:
>
>=LEN("http://finviz.com/export. "&smfJoin(A8:ashx?v=151& T= A56,",")& "&c="&smfJoin( B6:C6,"," ))
>=LEN("http://finviz.com/export. "&smfJoin(A8:ashx?v=151& T= A66,",")& "&c="&smfJoin( B6:C6,"," ))
>
>...and see if you get an error on the second LEN() function.
>
>If that is the problem, the easiest solution would be to drop the "t=" parameter and just get a list of all ticker symbols. But that will make your VLOOKUP() processing a little slower.
>
>
>On Fri, Oct 14, 2011 at 9:27 PM, Ron Spruell <hashky@yahoo.com > wrote:
>
>
>>
>>I am using the beta version.
>>Stock Market Functions add-in, Version 2.1.2011.04.03 (C:\Program Files\SMF Add-In; 1)
>>
>>
>>I installed the UDF sfJoin and tried it. No change. 47 Tickers is the working limit. After that everything turns to #Value!
>>
>>
>>Here are 3 files. The first is a pdf with a Ticker input Range of A8:A56 with values. The second is a pdf with a Ticker input Range of A8:A57 which has the #VALUE! output. The third is the xls file.
>>
>>
>>Where should I go from here?
>>
>
>
>
>
- 2a.
-
Why isn't it signed in?
Posted by: "chaim422" chaim422@gmail.com chaim422
Wed Oct 26, 2011 10:44 pm (PDT)
Hi Randy.
I have been trying to get data from Portfolio123 but it is reaching the message about reaching a member only page. This is after I made sure to log in with IE and Excel Query (I was able to get to the premium content in Excel Query). RCHGetWebData is only reaching the message about subscribing. Any ideas for me?
Thanks,
Chip
- 2b.
-
Re: Why isn't it signed in?
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Wed Oct 26, 2011 10:59 pm (PDT)
Did you run smfForceRecalculation after logging in? You could still be
extracting data from a previously saved copy of a web page...
Otherwise, it should work, as far as I know.
On Wed, Oct 26, 2011 at 10:44 PM, chaim422 <chaim422@gmail.com > wrote:
>
> I have been trying to get data from Portfolio123 but it is reaching the
> message about reaching a member only page. This is after I made sure to log
> in with IE and Excel Query (I was able to get to the premium content in
> Excel Query). RCHGetWebData is only reaching the message about subscribing.
> Any ideas for me?
>
- 2c.
-
Re: Why isn't it signed in?
Posted by: "savantllc" savantllc@mailworks.org enginsburg
Thu Oct 27, 2011 3:40 am (PDT)
How di I run smfForceRecalculation?
On 10/27/2011 1:59 AM, Randy Harmelink wrote:
>
> Did you run smfForceRecalculation after logging in? You could still be
> extracting data from a previously saved copy of a web page...
>
> Otherwise, it should work, as far as I know.
>
> On Wed, Oct 26, 2011 at 10:44 PM, chaim422 <chaim422@gmail.com
> <mailto:chaim422@gmail.com >> wrote:
>
>
> I have been trying to get data from Portfolio123 but it is
> reaching the message about reaching a member only page. This is
> after I made sure to log in with IE and Excel Query (I was able to
> get to the premium content in Excel Query). RCHGetWebData is only
> reaching the message about subscribing. Any ideas for me?
>
>
>
- 2d.
-
Re: Why isn't it signed in?
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Oct 27, 2011 3:41 am (PDT)
See the "Links" area of the group for information on the macro...
On Thu, Oct 27, 2011 at 2:56 AM, savantllc <savantllc@mailworks.org > wrote:
>
> How di I run smfForceRecalculation?
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
MARKETPLACE
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Tidak ada komentar:
Posting Komentar