12 New Messages
Digest #2620
Messages
Wed May 15, 2013 4:48 am (PDT) . Posted by:
"bagzigingahouse" bagzigingahouse
Thanks for helping Randy
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I had to look at the source code of the web page to see if I could find
> some HTML coding that was unique to the header of the table, or anything
> that would identify the table.
>
> I knew it would work, because I cycled through the tables and got it with
> this:
>
> =RCHGetHTMLTable("http://www.ivolatility.com/view_favourites.j?smid=.2.6.2
> ","",37,"",37)
>
> ...so it was the 37th table on the web page. Unfortunately, because simple
> web page changes can alter how many tables are on the web page, that would
> not be a reliable way to retrieve it. But I knew it was there and could be
> extracted.
>
> The smfGetCSVFile() function worked for me as soon as I logged in.
>
> PS: I used the smfGetTagContent-Quick-Webpage-Examination.xls template to
> explore a lot of things on the web page. For example, just going to the
> first tab and having it show all the table on the web page was a big help.
>
> On Wed, May 15, 2013 at 1:06 AM, bagzigingahouse
> <bagzigingahouse@...>wrote:
>
> > That is exactly it! I tried again but i'm not getting anything on the file
> > download. However, GetHTMLTable does the job!!! Im not sure how you made a
> > Symbol unique, but i guess i wont bother you now that its working :)
> >
>
--- In smf_addin@yahoogrou
>
> I had to look at the source code of the web page to see if I could find
> some HTML coding that was unique to the header of the table, or anything
> that would identify the table.
>
> I knew it would work, because I cycled through the tables and got it with
> this:
>
> =RCHGetHTMLTable(
> ","
>
> ...so it was the 37th table on the web page. Unfortunately, because simple
> web page changes can alter how many tables are on the web page, that would
> not be a reliable way to retrieve it. But I knew it was there and could be
> extracted.
>
> The smfGetCSVFile(
>
> PS: I used the smfGetTagContent-
> explore a lot of things on the web page. For example, just going to the
> first tab and having it show all the table on the web page was a big help.
>
> On Wed, May 15, 2013 at 1:06 AM, bagzigingahouse
> <bagzigingahouse
>
> > That is exactly it! I tried again but i'm not getting anything on the file
> > download. However, GetHTMLTable does the job!!! Im not sure how you made a
> > Symbol unique, but i guess i wont bother you now that its working :)
> >
>
Wed May 15, 2013 4:55 am (PDT) . Posted by:
"dan-carroll" dan-carroll
Jose,
Very much appreciated - that solves the final link. Using NYSE:IBM or NASDAQ:III worked. It's odd that some tickers work without it and some don't, but there you go.
Really appreciate your help, thanks!
--- In smf_addin@yahoogroups.com , Jacob Jose <pepecan47@...> wrote:
>
> I am from Canada, it works for me, so my situation should be similar as yours. To get data for MCD, I have to enter NYSE:MCD as a ticker.
>
>
> Regards,
> Jose L. Jacob
>
>
> ________________________________
> From: dan-carroll <dan-carroll@...>
> To: smf_addin@yahoogroups.com
> Sent: Tuesday, May 14, 2013 2:10:00 PM
> Subject: [smf_addin] Re: Error getting any data from AdvFN - SOLVED AGAIN!
>
> Â
> So, your workaround works, of course - but the ticker I was using generates faults with AdvFN UK that it doesn't in the US.
>
> I had been using the tickers III and IBM to test my spreadsheet. For some reason, those tickers don't work here with AdvFN, though they do in the US. With other tickers, like MMM, MSFT etc etc, the sheet works (note to self before wasting your time in future).
>
> I can understand why the ticker III might not work - in the UK AdvFN website the query defaults to a different UK listed company with the same ticker. IBM I have no clue what the issue is. I tried a bunch of other tickers and in general, everything works except for a few microcaps.
>
> One last question - back in the States, should I delete the new text file or just edit it to say "www" instead of "uk"?
>
> My apologies and thanks again for your help.
>
> --- In mailto:smf_addin%40yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> >
> > Are you using the same computer? If not, you may need to apply the fix from
> > the LINKS area of the group.
> >
> > Have you verified you get redirected?
> >
> > On Tue, May 14, 2013 at 5:16 AM, dan-carroll <dan-carroll@> wrote:
> >
> > >
> > > I hate to go over this (since you've done it twice here) but I'm traveling
> > > in the UK and have just come across this issue.
> > >
> > > I created the smf-AdvFN-Prefix.txt file that you suggest, with "uk" as the
> > > only entry, restarted Excel, but it didn't work - just got "Error".
> > > I updated to the very latest version of the Add-in (the works-in-progress
> > > folder) and restarted - still no luck
> > > Tried SMFForceRecalculation macro - nothing
> > >
> > > Everything was fine when I was in the US yesterday.
> > >
> > > Is there anything else you could suggest I try?
> > >
> > > I am using Windows 7 with Office 2007
> > >
> > > And of course - thank you for all of your work, and for a most amazingly
> > > useful tool!
> > >
> >
>
Very much appreciated - that solves the final link. Using NYSE:IBM or NASDAQ:III worked. It's odd that some tickers work without it and some don't, but there you go.
Really appreciate your help, thanks!
--- In smf_addin@yahoogrou
>
> I am from Canada, it works for me, so my situation should be similar as yours. To get data for MCD, I have to enter NYSE:MCD as a ticker.
>
>
> Regards,
> Jose L. Jacob
>
>
> ____________
> From: dan-carroll <dan-carroll@
> To: smf_addin@yahoogrou
> Sent: Tuesday, May 14, 2013 2:10:00 PM
> Subject: [smf_addin] Re: Error getting any data from AdvFN - SOLVED AGAIN!
>
> Â
> So, your workaround works, of course - but the ticker I was using generates faults with AdvFN UK that it doesn't in the US.
>
> I had been using the tickers III and IBM to test my spreadsheet. For some reason, those tickers don't work here with AdvFN, though they do in the US. With other tickers, like MMM, MSFT etc etc, the sheet works (note to self before wasting your time in future).
>
> I can understand why the ticker III might not work - in the UK AdvFN website the query defaults to a different UK listed company with the same ticker. IBM I have no clue what the issue is. I tried a bunch of other tickers and in general, everything works except for a few microcaps.
>
> One last question - back in the States, should I delete the new text file or just edit it to say "www" instead of "uk"
>
> My apologies and thanks again for your help.
>
> --- In mailto:smf_addin%
> >
> > Are you using the same computer? If not, you may need to apply the fix from
> > the LINKS area of the group.
> >
> > Have you verified you get redirected?
> >
> > On Tue, May 14, 2013 at 5:16 AM, dan-carroll <dan-carroll@
> >
> > >
> > > I hate to go over this (since you've done it twice here) but I'm traveling
> > > in the UK and have just come across this issue.
> > >
> > > I created the smf-AdvFN-Prefix.
> > > only entry, restarted Excel, but it didn't work - just got "Error"
> > > I updated to the very latest version of the Add-in (the works-in-progress
> > > folder) and restarted - still no luck
> > > Tried SMFForceRecalculati
> > >
> > > Everything was fine when I was in the US yesterday.
> > >
> > > Is there anything else you could suggest I try?
> > >
> > > I am using Windows 7 with Office 2007
> > >
> > > And of course - thank you for all of your work, and for a most amazingly
> > > useful tool!
> > >
> >
>
Wed May 15, 2013 5:01 am (PDT) . Posted by:
"dan-carroll" dan-carroll
Randy,
Thanks so much again! Your comments (and Jose's pointer) solved everything. Using NYSE:IBM or NASDAQ:III worked. It's odd that some tickers work without the prefix (MMM MSFT) and some don't, but there you go.
As always, I really appreciate your help and your time, thanks! Is there a tip jar or a favorite charity of yours I could contribute a couple of dollars to?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> IBM won't work on the "uk" site, since it would default to the London Stock
> Exchange, which has no financial statements data posted on. That is,
> LSE:IBM and NYSE:IBM are different.
>
> Just edit the file and remove the prefix when you get back to the states.
>
> On Tue, May 14, 2013 at 11:10 AM, dan-carroll <dan-carroll@...> wrote:
>
> > So, your workaround works, of course - but the ticker I was using
> > generates faults with AdvFN UK that it doesn't in the US.
> >
> > I had been using the tickers III and IBM to test my spreadsheet. For some
> > reason, those tickers don't work here with AdvFN, though they do in the US.
> > With other tickers, like MMM, MSFT etc etc, the sheet works (note to self
> > before wasting your time in future).
> >
> > I can understand why the ticker III might not work - in the UK AdvFN
> > website the query defaults to a different UK listed company with the same
> > ticker. IBM I have no clue what the issue is. I tried a bunch of other
> > tickers and in general, everything works except for a few microcaps.
> >
> > One last question - back in the States, should I delete the new text file
> > or just edit it to say "www" instead of "uk"?
> >
>
Thanks so much again! Your comments (and Jose's pointer) solved everything. Using NYSE:IBM or NASDAQ:III worked. It's odd that some tickers work without the prefix (MMM MSFT) and some don't, but there you go.
As always, I really appreciate your help and your time, thanks! Is there a tip jar or a favorite charity of yours I could contribute a couple of dollars to?
--- In smf_addin@yahoogrou
>
> IBM won't work on the "uk" site, since it would default to the London Stock
> Exchange, which has no financial statements data posted on. That is,
> LSE:IBM and NYSE:IBM are different.
>
> Just edit the file and remove the prefix when you get back to the states.
>
> On Tue, May 14, 2013 at 11:10 AM, dan-carroll <dan-carroll@
>
> > So, your workaround works, of course - but the ticker I was using
> > generates faults with AdvFN UK that it doesn't in the US.
> >
> > I had been using the tickers III and IBM to test my spreadsheet. For some
> > reason, those tickers don't work here with AdvFN, though they do in the US.
> > With other tickers, like MMM, MSFT etc etc, the sheet works (note to self
> > before wasting your time in future).
> >
> > I can understand why the ticker III might not work - in the UK AdvFN
> > website the query defaults to a different UK listed company with the same
> > ticker. IBM I have no clue what the issue is. I tried a bunch of other
> > tickers and in general, everything works except for a few microcaps.
> >
> > One last question - back in the States, should I delete the new text file
> > or just edit it to say "www" instead of "uk"
> >
>
Wed May 15, 2013 7:51 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Thanks for the offer. I ask people to "Pay it Forward" and give the
donation to a worthy charity. Then you get a tax deduction out of it as
well. :)
On Wed, May 15, 2013 at 5:01 AM, dan-carroll <dan-carroll@yahoo.com > wrote:
>
> As always, I really appreciate your help and your time, thanks! Is there a
> tip jar or a favorite charity of yours I could contribute a couple of
> dollars to?
>
donation to a worthy charity. Then you get a tax deduction out of it as
well. :)
On Wed, May 15, 2013 at 5:01 AM, dan-carroll <dan-carroll@
>
> As always, I really appreciate your help and your time, thanks! Is there a
> tip jar or a favorite charity of yours I could contribute a couple of
> dollars to?
>
Wed May 15, 2013 9:14 am (PDT) . Posted by:
"crollalanzaws" crollalanzaws
Hello,
I can't seem to figure out how to retrieve the rate from
this site: http://www.ingdirect.ca/en/save-invest/savingsaccounts/index.html
Investment Savings Account (ISA) 1.35%
I've tried both rchgetwebdata and rchgettablecell.
Thank you.
I can't seem to figure out how to retrieve the rate from
this site: http://www.ingdirec
Investment Savings Account (ISA) 1.35%
I've tried both rchgetwebdata and rchgettablecell.
Thank you.
Wed May 15, 2013 9:37 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
You can't grab it because it's not on the web page. They appear to be
loading it dynamically from this web page:
http://www.ingdirect.ca/en/datafiles/rates/isacad.html
Try:
=smfConvertData(RCHGetWebData("
http://www.ingdirect.ca/en/datafiles/rates/isacad.html "))
On Wed, May 15, 2013 at 9:14 AM, crollalanzaws <florio.crollalanza@yahoo.com
> wrote:
>
> I can't seem to figure out how to retrieve the rate from
> this site:
> http://www.ingdirect.ca/en/save-invest/savingsaccounts/index.html
>
> Investment Savings Account (ISA) 1.35%
>
> I've tried both rchgetwebdata and rchgettablecell.
>
loading it dynamically from this web page:
http://www.ingdirec
Try:
=smfConvertData(
http://www.ingdirec
On Wed, May 15, 2013 at 9:14 AM, crollalanzaws <florio.crollalanza@
> wrote:
>
> I can't seem to figure out how to retrieve the rate from
> this site:
> http://www.ingdirec
>
> Investment Savings Account (ISA) 1.35%
>
> I've tried both rchgetwebdata and rchgettablecell.
>
Wed May 15, 2013 10:16 am (PDT) . Posted by:
"crollalanzaws" crollalanzaws
thank you, it worked. I understand now.
Wed May 15, 2013 11:37 am (PDT) . Posted by:
"James" jsauer11
I used this formula in a cell and it pulled in the price but now it does not update it still has prive from 5/10 - Why am I not getting current price? =RCHGetElementNumber(C3,25)
Wed May 15, 2013 11:39 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
You need to use the smfForceRecalculation macro to update most of the
add-in functions. See the related entries in the LINKS area of the group
for more information.
Also, you should use RCHGetYahooQuotes() to get quotes data. Especially,
since the "Last Price" on MSN has been the previous day's closing price
ever since MSN revamped their stock print page last year.
On Wed, May 15, 2013 at 10:12 AM, James <jsauer11@yahoo.com > wrote:
> I used this formula in a cell and it pulled in the price but now it does
> not update it still has prive from 5/10 - Why am I not getting current
> price? =RCHGetElementNumber(C3,25)
>
add-in functions. See the related entries in the LINKS area of the group
for more information.
Also, you should use RCHGetYahooQuotes(
since the "Last Price" on MSN has been the previous day's closing price
ever since MSN revamped their stock print page last year.
On Wed, May 15, 2013 at 10:12 AM, James <jsauer11@yahoo.
> I used this formula in a cell and it pulled in the price but now it does
> not update it still has prive from 5/10 - Why am I not getting current
> price? =RCHGetElementNumbe
>
Wed May 15, 2013 11:39 pm (PDT) . Posted by:
"sri yanto" sri.yanto
thx alot randy
now I go to groups :D, sorry before
for particular stock it works, but for other stock like PGAS.JK
it's have a problem.
thanks alot
________________________________
From: Randy Harmelink <rharmelink@gmail.com >
To: sri yanto <sri.yanto@yahoo.com >
Sent: Thursday, May 16, 2013 12:40 PM
Subject: Re: Need Help Randy - Reuters Error Notification
I couldn't retrieve data from the web page until I logged in to Reuters using the EXCEL Web Query Dialog. Also, you are creating the URL incorrectly. Take a look at what your concatenations are creating.
PS: You need to send add-in questions to the Yahoo group. I have email filters that direct them to a folder. I found this message in my SPAM folder, which means it could easily have deleted without me ever seeing it.
On Wed, May 15, 2013 at 10:08 PM, sri yanto <sri.yanto@yahoo.com > wrote:
hallo randy
>
>
>here i had edited your SMF addin Rasio for ratio from reuters
>
>
>i find some error in formula when i using Rchgettable function in sheet 2.
>i can't extract reveneu or EPS or operating..
>
>
>all displayed "error"
>at first time i tried, it cant show the value, then in second tried it's all error
>
>
>can you help me - what mistake of my formula.
>actually i only want to get revenue value.
>
>
>in sheet 2 the formula error contain.
>
>
>thank you very much randy
now I go to groups :D, sorry before
for particular stock it works, but for other stock like PGAS.JK
it's have a problem.
thanks alot
____________
From: Randy Harmelink <rharmelink@gmail.
To: sri yanto <sri.yanto@yahoo.
Sent: Thursday, May 16, 2013 12:40 PM
Subject: Re: Need Help Randy - Reuters Error Notification
I couldn't retrieve data from the web page until I logged in to Reuters using the EXCEL Web Query Dialog. Also, you are creating the URL incorrectly. Take a look at what your concatenations are creating.
PS: You need to send add-in questions to the Yahoo group. I have email filters that direct them to a folder. I found this message in my SPAM folder, which means it could easily have deleted without me ever seeing it.
On Wed, May 15, 2013 at 10:08 PM, sri yanto <sri.yanto@yahoo.
hallo randy
>
>
>here i had edited your SMF addin Rasio for ratio from reuters
>
>
>i find some error in formula when i using Rchgettable function in sheet 2.
>i can't extract reveneu or EPS or operating..
>
>
>all displayed "error"
>at first time i tried, it cant show the value, then in second tried it's all error
>
>
>can you help me - what mistake of my formula.
>actually i only want to get revenue value.
>
>
>in sheet 2 the formula error contain.
>
>
>thank you very much randy
Wed May 15, 2013 11:43 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
PGAS.JK works here.
Did you try it first BEFORE you logged in? If so, you'll need to run
smfForceRecalculation (see LINKS area of group for more info) to force the
add-in to retrieve the web page again. Otherwise, you're still trying to
extract data from the web page retrieved before you logged in.
On Wed, May 15, 2013 at 11:23 PM, sri yanto <sri.yanto@yahoo.com > wrote:
> for particular stock it works, but for other stock like PGAS.JK
> it's have a problem.
>
>
Did you try it first BEFORE you logged in? If so, you'll need to run
smfForceRecalculati
add-in to retrieve the web page again. Otherwise, you're still trying to
extract data from the web page retrieved before you logged in.
On Wed, May 15, 2013 at 11:23 PM, sri yanto <sri.yanto@yahoo.
> for particular stock it works, but for other stock like PGAS.JK
> it's have a problem.
>
>
Thu May 16, 2013 12:47 am (PDT) . Posted by:
"sri yanto" sri.yanto
hmm randy, i'd logged in before i run the addin
okey randy i'll try smfforcecalculation first..thx before randy
____________
From: Randy Harmelink <rharmelink@gmail.
To: smf_addin@yahoogrou
Sent: Thursday, May 16, 2013 1:43 PM
Subject: Re: [smf_addin] Re: Need Help Randy - Reuters Error Notification
PGAS.JK works here.
Did you try it first BEFORE you logged in? If so, you'll need to run smfForceRecalculati
On Wed, May 15, 2013 at 11:23 PM, sri yanto <sri.yanto@yahoo.
for particular stock it works, but for other stock like PGAS.JK
>it's have a problem.
>
Tidak ada komentar:
Posting Komentar