12 New Messages
Digest #2549
Messages
Sat Mar 16, 2013 7:56 am (PDT) . Posted by:
"wcshaff" wcshaff
Downloaded the zip file and invoked 7-Zip extract. It hangs up with the error messages next to each file "can not open output file xxxx" etc.
Sat Mar 16, 2013 8:29 am (PDT) . Posted by:
"wcshaff" wcshaff
Extracted in same directory and worked. Not sure why.
--- In smf_addin@yahoogroups.com , "wcshaff" <wcshaff@...> wrote:
>
> Downloaded the zip file and invoked 7-Zip extract. It hangs up with the error messages next to each file "can not open output file xxxx" etc.
>
--- In smf_addin@yahoogrou
>
> Downloaded the zip file and invoked 7-Zip extract. It hangs up with the error messages next to each file "can not open output file xxxx" etc.
>
Sat Mar 16, 2013 9:01 am (PDT) . Posted by:
"iamruf" iamruf
Hi Randy,
Works fine for all RCHGet's for stocks. Thanks, I'm slowly learning.
Does it not work for the following because funds are generated differently? If so, is there a workaround?
=RCHGetTableCell("'http://web.tmxmoney.com/funds-ca-quote.php?qm_symbol=AGF257 ",1,">Fund Type:")
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> So what's wrong with just using:
>
> =RCHGetTableCell("http://web.tmxmoney.com/quote.php?qm_symbol=BNS
> ",1,">High:")
>
> On Fri, Mar 15, 2013 at 4:06 PM, iamruf <iamruf@...> wrote:
>
> >
> > *Hi Randy,*
> > *When I query the symbol BNS, this is the URL that appears.*
> > *I don't know how to get the other one.*
> > *http://web.tmxmoney.com/quote.php?qm_symbol=BNS*
> >
>
Works fine for all RCHGet's for stocks. Thanks, I'm slowly learning.
Does it not work for the following because funds are generated differently? If so, is there a workaround?
=RCHGetTableCell(
--- In smf_addin@yahoogrou
>
> So what's wrong with just using:
>
> =RCHGetTableCell(
> ",1,"
>
> On Fri, Mar 15, 2013 at 4:06 PM, iamruf <iamruf@.
>
> >
> > *Hi Randy,*
> > *When I query the symbol BNS, this is the URL that appears.*
> > *I don't know how to get the other one.*
> > *http://web.tmxmoney
> >
>
Sat Mar 16, 2013 4:09 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
That funds are dynamically generated using JSON. And, apparently, they
didn't like you accessing the JSON file. They've now secured them.
On Sat, Mar 16, 2013 at 9:01 AM, iamruf <iamruf@yahoo.com > wrote:
> Hi Randy,
> Works fine for all RCHGet's for stocks. Thanks, I'm slowly learning.
> Does it not work for the following because funds are generated
> differently? If so, is there a workaround?
> =RCHGetTableCell("'
> http://web.tmxmoney.com/funds-ca-quote.php?qm_symbol=AGF257 ",1,">Fund
> Type:")
>
didn't like you accessing the JSON file. They've now secured them.
On Sat, Mar 16, 2013 at 9:01 AM, iamruf <iamruf@yahoo.
> Hi Randy,
> Works fine for all RCHGet's for stocks. Thanks, I'm slowly learning.
> Does it not work for the following because funds are generated
> differently? If so, is there a workaround?
> =RCHGetTableCell(
> http://web.tmxmoney
> Type:")
>
Sat Mar 16, 2013 11:34 am (PDT) . Posted by:
"DonaldB" donald_brown_48367
That was it. Thanks Randy.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Probably you don't have a recent version of the add-in. The "~" character
> was something I added to indicate "from the start of the string" (or "to
> the end" if it's the second search string).
>
> On Sun, Mar 10, 2013 at 5:54 PM, DonaldB <donald_brown_48367@...>wrote:
>
> >
> > Finally got around to trying to make this work. This formula works fine
> > to return the percentage:
> > =0+smfStrExtr(RCHGetElementNumber("YahooMS", 13822),"(",")")
> >
> > but:
> > =0+smfStrExtr(RCHGetElementNumber("YahooMS", 13822),"~"," ")
> >
> > gives a "$VALUE!" error.
> >
> > Any ideas?
> >
>
--- In smf_addin@yahoogrou
>
> Probably you don't have a recent version of the add-in. The "~" character
> was something I added to indicate "from the start of the string" (or "to
> the end" if it's the second search string).
>
> On Sun, Mar 10, 2013 at 5:54 PM, DonaldB <donald_brown_
>
> >
> > Finally got around to trying to make this work. This formula works fine
> > to return the percentage:
> > =0+smfStrExtr(
> >
> > but:
> > =0+smfStrExtr(
> >
> > gives a "$VALUE!
> >
> > Any ideas?
> >
>
Sat Mar 16, 2013 3:22 pm (PDT) . Posted by:
"hpstr_31" hpstr_31
Greetings,I'm having trouble with the add-ins. downloading and extracting into c:/pgm files/smf add-in and then selecting the addin from excel options, but after re-starting excel, none of the functions are recognized?
Sat Mar 16, 2013 3:28 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Once you activate the add-in via the add-in manager, you shouldn't need to
restart EXCEL to have the functions available.
On Sat, Mar 16, 2013 at 3:06 PM, hpstr_31 <holliday.jeff@yahoo.com > wrote:
> Greetings,I'm having trouble with the add-ins. downloading and extracting
> into c:/pgm files/smf add-in and then selecting the addin from excel
> options, but after re-starting excel, none of the functions are recognized?
>
restart EXCEL to have the functions available.
On Sat, Mar 16, 2013 at 3:06 PM, hpstr_31 <holliday.jeff@
> Greetings,I&#
> into c:/pgm files/smf add-in and then selecting the addin from excel
> options, but after re-starting excel, none of the functions are recognized?
>
Sat Mar 16, 2013 4:20 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The updated element definitions are in the smf-elements-5.txt in the "Works
in Progress" folder of the FILES area.
They used to have "effective" misspelled on the web page, and have
corrected it. So I needed to use the new, corrected spelling in the element
definitions. :)
The S&P 500 element will still be "Error", as they haven't had the S&P 500
comparison column for quite some time.
On Sat, Mar 16, 2013 at 12:18 AM, weekeewawa <weekeewawa@yahoo.com > wrote:
>
> as i was inputting reuters Effective Tax Rate 5 Year Average, it seems
> that there is error shown on Effective Tax Rate 5 Year Average
> (company,industry,sector and S&P500)
>
> could the rch element of 13774-13777 be invalid?
>
in Progress" folder of the FILES area.
They used to have "effective&quo
corrected it. So I needed to use the new, corrected spelling in the element
definitions. :)
The S&P 500 element will still be "Error"
comparison column for quite some time.
On Sat, Mar 16, 2013 at 12:18 AM, weekeewawa <weekeewawa@yahoo.
>
> as i was inputting reuters Effective Tax Rate 5 Year Average, it seems
> that there is error shown on Effective Tax Rate 5 Year Average
> (company,industry,
>
> could the rch element of 13774-13777 be invalid?
>
Sat Mar 16, 2013 8:12 pm (PDT) . Posted by:
"weekeewawa" weekeewawa
hi randy, it seems the text file smf-elements-5 in the work in progress folder shows the element number to be 13774-13777 for effective tax rate 5 year average as well even though i think u uploaded it as recent as ytd?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> The updated element definitions are in the smf-elements-5.txt in the "Works
> in Progress" folder of the FILES area.
>
> They used to have "effective" misspelled on the web page, and have
> corrected it. So I needed to use the new, corrected spelling in the element
> definitions. :)
>
> The S&P 500 element will still be "Error", as they haven't had the S&P 500
> comparison column for quite some time.
>
> On Sat, Mar 16, 2013 at 12:18 AM, weekeewawa <weekeewawa@...> wrote:
>
> >
> > as i was inputting reuters Effective Tax Rate 5 Year Average, it seems
> > that there is error shown on Effective Tax Rate 5 Year Average
> > (company,industry,sector and S&P500)
> >
> > could the rch element of 13774-13777 be invalid?
> >
>
--- In smf_addin@yahoogrou
>
> The updated element definitions are in the smf-elements-
> in Progress" folder of the FILES area.
>
> They used to have "effective&quo
> corrected it. So I needed to use the new, corrected spelling in the element
> definitions. :)
>
> The S&P 500 element will still be "Error"
> comparison column for quite some time.
>
> On Sat, Mar 16, 2013 at 12:18 AM, weekeewawa <weekeewawa@
>
> >
> > as i was inputting reuters Effective Tax Rate 5 Year Average, it seems
> > that there is error shown on Effective Tax Rate 5 Year Average
> > (company,industry,
> >
> > could the rch element of 13774-13777 be invalid?
> >
>
Sat Mar 16, 2013 9:32 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I'm not sure what you're asking?
On Sat, Mar 16, 2013 at 8:12 PM, weekeewawa <weekeewawa@yahoo.com > wrote:
> hi randy, it seems the text file smf-elements-5 in the work in progress
> folder shows the element number to be 13774-13777 for effective tax rate 5
> year average as well even though i think u uploaded it as recent as ytd?
>
On Sat, Mar 16, 2013 at 8:12 PM, weekeewawa <weekeewawa@yahoo.
> hi randy, it seems the text file smf-elements-
> folder shows the element number to be 13774-13777 for effective tax rate 5
> year average as well even though i think u uploaded it as recent as ytd?
>
Sun Mar 17, 2013 12:46 am (PDT) . Posted by:
"weekeewawa" weekeewawa
hi
according to the thread, the example is
=smfGetTagContent("http://finance.yahoo.com/q?s= "&$B$3,"a",...row...,"Filter Headlines")
but i was extracting the files from
http://finance.yahoo.com/q/h?s=IBM+Headlines
the codes is therefore
=smfGetTagContent("http://finance.yahoo.com/q/h?s= "&$A$1,"a",1,"Filter Headlines") as i am using Cell A1 instead
however, a blank cell is given and even when i array, it is empty
is there something wrong with it?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> What did you try? I can't spoon-feed every extraction formula everyone
> needs. Then no one learns how to do it themselves.
>
> "Market Pulse" is not a table, so it would not be a trivial extraction.
>
> For the rest of (1) and (2), you can try some permutations of parameters on
> the smfGetTagContent-Quick-Webpage-Examination.xls workbook -- it has a
> table extraction template page. But, just as an example:
>
> =RCHGetHTMLTable("http://finance.yahoo.com/marketpulse/ "&A1,">Trending
> Tickers",1,"",1)
>
> Items (3) and (4) can be found in the message archives of the Yahoo Group
> if you do a search.
>
> On Fri, Mar 15, 2013 at 9:16 PM, weekeewawa <weekeewawa@...> wrote:
>
> > hi, i have a few problems in extract data from certain yahoo sources
> >
> > how do i extract the table data from
> >
> > 1) http://finance.yahoo.com/marketpulse/IBM
> >
> > ''Market Pulse for IBM'' and ''Trending Tickers on Market Pulse'' tables?
> >
> > 2) http://biz.yahoo.com/ic/l/pip.html
> > ''Leaders in Price Performance (Intraday)'' and ''Laggards in Price
> > Performance (Intraday)'' data?
> >
> > 3) http://finance.yahoo.com/q/h?s=IBM+Headlines
> > where i can extract headlines data to the excel sheet
> >
> > 4) http://finance.yahoo.com/q/co?s=IBM+Competitors
> > where ''Computer Hardware (US) Ranked by Sales'' table may vary depending
> > on the industry such as for perhaps GM, it will show ''Auto (US) Ranked By
> > Sales
> >
> > and i would like to point the ticker to a specific cell A1 instead of IBM
> >
>
according to the thread, the example is
=smfGetTagContent(
but i was extracting the files from
http://finance.
the codes is therefore
=smfGetTagContent(
however, a blank cell is given and even when i array, it is empty
is there something wrong with it?
--- In smf_addin@yahoogrou
>
> What did you try? I can't spoon-feed every extraction formula everyone
> needs. Then no one learns how to do it themselves.
>
> "Market Pulse" is not a table, so it would not be a trivial extraction.
>
> For the rest of (1) and (2), you can try some permutations of parameters on
> the smfGetTagContent-
> table extraction template page. But, just as an example:
>
> =RCHGetHTMLTable(
> Tickers"
>
> Items (3) and (4) can be found in the message archives of the Yahoo Group
> if you do a search.
>
> On Fri, Mar 15, 2013 at 9:16 PM, weekeewawa <weekeewawa@
>
> > hi, i have a few problems in extract data from certain yahoo sources
> >
> > how do i extract the table data from
> >
> > 1) http://finance.
> >
> > ''Market Pulse for IBM'' and ''Trending Tickers on Market Pulse'&#
> >
> > 2) http://biz.yahoo.
> > ''Leaders in Price Performance (Intraday)&#
> > Performance (Intraday)&#
> >
> > 3) http://finance.
> > where i can extract headlines data to the excel sheet
> >
> > 4) http://finance.
> > where ''Computer Hardware (US) Ranked by Sales'&#
> > on the industry such as for perhaps GM, it will show ''Auto (US) Ranked By
> > Sales
> >
> > and i would like to point the ticker to a specific cell A1 instead of IBM
> >
>
Sun Mar 17, 2013 1:09 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
That page doesn't use the phrase "Filter Headlines". And the original page
doesn't either, so either the format has changed, or it has a different
format when the market is closed?
Try:
=smfGetTagContent("http://finance.yahoo.com/q/h?s= "&$A$1,"a",1,"Get
Headlines")
On Sun, Mar 17, 2013 at 12:46 AM, weekeewawa <weekeewawa@yahoo.com > wrote:
>
> according to the thread, the example is
> =smfGetTagContent("http://finance.yahoo.com/q?s= "&$B$3,"a",...row...,"Filter
> Headlines")
>
> but i was extracting the files from
> http://finance.yahoo.com/q/h?s=IBM+Headlines
>
> the codes is therefore
> =smfGetTagContent("http://finance.yahoo.com/q/h?s= "&$A$1,"a",1,"Filter
> Headlines") as i am using Cell A1 instead
>
> however, a blank cell is given and even when i array, it is empty
>
> is there something wrong with it?
>
doesn't either, so either the format has changed, or it has a different
format when the market is closed?
Try:
=smfGetTagContent(
Headlines"
On Sun, Mar 17, 2013 at 12:46 AM, weekeewawa <weekeewawa@yahoo.
>
> according to the thread, the example is
> =smfGetTagContent(
> Headlines"
>
> but i was extracting the files from
> http://finance.
>
> the codes is therefore
> =smfGetTagContent(
> Headlines"
>
> however, a blank cell is given and even when i array, it is empty
>
> is there something wrong with it?
>
Tidak ada komentar:
Posting Komentar