Selasa, 19 Juni 2012

[smf_addin] Digest Number 2251

Messages In This Digest (21 Messages)

1a.
ValueLine From: smithjhhic
1b.
Re: ValueLine From: Randy Harmelink
1c.
Re: ValueLine From: smithjhhic
1d.
Re: ValueLine From: Randy Harmelink
1e.
Re: ValueLine From: smithjhhic
1f.
Re: ValueLine From: Randy Harmelink
2a.
Company Description From: juranek54
2b.
Re: Company Description From: Randy Harmelink
3a.
magicformulainvesting.com From: carmine288
3b.
Re: magicformulainvesting.com From: Randy Harmelink
3c.
Re: magicformulainvesting.com From: carmine288
3d.
Re: magicformulainvesting.com From: Randy Harmelink
4a.
Re: GetWebData can't update data timely [1 Attachment] From: bobc94595
4b.
Re: GetWebData can't update data timely From: Randy Harmelink
5a.
Getting Chart data  to excel ( Reuters) From: rmarshal78
5b.
Re: Getting Chart data to excel ( Reuters) From: Randy Harmelink
5c.
Re: Getting Chart data to excel ( Reuters) From: Viju Joseph
5d.
Re: Getting Chart data to excel ( Reuters) From: Randy Harmelink
6a.
addin question From: mknu@juno.com
6b.
Re: addin question From: Randy Harmelink
7.
RCHGetYahooQuotes Array with Autofilter From: back

Messages

1a.

ValueLine

Posted by: "smithjhhic" smithjhhic@yahoo.com   smithjhhic

Mon Jun 18, 2012 4:13 am (PDT)



Hello,
I am trying to utilize the tread from Message #16597 to obtain Valueline data from http://www3.valueline.com/vlquotes/quote.aspx

If I am logged into VL and the formula from Message #16597 works fine. However, I am unable to obtain other data using the formula (ex. Timeliness:). I don't fully understand the formula and it probably takes more than replacing "Beta:" with "Timeliness:". Below is code for that portion of site for ALGT. Any help would be appreciated.

<td><div class="alignleft"><b>Timeliness:</b></div> <div class="alignright">2</div><br />
<div style="clear: both;"></div>
<div class="alignleft"><b>Safety:</b></div> <div class="alignright">3</div><br />
<div style="clear: both;"></div>
<div class="alignleft"><b>Technical:</b></div> <div class="alignright">4</div><br />
<div style="clear: both;"></div>
<div class="alignleft"><b>Beta:</b></div> <div class="alignright">0.75 (1.00=Market)</div></td>

1b.

Re: ValueLine

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Mon Jun 18, 2012 10:40 am (PDT)



That's because you don't need the smfStrExtr() portion of the function. The
Beta extraction has additional verbiage after the stated value (i.e.
"(1.00=Market)"), so it needs to be extracted.

I think this would work, although I can't test it:

=0+smfGetTagContent("
http://www3.valueline.com/vlquotes/quote.aspx?symbol=MMM
","div",1,"Timeliness:")

On Mon, Jun 18, 2012 at 4:13 AM, smithjhhic <smithjhhic@yahoo.com> wrote:

> Hello,
> I am trying to utilize the tread from Message #16597 to obtain Valueline
> data from http://www3.valueline.com/vlquotes/quote.aspx
>
> If I am logged into VL and the formula from Message #16597 works fine.
> However, I am unable to obtain other data using the formula (ex.
> Timeliness:). I don't fully understand the formula and it probably takes
> more than replacing "Beta:" with "Timeliness:". Below is code for that
> portion of site for ALGT. Any help would be appreciated.
>
> <td><div class="alignleft"><b>Timeliness:</b></div> <div
> class="alignright">2</div><br />
> <div style="clear: both;"></div>
> <div class="alignleft"><b>Safety:</b></div> <div
> class="alignright">3</div><br />
> <div style="clear: both;"></div>
> <div class="alignleft"><b>Technical:</b></div> <div
> class="alignright">4</div><br />
> <div style="clear: both;"></div>
> <div class="alignleft"><b>Beta:</b></div> <div class="alignright">0.75
> (1.00=Market)</div></td>
>
1c.

Re: ValueLine

Posted by: "smithjhhic" smithjhhic@yahoo.com   smithjhhic

Mon Jun 18, 2012 4:23 pm (PDT)



Randy,
I get "#Value!". I don't think it's because of a login issue because it does not work for me on data that is free (ie. YTD: or EPS:). Those free data fields should work with your formula as well, correct? I appreciate any help.
Jeff

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> That's because you don't need the smfStrExtr() portion of the function. The
> Beta extraction has additional verbiage after the stated value (i.e.
> "(1.00=Market)"), so it needs to be extracted.
>
> I think this would work, although I can't test it:
>
> =0+smfGetTagContent("
> http://www3.valueline.com/vlquotes/quote.aspx?symbol=MMM
> ","div",1,"Timeliness:")
>
> On Mon, Jun 18, 2012 at 4:13 AM, smithjhhic <smithjhhic@...> wrote:
>
> > Hello,
> > I am trying to utilize the tread from Message #16597 to obtain Valueline
> > data from http://www3.valueline.com/vlquotes/quote.aspx
> >
> > If I am logged into VL and the formula from Message #16597 works fine.
> > However, I am unable to obtain other data using the formula (ex.
> > Timeliness:). I don't fully understand the formula and it probably takes
> > more than replacing "Beta:" with "Timeliness:". Below is code for that
> > portion of site for ALGT. Any help would be appreciated.
> >
> > <td><div class="alignleft"><b>Timeliness:</b></div> <div
> > class="alignright">2</div><br />
> > <div style="clear: both;"></div>
> > <div class="alignleft"><b>Safety:</b></div> <div
> > class="alignright">3</div><br />
> > <div style="clear: both;"></div>
> > <div class="alignleft"><b>Technical:</b></div> <div
> > class="alignright">4</div><br />
> > <div style="clear: both;"></div>
> > <div class="alignleft"><b>Beta:</b></div> <div class="alignright">0.75
> > (1.00=Market)</div></td>
> >
>

1d.

Re: ValueLine

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Mon Jun 18, 2012 6:10 pm (PDT)



Drop the "0+" from the formula and you'll see what the function is
returning. It must be returning something that is non-numeric, which causes
the #VALUE! error. I get a #VALUE! error on the formula when I use it --
because I'm not a subscriber and it gives me a link instead of a value.

The smfGetTagContent() function will not work with EPS: or YTD: as those
values are presented in a table. So:

=RCHGetTableCell("http://www3.valueline.com/vlquotes/quote.aspx?symbol=MMM
",1,"EPS:")

You do have to look at the source code of the web page to determine how to
extract things.

On Mon, Jun 18, 2012 at 4:22 PM, smithjhhic <smithjhhic@yahoo.com> wrote:

>
> I get "#Value!". I don't think it's because of a login issue because it
> does not work for me on data that is free (ie. YTD: or EPS:). Those free
> data fields should work with your formula as well, correct? I appreciate
> any help.
>
1e.

Re: ValueLine

Posted by: "smithjhhic" smithjhhic@yahoo.com   smithjhhic

Mon Jun 18, 2012 6:37 pm (PDT)



Randy,
Thank you for your help. That worked for the unprotected fields. I now am getting "Error" for the protected fields. I am logged in via IE. That did not seem to log me in via Excel as when I brought up the web page in Excel I had to log in again to view the protected fields. I will need to read previous posts to learn more about log-ins as it is the first time I am using.
v/r,
Jeff

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Drop the "0+" from the formula and you'll see what the function is
> returning. It must be returning something that is non-numeric, which causes
> the #VALUE! error. I get a #VALUE! error on the formula when I use it --
> because I'm not a subscriber and it gives me a link instead of a value.
>
> The smfGetTagContent() function will not work with EPS: or YTD: as those
> values are presented in a table. So:
>
> =RCHGetTableCell("http://www3.valueline.com/vlquotes/quote.aspx?symbol=MMM
> ",1,"EPS:")
>
> You do have to look at the source code of the web page to determine how to
> extract things.
>
> On Mon, Jun 18, 2012 at 4:22 PM, smithjhhic <smithjhhic@...> wrote:
>
> >
> > I get "#Value!". I don't think it's because of a login issue because it
> > does not work for me on data that is free (ie. YTD: or EPS:). Those free
> > data fields should work with your formula as well, correct? I appreciate
> > any help.
> >
>

1f.

Re: ValueLine

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Mon Jun 18, 2012 6:59 pm (PDT)



Another possibility -- rare, but I have seen it. EXCEL may not be using the
same version of IE that you are using as a browser. That's one reason I
usually prefer people log in using the EXCEL Web Query dialog. It
guarantees that the version of IE that the add-in is using is the correct
one.

It's easy to check if you are logged in properly -- visit the web page in
the Web Query dialog and see if you can see the subscriber fields.

Also, you may want to run the smfForceRecalculation macro to ensure that
you have a current copy of the web page. The add-in extracts data from a
saved copy of the web page. So, if it saved it before you logged in, you'll
still be attempting to extract data from that saved copy -- which is a
pre-login copy. The macro will purge the saved copy of the web page so that
a fresh one has to be retrieved.

On Mon, Jun 18, 2012 at 6:37 PM, smithjhhic <smithjhhic@yahoo.com> wrote:

>
> Thank you for your help. That worked for the unprotected fields. I now
> am getting "Error" for the protected fields. I am logged in via IE. That
> did not seem to log me in via Excel as when I brought up the web page in
> Excel I had to log in again to view the protected fields. I will need to
> read previous posts to learn more about log-ins as it is the first time I
> am using.
>
2a.

Company Description

Posted by: "juranek54" chad.juranek@gmail.com   juranek54

Mon Jun 18, 2012 5:31 pm (PDT)



For a couple of my reports I like having the company description. For some reason I can't find one that works. Is anyone else having problems with this?

2b.

Re: Company Description

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Mon Jun 18, 2012 6:11 pm (PDT)



I just use:

=RCHGetElementNumber("MMM",1)

However, you do need updates that occurred in May:

http://finance.groups.yahoo.com/group/smf_addin/message/18529

On Mon, Jun 18, 2012 at 5:31 PM, juranek54 <chad.juranek@gmail.com> wrote:

> For a couple of my reports I like having the company description. For some
> reason I can't find one that works. Is anyone else having problems with
> this?
>
3a.

magicformulainvesting.com

Posted by: "carmine288" carmine.nicoletta@gmail.com   carmine288

Mon Jun 18, 2012 6:59 pm (PDT)



Anyone noticed a change to this site? A SMF macro I had no longer works.

Thanks,
Carmine

3b.

Re: magicformulainvesting.com

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Mon Jun 18, 2012 7:10 pm (PDT)



It looks like they've made it so that it's a dynamically generated web page
with no bookmarkable URL (which the add-in needs).

However, you could use the "manual" technique discussed here:

http://finance.groups.yahoo.com/group/smf_addin/messages/18942?threaded=1&m=e&var=1&tidx=1

Basically, save a copy of the web page after you've done the screen, and
then use the add-in to extract the data from the saved copy of the web
page. Because it will have the necessary data within the source code of the
file.

On Mon, Jun 18, 2012 at 6:58 PM, carmine288 <carmine.nicoletta@gmail.com>wrote:

> Anyone noticed a change to this site? A SMF macro I had no longer works.
>
3c.

Re: magicformulainvesting.com

Posted by: "carmine288" carmine.nicoletta@gmail.com   carmine288

Mon Jun 18, 2012 8:26 pm (PDT)



Maybe I'm doung something wrong, but the screened data isn't get saved. Even when I tried to view the source, the data isn't there either.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> It looks like they've made it so that it's a dynamically generated web page
> with no bookmarkable URL (which the add-in needs).
>
> However, you could use the "manual" technique discussed here:
>
> http://finance.groups.yahoo.com/group/smf_addin/messages/18942?threaded=1&m=e&var=1&tidx=1
>
> Basically, save a copy of the web page after you've done the screen, and
> then use the add-in to extract the data from the saved copy of the web
> page. Because it will have the necessary data within the source code of the
> file.
>
> On Mon, Jun 18, 2012 at 6:58 PM, carmine288 <carmine.nicoletta@...>wrote:
>
> > Anyone noticed a change to this site? A SMF macro I had no longer works.
> >
>

3d.

Re: magicformulainvesting.com

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Mon Jun 18, 2012 8:46 pm (PDT)



I'm using FireFox. What are you using?

On Mon, Jun 18, 2012 at 8:25 PM, carmine288 <carmine.nicoletta@gmail.com>wrote:

> Maybe I'm doung something wrong, but the screened data isn't get saved.
> Even when I tried to view the source, the data isn't there either.
>
4a.

Re: GetWebData can't update data timely [1 Attachment]

Posted by: "bobc94595" conlonrc@comcast.net   bobc94595

Mon Jun 18, 2012 8:46 pm (PDT)



Randy, I need some help. All my spreadsheets, which worked perfectly last week with the latest Works-In-Progress listing (RCH_Stock_Market_Functions-2.1.2012.04.07.zip) , now return #NAME?
Even a new spreadsheet with only the formula , RCHGetElementNumber("Version") , gets that response.
When I open a sheet, and highlight a cell, the formula, for example, might be
'C:\Program Files\SMF Add-In\RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes(B16,"y")/100 but when I do a global search and replace (remove) of 'C:\Program Files\SMF Add-In\RCH_Stock_Market_Functions.xla'! I get the same result.
I try to refresh with F9, CNTL + SHIFT R, CNTL + ALT F9 , but they do nothing.
In the Internet, Browser Settings, where it says "Check for newer versions of stored pages:", I have toggled the "Every time I visit the web page" radio button.
For a forced recalculation, how do I get the name of the macro to be typed into the dropdown box mentioned in the messages for forced recalculation?
I am using a PC with Win7 and Office 2010 and Excel 2010

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Another possible reason data is not refreshing is that you have your
> Internet Options set up to cache web pages. Since EXCEL and the add-in use
> the same Internet access engine as IE, it also utilizes IE's cookies and
> "Temporary Internet Files" folder.
>
> To check/change your page caching settings for the "Temporary Internet
> Files" folder:
>
> 1. Click on your system's "Start" button.
> 2. Click on the "Control Panel" option.
> 3. Double-click on "Internet Options".
> 4. In the "Browser settings" section, click on the "Settings" button.
> 5. Under where it says "Check for newer versions of stored pages:", you
> want to toggle the "Every time I visit the web page" radio button. Without
> this, the add-in would just retrieve IE's stored copy of the web page
> instead of the Internet access engine getting a fresh copy of the web page
> from the Internet.
> 6. Click "OK" to save the settings and exit
> 7. Click "OK" to exit
> 8. Close the "Control Panel" window.
>
> Did you need to change your setting there?
>
> On Thu, Feb 17, 2011 at 3:09 PM, dehua liu <ldhljljq@...> wrote:
>
> >
> > I used the Macro and still can't the data updated. Please see the attached
> > file. For example, I requested to retrieve data for IWM at around 11am, so
> > the data after 11am can't be obtained even after Macro. On the other hand,
> > USO was just requested a moment ago, which returned a full day's data.
> >
> > Could you please give it a quick check?
> >
> > thanks,
> >
> > Dehua
> >
> >
> > --- On *Thu, 2/17/11, Randy Harmelink <rharmelink@...>* wrote:
> >
> >
> > From: Randy Harmelink <rharmelink@...>
> > Subject: Re: [smf_addin] GetWebData can't update data timely
> > To: smf_addin@yahoogroups.com
> > Date: Thursday, February 17, 2011, 3:48 PM
> >
> >
> > You need to run the smfForceRecalculation macro. See the "Links" area of
> > the group for more info.
> >
> > On Thu, Feb 17, 2011 at 1:18 PM, ldhljljq <ldhljljq@...<http://us.mc308.mail.yahoo.com/mc/compose?to=ldhljljq@...>
> > > wrote:
> >
> >
> > As you advised, I was able to use GetWebData to retrieve intraday data from
> > barcharts.com. However, it seems it can't get the most recent value and
> > the price simply stays where it was last time requested. It seems
> > GetTableCell has similiar situation. Is there something I could do wrong?
> > Does it have a command like now() as the one used in GetYahooquotes?
> >
> >
> >
> >
> > Attachment(s) from dehua liu
> >
> > 1 of 1 File(s)
> > Intraday data request example.xls<http://xa.yimg.com/kq/groups/18094620/1523907626/name/Intraday%20data%20request%20example%2Exls>
> >
> >
>

4b.

Re: GetWebData can't update data timely

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Mon Jun 18, 2012 8:54 pm (PDT)



If you're getting a #NAME? result, in a new worksheet, on:

=RCHGetElementNumber("Version")

...then you most probably don't have the add-in activated as an add-in.

F9 and Ctrl+Alt+F9 will not update extraction of data from web pages, only
those add-in functions that use CSV files. You need to use the
smfForceRecalculation macro (see the LINKS area of the group for more info).

On Mon, Jun 18, 2012 at 8:46 PM, bobc94595 <conlonrc@comcast.net> wrote:

> Randy, I need some help. All my spreadsheets, which worked perfectly last
> week with the latest Works-In-Progress listing
> (RCH_Stock_Market_Functions-2.1.2012.04.07.zip) , now return #NAME?
> Even a new spreadsheet with only the formula ,
> RCHGetElementNumber("Version") , gets that response.
> When I open a sheet, and highlight a cell, the formula, for example, might
> be
> 'C:\Program Files\SMF
> Add-In\RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes(B16,"y")/100 but
> when I do a global search and replace (remove) of 'C:\Program Files\SMF
> Add-In\RCH_Stock_Market_Functions.xla'! I get the same result.
> I try to refresh with F9, CNTL + SHIFT R, CNTL + ALT F9 , but they
> do nothing.
> In the Internet, Browser Settings, where it says "Check for newer versions
> of stored pages:", I have toggled the "Every time I visit the web page"
> radio button.
> For a forced recalculation, how do I get the name of the macro to be typed
> into the dropdown box mentioned in the messages for forced recalculation?
> I am using a PC with Win7 and Office 2010 and Excel 2010
>
5a.

Getting Chart data  to excel ( Reuters)

Posted by: "rmarshal78" rmarshal78@yahoo.com   rmarshal78

Mon Jun 18, 2012 11:39 pm (PDT)



Hi Randy,

I am looking for how to download the chart data i see on the webpage into the excel sheets.

Eg:
http://www.reuters.com/finance/stocks/chart?symbol=MSFT.OQ

How do i go about downloading the datapoints ?
Appreciate your guidance.
regards,
Marshal

5b.

Re: Getting Chart data to excel ( Reuters)

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Mon Jun 18, 2012 11:42 pm (PDT)



I'm not quite sure exactly what you're after, but you'd need to extract the
data from the frame. Not a trivial task:

http://charts.reuters.com/reuters/enhancements/US/interactiveChart/chart.asp?symbol=MSFT.OQ

On Mon, Jun 18, 2012 at 11:33 PM, rmarshal78 <rmarshal78@yahoo.com> wrote:

>
> I am looking for how to download the chart data i see on the webpage into
> the excel sheets.
>
> Eg:
> http://www.reuters.com/finance/stocks/chart?symbol=MSFT.OQ
>
> How do i go about downloading the datapoints ?
> Appreciate your guidance.
>
5c.

Re: Getting Chart data to excel ( Reuters)

Posted by: "Viju Joseph" josephviju@gmail.com   josephviju

Tue Jun 19, 2012 12:20 am (PDT)



Hi Randy,

Thnx for the quick response. How do i go about extracting data from the
frame. Can you guide plz ?

On Tue, Jun 19, 2012 at 12:12 PM, Randy Harmelink <rharmelink@gmail.com>wrote:

>
>
> I'm not quite sure exactly what you're after, but you'd need to extract
> the data from the frame. Not a trivial task:
>
>
> http://charts.reuters.com/reuters/enhancements/US/interactiveChart/chart.asp?symbol=MSFT.OQ
>
>
> On Mon, Jun 18, 2012 at 11:33 PM, rmarshal78 <rmarshal78@yahoo.com> wrote:
>
>>
>> I am looking for how to download the chart data i see on the webpage into
>> the excel sheets.
>>
>> Eg:
>> http://www.reuters.com/finance/stocks/chart?symbol=MSFT.OQ
>>
>> How do i go about downloading the datapoints ?
>> Appreciate your guidance.
>>
>
>
>
>

--
Viju Joseph
5d.

Re: Getting Chart data to excel ( Reuters)

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Tue Jun 19, 2012 12:23 am (PDT)



What data in particular are you trying to extract?

On Mon, Jun 18, 2012 at 11:45 PM, Viju Joseph <josephviju@gmail.com> wrote:

>
> How do i go about extracting data from the frame. Can you guide plz ?
>
> On Tue, Jun 19, 2012 at 12:12 PM, Randy Harmelink <rharmelink@gmail.com>wrote:
>
>>
>> I'm not quite sure exactly what you're after, but you'd need to extract
>> the data from the frame. Not a trivial task:
>>
>>
>> http://charts.reuters.com/reuters/enhancements/US/interactiveChart/chart.asp?symbol=MSFT.OQ
>>
>
6a.

addin question

Posted by: "mknu@juno.com" mknu@juno.com   markknutson2005

Tue Jun 19, 2012 12:00 am (PDT)



I use the following statement to bring a stock chart to my worksheets:
=RCHCreateComment(A2,1,420,620,1)
Is there an easy way to update the chart for the current date? I have 25 sheets for 25 stocks that I view each day. I currently update the chart by moving into the cell with the comment- not easy because the chart is in the way - and clicking into the formula bar and hitting enter. There has to be a better way. Is there a shortcut to do it? If not can anyone help me with a macro that would update the chart in the current sheet? I could place a button on the sheet if someone could help me with the macro. Thanks for providing and supporting this addin. Mark

__________________________________________________________
Fast, Secure, NetZero 4G Mobile Broadband. Try it.
http://www.netzero.net/?refcd=NZINTISP0512T4GOUT2

6b.

Re: addin question

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Tue Jun 19, 2012 12:22 am (PDT)



You need to run the smfForceRecalculation macro -- see the LINKS area of
the group for more info on it.

On Mon, Jun 18, 2012 at 11:58 PM, mknu@juno.com <mknu@juno.com> wrote:

> I use the following statement to bring a stock chart to my worksheets:
> =RCHCreateComment(A2,1,420,620,1)
> Is there an easy way to update the chart for the current date? I have 25
> sheets for 25 stocks that I view each day. I currently update the chart by
> moving into the cell with the comment- not easy because the chart is in the
> way - and clicking into the formula bar and hitting enter. There has to be
> a better way. Is there a shortcut to do it? If not can anyone help me with
> a macro that would update the chart in the current sheet? I could place a
> button on the sheet if someone could help me with the macro. Thanks for
> providing and supporting this addin.
>
7.

RCHGetYahooQuotes Array with Autofilter

Posted by: "back" backmehl@yahoo.de   backmehl

Tue Jun 19, 2012 12:03 am (PDT)



Hi Randy do you have any idea, how to use the RCHgetYahooQuotes-Array Formula with Autofilter.

Thanks & Regards

BM

Recent Activity
Visit Your Group
Search Ads

Get new customers.

List your web site

in Yahoo! Search.

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Yahoo! News

Get it all here

Breaking news to

entertainment news

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web

Tidak ada komentar:

Posting Komentar