11 New Messages
Digest #2461
Messages
Mon Jan 7, 2013 9:29 am (PST) . Posted by:
"kim54blake" kim54blake
Thanks Very Much Randy, I have been struggling with this problem the last few evenings in setting up my pool for the upcoming year.
The website changes had me looking at other sources in trying to resolve, and was looking at copying and pasting.....
You absolutely amaze me with the speed and efficiency you solve problems!
I hope you are taking care of yourself and all the best in the new year
Thanks again
--- In smf_addin@yahoogrou
>
> With that type of data, I would do a cascading extraction. For example:
>
> C4: 1
> D4: =RCHGetWebData(
> ",C4,1000)
> B5: =FIND("
> C5: =C4+B5
> D5: =RCHGetWebData(
> ",C5,500)
>
> Then copy B5:D5 down as needed. At that point, the start of the values in
> D5 and downward contain all of the data for each of the players. Then just
> extract each item you need with smfStrExtr()
> name from D5:
>
> =smfstrExtr(
>
> On Sun, Jan 6, 2013 at 11:53 AM, Paul mcglinchey <
> pajmcglinchey@
>
> >
> > Would you possibly be able to help me with the current url. PGAtour.com
> > have updated their website and the old links no longer work. Last years
> > money list is at
> > http://www.pgatour.
> > sniffer you suggested i found that
> > http://www.pgatour.
> > data i need but dont know how to get it into excel. I cant see any html
> > page from the sniffer.
> >
> > I have tried using the addin and RCHGetHTMLTable on the standard site
> > using the table name but all it gets is the header of the table
> >
>
Mon Jan 7, 2013 9:54 am (PST) . Posted by:
"Pete A" option2z
Thanks Randy. That works for finding the earliest data date available, in a formula. I didn't make it clear that I also need the latest date available. Some stocks have stopped trading, or changed tickers, so when there is a "latest date" earlier than today, more research is merited. I'll convert the formula for earliest date into vba. Thanks! Pete A
--- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
>
> See: http://finance.groups.yahoo.com/group/smf_addin/message/14544
>
> On Sun, Jan 6, 2013 at 5:45 PM, Pete A wrote:
>
> >
> > I run some code that depends on there being a specified range of data (way
> > BMS for 1/1/2003 - 1/1/2008). Programmatically, what's the fastest,
> > easiest way to find BMS's earliest and latest YAHOO History available dates?
> >
>
--- In smf_addin@yahoogrou
>
> See: http://finance.
>
> On Sun, Jan 6, 2013 at 5:45 PM, Pete A wrote:
>
> >
> > I run some code that depends on there being a specified range of data (way
> > BMS for 1/1/2003 - 1/1/2008). Programmatically, what's the fastest,
> > easiest way to find BMS's earliest and latest YAHOO History available dates?
> >
>
Mon Jan 7, 2013 10:05 am (PST) . Posted by:
"Randy Harmelink" rharmelink
For the latest trading date of history, this should work in VBA:
RCHGetYahooHistory("MMM",,,,,,,,"D",0,,,1,1)(1,1)
But right now, that will get you a date earlier than today, so I'm not sure
it gets you what you want?
You should be able to check if the historical quotes has been updated for
the day by comparing the above with:
RCHGetYahooQuotes("MMM","d1",,,,1,1)(1,1)
On Mon, Jan 7, 2013 at 10:54 AM, Pete A optionzz@gmail.com > wrote:
> Thanks Randy. That works for finding the earliest data date available, in
> a formula. I didn't make it clear that I also need the latest date
> available. Some stocks have stopped trading, or changed tickers, so when
> there is a "latest date" earlier than today, more research is merited.
> I'll convert the formula for earliest date into vba. Thanks! Pete A
>
RCHGetYahooHistory(
But right now, that will get you a date earlier than today, so I'm not sure
it gets you what you want?
You should be able to check if the historical quotes has been updated for
the day by comparing the above with:
RCHGetYahooQuotes(
On Mon, Jan 7, 2013 at 10:54 AM, Pete A optionzz@gmail.
> Thanks Randy. That works for finding the earliest data date available, in
> a formula. I didn't make it clear that I also need the latest date
> available. Some stocks have stopped trading, or changed tickers, so when
> there is a "latest date" earlier than today, more research is merited.
> I'll convert the formula for earliest date into vba. Thanks! Pete A
>
Mon Jan 7, 2013 2:44 pm (PST) . Posted by:
"Steven" stevenletzer
FINRA's website provides a data table, listing all of the bonds issued by a public company. The site returns only 10 bonds per page. I want to capture in Excel. For example: for ATT, the web address is http://cxa.gtm.idmanagedsolutions.com/finra/BondCenter/SearchResult.aspx?q=T
A table of 10 of 72 bonds will appear. Any ideas of how to capture all of the results in Excel?
A table of 10 of 72 bonds will appear. Any ideas of how to capture all of the results in Excel?
Mon Jan 7, 2013 2:49 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I'm not aware of how to can additional pages with an ASP web page. I've
never seen how to get a bookmarkable URL for the later pages.
You might be able to do it with VBA controlling the IE object, but that's
beyond the scope of this group.
On Mon, Jan 7, 2013 at 3:44 PM, Steven stevenletzer@yahoo.com > wrote:
> FINRA's website provides a data table, listing all of the bonds issued by
> a public company. The site returns only 10 bonds per page. I want to
> capture in Excel. For example: for ATT, the web address is
> http://cxa.gtm.idmanagedsolutions.com/finra/BondCenter/SearchResult.aspx?q=T
>
> A table of 10 of 72 bonds will appear. Any ideas of how to capture all of
> the results in Excel?
>
never seen how to get a bookmarkable URL for the later pages.
You might be able to do it with VBA controlling the IE object, but that's
beyond the scope of this group.
On Mon, Jan 7, 2013 at 3:44 PM, Steven stevenletzer@
> FINRA's website provides a data table, listing all of the bonds issued by
> a public company. The site returns only 10 bonds per page. I want to
> capture in Excel. For example: for ATT, the web address is
> http://cxa.gtm.
>
> A table of 10 of 72 bonds will appear. Any ideas of how to capture all of
> the results in Excel?
>
Mon Jan 7, 2013 2:51 pm (PST) . Posted by:
"Randy H" rharmelink
Sigh -- "how to get", not "how to can".
Don't you hate it when you see something like that JUST as you hit the SEND button?
Proofread. Proofread. Proofread.
--- In smf_addin@yahoogrou
>
> I'm not aware of how to can additional pages with an ASP web page.
Mon Jan 7, 2013 4:28 pm (PST) . Posted by:
"Srini Kasturi" kasturi.srini
Randy:
We are all human! No big deal as I see it
SK
________________________________
From: Randy H rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Monday, January 7, 2013 3:51 PM
Subject: [smf_addin] Re: FINRA Website Bond Data
Sigh -- "how to get", not "how to can".
Don't you hate it when you see something like that JUST as you hit the SEND button?
Proofread. Proofread. Proofread.
--- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
>
> I'm not aware of how to can additional pages with an ASP web page.
We are all human! No big deal as I see it
SK
____________
From: Randy H rharmelink@gmail.
To: smf_addin@yahoogrou
Sent: Monday, January 7, 2013 3:51 PM
Subject: [smf_addin] Re: FINRA Website Bond Data
Sigh -- "how to get", not "how to can".
Don't you hate it when you see something like that JUST as you hit the SEND button?
Proofread. Proofread. Proofread.
--- In smf_addin@yahoogrou
>
> I'm not aware of how to can additional pages with an ASP web page.
Mon Jan 7, 2013 8:02 pm (PST) . Posted by:
"iamruf" iamruf
I am trying to import from web url below using Excel 2010 Data/From Web import without success. Excel data retrieval from many other url sites has been successful.
Excel returns a dialog box for this url - Web query returned no data (with instructions on how to edit the named query).
Is there a problem with this url?
http://tmx.quotemedia.com/funds-ca-quote.php?qm_symbol=AFM101
Alternatively, is there an SMF AddIn function that will work?
Excel returns a dialog box for this url - Web query returned no data (with instructions on how to edit the named query).
Is there a problem with this url?
http://tmx.quotemed
Alternatively, is there an SMF AddIn function that will work?
Mon Jan 7, 2013 8:10 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
The reason you have a problem is that the data is not in the source code of
the web page. It's dynamically placed there. That means the add-in would
also have issues.
On Mon, Jan 7, 2013 at 9:02 PM, iamruf iamruf@yahoo.com > wrote:
> I am trying to import from web url below using Excel 2010 Data/From Web
> import without success. Excel data retrieval from many other url sites has
> been successful.
> Excel returns a dialog box for this url - Web query returned no data (with
> instructions on how to edit the named query).
> Is there a problem with this url?
> http://tmx.quotemedia.com/funds-ca-quote.php?qm_symbol=AFM101
> Alternatively, is there an SMF AddIn function that will work?
>
the web page. It's dynamically placed there. That means the add-in would
also have issues.
On Mon, Jan 7, 2013 at 9:02 PM, iamruf iamruf@yahoo.
> I am trying to import from web url below using Excel 2010 Data/From Web
> import without success. Excel data retrieval from many other url sites has
> been successful.
> Excel returns a dialog box for this url - Web query returned no data (with
> instructions on how to edit the named query).
> Is there a problem with this url?
> http://tmx.quotemed
> Alternatively, is there an SMF AddIn function that will work?
>
Mon Jan 7, 2013 8:56 pm (PST) . Posted by:
"bobc94595" bobc94595
What is the symbol to be used to get the Dow Industrials daily close?
$indu, and ^indu don't work.
$indu, and ^indu don't work.
Mon Jan 7, 2013 9:14 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Dow Jones no longer allows Yahoo to include price quotes of their indexes
in Yahoo's CSV files, so such quotes are no longer available to the
RCHGetYahooQuotes() and RCHGetYahooHistory() functions.
On Mon, Jan 7, 2013 at 9:56 PM, bobc94595 conlonrc@comcast.net > wrote:
> What is the symbol to be used to get the Dow Industrials daily close?
>
> $indu, and ^indu don't work.
>
in Yahoo's CSV files, so such quotes are no longer available to the
RCHGetYahooQuotes(
On Mon, Jan 7, 2013 at 9:56 PM, bobc94595 conlonrc@comcast.
> What is the symbol to be used to get the Dow Industrials daily close?
>
> $indu, and ^indu don't work.
>
Tidak ada komentar:
Posting Komentar