Rabu, 10 Agustus 2011

[smf_addin] Digest Number 1915[1 Attachment]

Messages In This Digest (14 Messages)

Messages

1a.

Re: Future of SMF-Add In

Posted by: "GaryFera" gfera@shaw.ca   GaryFera

Tue Aug 9, 2011 7:41 am (PDT)



Randy, thank you from hundreds of us who use your add in every single day.

Gary

--- In smf_addin@yahoogroups.com, Charles Backus <cbackus@...> wrote:
>
> Hey Randy,
> Think I just need to say thank you!
>
> Charlie
>
> On Aug 8, 2011, at 8:48 PM, Randy Harmelink <rharmelink@...> wrote:
>
> > Since the code is open source, I would think my plans are more or less irrelevant.
> >
> > However, I have never had plans to charge for it, and I don't see that changing -- EVER. Money is not an issue (even with the market declines). The most likely scenario is that I simply shut down the group, either because I get tired of supporting it or am unable to because of health problems. For example, my kidneys failed in 2007, and I've been in the hospital four times in the last year because of foot injuries and infections (complicated by diabetes). Not to mention a recent bout with Shingles and Bell's Palsy.
> >
> > In fact, I've had people offer donations in the past. My response has always been, and will continue to be -- give the donations to a worthy charity. That is, "Pay It Forward"...
> >
> >
> > On Mon, Aug 8, 2011 at 7:20 PM, Michael Thomas <thomas91112@...> wrote:
> >
> > Randy,
> >
> > You are developing a good add-in service of which many people are becoming dependent for their investment needs. What are your plans for this add-in? Are you going to continue offering it for free or will you be converting to a pay for service add-in? We the users should all be aware of your plans so we don't devote massive amounts of time and effort into setting up and becoming dependent upon your add-in interface only to find we suddenly need to begin paying at rates that we may be unable to accommodate.
> >
> > We will all greatly appreciate your candor on this topic; as it is your product is terrific and much needed.
> >
> > Thanks for all your work.
> >
> > Mike T.
> >
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
2a.

Re: Yahoo "high" quotes not working?

Posted by: "smortonm" smmarder@yahoo.com   smortonm

Tue Aug 9, 2011 10:13 am (PDT)



I did that and here is the answer I received copied below. I am using
IE and Firefox, so that is not the problem. If others are still having
the problem, as I am, you may also want to let YAHOO! know, so they work
on it
Thanks
Sid

Hello Sid,

Thank you for writing to Yahoo! Finance.

I understand you're seeing incorrect or inconsistent data when
downloading quotes to a CSV file from Yahoo! Finance. I appreciate you
taking the time to report this issue and I apologize for any
inconvenience caused.

Our engineering team is currently working to correct this, and our goal
is to

Additionally, the information we gathered in your email indicates your
system configuration is not fully supported by Yahoo! Finance. Please
know that most features of Yahoo! Finance will work on all A-grade
browsers, we only officially support and test on Internet Explorer and
Firefox.
--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...>
wrote:
>
> At the bottom of the page when looking at the quotes page of a stock,
you'll
> find a "Report problems" link.
>
> On Sat, Aug 6, 2011 at 8:58 AM, swoodbri woodbri@... wrote:
>
> >
> > Does any one know if there is a support list/email for
> > download.finance.yahoo.com? It is very frustrating when you can not
rely
> > on any of your tools as return valid results! <sigh>
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (14)
3a.

Re: Google Finance data retrieval still not working

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

Tue Aug 9, 2011 11:13 am (PDT)



I am having a similar issue as well. To resolve the issue, I went down to Work-In-Progress folder and downloaded the beta version of SMF. It helped in preventing the opening a new window of IE but still gives a 'Error' in the cell.

I have been using this file for a while on XP. The only thing changed is that i upgraded IE to version 8. Could that be the case?

Thanks

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> What is the date on your smf-elements-3.txt file? I think at one point, it
> was actually using the IE object because of changes Google had made. So if
> you have an old copy of that file, that may be the culprit?
>
> There is a new version of that file in the "Works in Progress" folder that
> was updated earlier this year. You could try:
>
> 1. Exit EXCEL
> 2. Replace that file with the new one
> 3. Restart EXCEL
>
> ...and see if the symptoms go away?
>
> On Sat, Aug 6, 2011 at 12:58 PM, cherry77tree <
> david.nincic.wg99@...> wrote:
>
> > I am having the exact same problem as Adam. I am using Excel 2010 and
> > Windows 7. What happens is when I update an RCHGetElementNumber formula
> > linking to Google Finance, Internet Explorer windows begin opening up
> > and only "Error" is returned in the Excel cells. One IE window opens up
> > per ticker symbol.
> >
> > The IE windows have the same following URL (with the only difference
> > being the ticker) and have no content:
> > about:blank#http://finance.google.com/finance?fstype=ii&q=IBM
> >
> > I find Google Finance to have the highest data integrity of all the web
> > data sources, so it would be a pity to lose access to it.
> >
> > Does anyone have a clue to what is going on?
> > If Google Finance data retrievals work for you, what Excel and Windows
> > versions are you using?
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (10)
3b.

Re: Google Finance data retrieval still not working

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

Tue Aug 9, 2011 11:34 am (PDT)



Can you give me a specific example of a function that gives you "Error"?

On Tue, Aug 9, 2011 at 9:11 AM, traderdon09 <traderdon09@yahoo.com> wrote:

> I am having a similar issue as well. To resolve the issue, I went down to
> Work-In-Progress folder and downloaded the beta version of SMF. It helped in
> preventing the opening a new window of IE but still gives a 'Error' in the
> cell.
>
> I have been using this file for a while on XP. The only thing changed is
> that i upgraded IE to version 8. Could that be the case?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (10)
4a.

ADVFN Toplist Table Retrieval

Posted by: "mutantcar" huw.a.williams@googlemail.com   mutantcar

Tue Aug 9, 2011 11:16 am (PDT)



Hi,

First of all, I can't thank Randy enough for sharing his amazing work. At least, I'm sure it'll be amazing if I can get it working!

I'm trying initially to retrieve a 'Toplist' table from ADVFN. For example The LSE Percentage Gainers using the array formula:

=RCHGetHTMLTable("http://www.advfn.com/p.php?pid=toplist&m=L&tl=1&symbol=VOD","Turn On MoverScope",1,"",1)

I'm just getting blank cells. I've tried the sample file that retrieves option data from Yahoo. Works fine.

Also, I'm assuming the Live java updating tables on ADVFN aren't able to be retrieved using smf_addin?

Thanks in Advance,

Huw.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)
4b.

Re: ADVFN Toplist Table Retrieval

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

Tue Aug 9, 2011 11:41 am (PDT)



I get blanks until I log in to AdvFN using the EXCEL Web Query dialog and
then use the smfForceRecalculation macro to get a fresh copy of the web
page.

And you are correct in assuming that the add-in can't grab data from a Java
application. It pulls data from the source code of the web pages.

On Tue, Aug 9, 2011 at 8:48 AM, mutantcar <huw.a.williams@googlemail.com>wrote:

>
> First of all, I can't thank Randy enough for sharing his amazing work. At
> least, I'm sure it'll be amazing if I can get it working!
>
> I'm trying initially to retrieve a 'Toplist' table from ADVFN. For example
> The LSE Percentage Gainers using the array formula:
>
> =RCHGetHTMLTable("
> http://www.advfn.com/p.php?pid=toplist&m=L&tl=1&symbol=VOD","Turn On
> MoverScope",1,"",1)
>
> I'm just getting blank cells. I've tried the sample file that retrieves
> option data from Yahoo. Works fine.
>
> Also, I'm assuming the Live java updating tables on ADVFN aren't able to be
> retrieved using smf_addin?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)
4c.

Re: ADVFN Toplist Table Retrieval

Posted by: "dguillett1" dguillett1@gmail.com   donaldb36

Tue Aug 9, 2011 12:03 pm (PDT)



I use this in an external query. Don't know if it will be of any help here.
With ss.QueryTables(1)
.Connection = _
"URL;http://www.advfn.com/p.php?pid=financials&btn=s_ok&mode=&symbol=" & symbol & "&s_ok=OK"

From: Randy Harmelink
Sent: Tuesday, August 09, 2011 1:36 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] ADVFN Toplist Table Retrieval

I get blanks until I log in to AdvFN using the EXCEL Web Query dialog and then use the smfForceRecalculation macro to get a fresh copy of the web page.

And you are correct in assuming that the add-in can't grab data from a Java application. It pulls data from the source code of the web pages.

On Tue, Aug 9, 2011 at 8:48 AM, mutantcar <huw.a.williams@googlemail.com> wrote:

First of all, I can't thank Randy enough for sharing his amazing work. At least, I'm sure it'll be amazing if I can get it working!

I'm trying initially to retrieve a 'Toplist' table from ADVFN. For example The LSE Percentage Gainers using the array formula:

=RCHGetHTMLTable("http://www.advfn.com/p.php?pid=toplist&m=L&tl=1&symbol=VOD","Turn On MoverScope",1,"",1)

I'm just getting blank cells. I've tried the sample file that retrieves option data from Yahoo. Works fine.

Also, I'm assuming the Live java updating tables on ADVFN aren't able to be retrieved using smf_addin?

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)
4d.

Re: ADVFN Toplist Table Retrieval

Posted by: "mutantcar" mutant.car@virgin.net   mutantcar

Tue Aug 9, 2011 12:06 pm (PDT)



Hi Randy,

Thanks for the quick reply.

I must have missed something, I was already logged in to ADVFN, but I've closed it down & reopened the spreadsheet to try. I don't get a Web Query dialog & not asked to log in.

I've just set up a Web Query to get the table, that works, but I'm then not using smf_addin?

I'm confused! Are you saying to use Web queries, and not smf_addin for this?

Regards,

Huw.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I get blanks until I log in to AdvFN using the EXCEL Web Query dialog and
> then use the smfForceRecalculation macro to get a fresh copy of the web
> page.
>
> And you are correct in assuming that the add-in can't grab data from a Java
> application. It pulls data from the source code of the web pages.
>
> On Tue, Aug 9, 2011 at 8:48 AM, mutantcar <huw.a.williams@...>wrote:
>
> >
> > First of all, I can't thank Randy enough for sharing his amazing work. At
> > least, I'm sure it'll be amazing if I can get it working!
> >
> > I'm trying initially to retrieve a 'Toplist' table from ADVFN. For example
> > The LSE Percentage Gainers using the array formula:
> >
> > =RCHGetHTMLTable("
> > http://www.advfn.com/p.php?pid=toplist&m=L&tl=1&symbol=VOD","Turn On
> > MoverScope",1,"",1)
> >
> > I'm just getting blank cells. I've tried the sample file that retrieves
> > option data from Yahoo. Works fine.
> >
> > Also, I'm assuming the Live java updating tables on ADVFN aren't able to be
> > retrieved using smf_addin?
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)
4e.

Re: ADVFN Toplist Table Retrieval

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

Tue Aug 9, 2011 1:19 pm (PDT)



You don't need to RUN a Web Query. I just wanted you to use the Web Query
dialog to log in -- then you can "Cancel" out.

However, if you could get the table with the Web Query, the add-in function
should be working. Did you try it again after closing down EXCEL and
restarting it?

If it still doesn't work, try using the smfForceRecalculation to get a fresh
copy of the web page. It could be the first one was retrieved before you
logged in.

On Tue, Aug 9, 2011 at 12:06 PM, mutantcar <mutant.car@virgin.net> wrote:

>
> I must have missed something, I was already logged in to ADVFN, but I've
> closed it down & reopened the spreadsheet to try. I don't get a Web Query
> dialog & not asked to log in.
>
> I've just set up a Web Query to get the table, that works, but I'm then not
> using smf_addin?
>
> I'm confused! Are you saying to use Web queries, and not smf_addin for
> this?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)
4f.

Re: ADVFN Toplist Table Retrieval

Posted by: "mutantcar" mutant.car@virgin.net   mutantcar

Tue Aug 9, 2011 1:56 pm (PDT)



Oh, I see.

Yes, I tried after closing & reopening Excel. Still didn't work. Web query was fine though. Got me thinking why don't I use those! I guess the functions are more flexible, build them into formulas etc. Easier than VBA?

I'm new to smf_Addin, so haven't found out how to use smfForceRelculation yet. I think I've found it in the FAQ now, but it's near my bedtime, so I'll let you know how I get on when I get some time.

Thanks again.

Huw

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)
4g.

Re: ADVFN Toplist Table Retrieval

Posted by: "mutantcar" mutant.car@virgin.net   mutantcar

Tue Aug 9, 2011 2:18 pm (PDT)



Decided not to go to bed yet!

I tried smfForceRecalc. No joy, stepping through the code I could see I seemed to be getting a login prompt, despite being logged into ADVFN in my Browser (Chrome?).

I tried another Web query, different table though. I got a different login prompt this time, a 'Windows' network type dialog, rather than the ADVFN browser login I got last time (within the web query window). I entered my id & pword into the Windowsy login & it worked. Brilliant!

Thanks again Randy, great to have the code as well.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)
4h.

Re: ADVFN Toplist Table Retrieval

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

Tue Aug 9, 2011 2:23 pm (PDT)



Logging in with a different browser won't do the job. That's because the
add-in (and EXCEL Web Queries) uses the Microsoft Internet engine -- the
same one that IE uses. You need an IE security cookie in order for the
Microsoft Internet engine to be able to access the data if it's within a
secured area of the website.

I actually wrote the first add-in functions because of frustrations I ran
into using EXCEL Web Queries. They probably work much more reliably these
days. :)

On Tue, Aug 9, 2011 at 2:18 PM, mutantcar <mutant.car@virgin.net> wrote:

> Decided not to go to bed yet!
>
> I tried smfForceRecalc. No joy, stepping through the code I could see I
> seemed to be getting a login prompt, despite being logged into ADVFN in my
> Browser (Chrome?).
>
> I tried another Web query, different table though. I got a different login
> prompt this time, a 'Windows' network type dialog, rather than the ADVFN
> browser login I got last time (within the web query window). I entered my
> id & pword into the Windowsy login & it worked. Brilliant!
>
> Thanks again Randy, great to have the code as well.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)
5a.

Re: SMF for Dummy's?

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

Tue Aug 9, 2011 12:42 pm (PDT)



Shortly after posting my question I found the links section of the forum and the answer to my question. I guess that is how it always works out. Thanks for your quick response and willingness to help!

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> At what point of the instructions are you running into problems?
>
> On Mon, Aug 8, 2011 at 1:18 PM, thtabe <thtabe@...> wrote:
>
> >
> > I have been stalking the forum for a while now and have tried on several
> > occasions to down load and set up the SMF addin unsuccessfully. I was
> > wondering is there a SMF Addin for dummy's post or file I can't find? Any
> > help would be greatly appreciated.
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
6a.

Re: Added routine smfUpdateDownloadTableCurRow [1 Attachment]

Posted by: "Rob Oppenheim" oppenheim@email.com   rob_oppie

Tue Aug 9, 2011 1:53 pm (PDT)

[Attachment(s) from Rob Oppenheim included below]

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:

>
> The next logical step would be to update highlighted rows... :)
>

OK. Here it is.

This version updates all rows in current selection (if any part of a
row is selected then the full row is updated).

It does all selected rows but it will stop if a blank symbol is found.

It works with selections of non-contiguous areas (ctrl-click selections).
A blank symbol will stop it only for that area (it will continue with
the next non-contiguous area in the selection).

This version also more accurately updates the status line.

---

If you are using version: 2.1.2011.04.03, and you want to use this mod,
then ...

Select all of the text in the attached modDownloadTable2.txt
In Excel goto the Developer tab and click on Visual Basic.
in the box on the left under the "RCH_Stock_Market_Functions", double
click on "modDownloadTable".
Then select all the text in the module (Ctrl-A) and paste in the new
text from modDownloadTable2.txt.

---

How to add buttons to your spreadsheet to call these routines...

Create a button in Excel (Developer/Insert/Form Controls: button).
Edit the button text to be something like "Reload All Quote Data",
Right click the button and "Assign Macro...", click NEW (or edit),
non-contiguous area selections
then in the ButtonX_Click() macro body add the line:
Application.Run "smfUpdateDownloadTable"
(see example below).

Add another button labeled "Load Selected Rows",
then in its ButtonX_Click() macro body add the line:
Application.Run "smfUpdateDownloadTableCurRow"

Examples:

Sub Button1_Click()
Application.Run "smfUpdateDownloadTable"
End Sub

Sub Button2_Click()
Application.Run "smfUpdateDownloadTableCurRow"
End Sub

It is OK by me if this code is added to the distribution.

-Rob

Attachment(s) from Rob Oppenheim

1 of 1 File(s)

modDownloadTable2.txt
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
Recent Activity
Visit Your Group
Yahoo! News

Fashion News

What's the word on

fashion and style?

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Search Ads

Get new customers.

List your web site

in Yahoo! Search.

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
Diposting oleh EXCEL FEED LEARNING di 04.14

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)