10 New Messages
Digest #2439
3a
Re: SMF-Template-RCHGetYahooQuotes.xls 163 KB rharmelink Aug 14, 20 by "ecwmba@sbcglobal.net" ecwmba@sbcglobal.net
3b
Re: SMF-Template-RCHGetYahooQuotes.xls 163 KB rharmelink Aug 14, 200 by "Randy Harmelink" rharmelink
Messages
Mon Dec 17, 2012 5:19 am (PST) . Posted by:
"Randy Harmelink" rharmelink
You need to use the RCHGetYahooHistory() function. It's the only functions
that does the unadjusted prices.
On Mon, Dec 17, 2012 at 3:06 AM, Jason <jasonchmak@gmail.com > wrote:
>
> I want to get the unadjusted (closing) price on a certain date but the
> smfPricesByDates() function can only give me the adjusted close. I've tried
> to use the smfPricesBetween() function instead by can also get the adjusted
> close only. Is there any convenient way to get the unadjusted closing price
> using your functions?
>
that does the unadjusted prices.
On Mon, Dec 17, 2012 at 3:06 AM, Jason <jasonchmak@gmail.
>
> I want to get the unadjusted (closing) price on a certain date but the
> smfPricesByDates(
> to use the smfPricesBetween(
> close only. Is there any convenient way to get the unadjusted closing price
> using your functions?
>
Mon Dec 17, 2012 7:23 am (PST) . Posted by:
"Jason Mak" jasonchmak
Thanks!
On Mon, Dec 17, 2012 at 9:19 PM, Randy Harmelink <rharmelink@gmail.com >wrote:
> **
>
>
> You need to use the RCHGetYahooHistory() function. It's the only functions
> that does the unadjusted prices.
>
> On Mon, Dec 17, 2012 at 3:06 AM, Jason <jasonchmak@gmail.com > wrote:
>
>>
>> I want to get the unadjusted (closing) price on a certain date but the
>> smfPricesByDates() function can only give me the adjusted close. I've tried
>> to use the smfPricesBetween() function instead by can also get the adjusted
>> close only. Is there any convenient way to get the unadjusted closing price
>> using your functions?
>>
>
>
>
On Mon, Dec 17, 2012 at 9:19 PM, Randy Harmelink <rharmelink@gmail.
> **
>
>
> You need to use the RCHGetYahooHistory(
> that does the unadjusted prices.
>
> On Mon, Dec 17, 2012 at 3:06 AM, Jason <jasonchmak@gmail.
>
>>
>> I want to get the unadjusted (closing) price on a certain date but the
>> smfPricesByDates(
>> to use the smfPricesBetween(
>> close only. Is there any convenient way to get the unadjusted closing price
>> using your functions?
>>
>
>
>
Mon Dec 17, 2012 8:17 am (PST) . Posted by:
"navelhunt" navelhunt
Hi,
I am getting data which is presented in XML table format. See below for an example. I wonder if there is any preferred way of getting the data out. i.e. which function. use SMFgettagcontent and then try to use smfstrextr to get the numbers inbetween quotation marks? If there is anything i am missing here or if there is a better way to pull this out then i would be very keen to hear about it.
Many thanks!
Brian
<EquitySummaryInBase>
<EquitySummaryByReportDateInBase accountId="U1135xxx" cash="0" cashLong="0" cashShort="0" stock="0" stockLong="0" stockShort="0" total="0" totalLong="0" totalShort="0"/>
<EquitySummaryByReportDateInBase accountId="U1135xxx" cash="12872.8" cashLong="12872.8" cashShort="0" stock="0" stockLong="0" stockShort="0" total="12872.8" totalLong="12872.8" totalShort="0"/>
<EquitySummaryByReportDateInBase accountId="U1135xxx" cash="12879.2" cashLong="12879.2" cashShort="0" stock="0" stockLong="0" stockShort="0" total="12879.2" totalLong="12879.2" totalShort="0"/>
</EquitySummaryInBase>
I am getting data which is presented in XML table format. See below for an example. I wonder if there is any preferred way of getting the data out. i.e. which function. use SMFgettagcontent and then try to use smfstrextr to get the numbers inbetween quotation marks? If there is anything i am missing here or if there is a better way to pull this out then i would be very keen to hear about it.
Many thanks!
Brian
<EquitySummaryInBas
<EquitySummaryByRep
<EquitySummaryByRep
<EquitySummaryByRep
</EquitySummaryInBa
Mon Dec 17, 2012 9:16 am (PST) . Posted by:
"Randy H" rharmelink
That's a tougher one, because typically each data item has it's own tag.
The smfGetTagContent() works off a concept of a starting tag and an
ending tag, and retrieving everything in between that pair of tags. This
has data items within the starting tag of each entry, with no ending
tag.
I would probably suggest this to get all 3 sub-tags in that section:
=smfGetTagContent(URL,"EquitySummaryInBase",1)
Then, if you want to retrieve the second sub-tag within the content of
that extracted section, you can use the "/" character to parse the
content into "words" based on that delimiter:
=smfWord(_TagContent_,2,"/")
Then, to pull "cashLong" out of that parsed word (the "0+" converts the
extracted text into a number):
=0+smfStrExtr(_ParsedWord_,"cashLong=""","""")
Or, to it all in one fell swoop:
=0+smfStrExtr(smfWord(smfGetTagContent(URL,"EquitySummaryInBase",1),2,"/\
"),"cashLong=""","""")
Since you have two parameters there, you can vary them by reference
within a table. This formula (dropping the "0+" for accountID since it
is text):
=0+smfStrExtr(smfWord(smfGetTagContent(URL,"EquitySummaryInBase",1),$C52\
,"/"),E$51&"=""","""")
...can give me:
# accountId cash cashLong cashShort stock stockLong stockShort
total totalLong totalShort 1 U1135xxx $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 2 U1135xxx $12,872.80
$12,872.80 $0.00 $0.00 $0.00 $0.00 $12,872.80 $12,872.80 $0.00
3 U1135xxx $12,879.20 $12,879.20 $0.00 $0.00 $0.00 $0.00
$12,879.20 $12,879.20 $0.00
On Mon, Dec 17, 2012 at 9:17 AM, navelhunt <navelhunt@yahoo.com
<mailto:navelhunt@yahoo.com > > wrote:
Hi,
I am getting data which is presented in XML table format. See below for
an example. I wonder if there is any preferred way of getting the data
out. i.e. which function. use SMFgettagcontent and then try to use
smfstrextr to get the numbers inbetween quotation marks? If there is
anything i am missing here or if there is a better way to pull this out
then i would be very keen to hear about it.
Many thanks!
Brian
<EquitySummaryInBase>
<EquitySummaryByReportDateInBase accountId="U1135xxx" cash="0"
cashLong="0" cashShort="0" stock="0" stockLong="0" stockShort="0"
total="0" totalLong="0" totalShort="0"/>
<EquitySummaryByReportDateInBase accountId="U1135xxx" cash="12872.8"
cashLong="12872.8" cashShort="0" stock="0" stockLong="0" stockShort="0"
total="12872.8" totalLong="12872.8" totalShort="0"/>
<EquitySummaryByReportDateInBase accountId="U1135xxx" cash="12879.2"
cashLong="12879.2" cashShort="0" stock="0" stockLong="0" stockShort="0"
total="12879.2" totalLong="12879.2" totalShort="0"/>
</EquitySummaryInBase>
The smfGetTagContent(
ending tag, and retrieving everything in between that pair of tags. This
has data items within the starting tag of each entry, with no ending
tag.
I would probably suggest this to get all 3 sub-tags in that section:
=smfGetTagContent(
Then, if you want to retrieve the second sub-tag within the content of
that extracted section, you can use the "/" character to parse the
content into "words" based on that delimiter:
=smfWord(_TagConten
Then, to pull "cashLong" out of that parsed word (the "0+" converts the
extracted text into a number):
=0+smfStrExtr(
Or, to it all in one fell swoop:
=0+smfStrExtr(
"),"cashLong=
Since you have two parameters there, you can vary them by reference
within a table. This formula (dropping the "0+" for accountID since it
is text):
=0+smfStrExtr(
,"/"),E$51&"
...can give me:
# accountId cash cashLong cashShort stock stockLong stockShort
total totalLong totalShort 1 U1135xxx $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 2 U1135xxx $12,872.80
$12,872.80 $0.00 $0.00 $0.00 $0.00 $12,872.80 $12,872.80 $0.00
3 U1135xxx $12,879.20 $12,879.20 $0.00 $0.00 $0.00 $0.00
$12,879.20 $12,879.20 $0.00
On Mon, Dec 17, 2012 at 9:17 AM, navelhunt <navelhunt@yahoo.
<mailto:navelhunt@yahoo.
Hi,
I am getting data which is presented in XML table format. See below for
an example. I wonder if there is any preferred way of getting the data
out. i.e. which function. use SMFgettagcontent and then try to use
smfstrextr to get the numbers inbetween quotation marks? If there is
anything i am missing here or if there is a better way to pull this out
then i would be very keen to hear about it.
Many thanks!
Brian
<EquitySummaryInBas
<EquitySummaryByRep
cashLong="0" cashShort="0" stock="0" stockLong="0" stockShort="
total="0" totalLong="0" totalShort="
<EquitySummaryByRep
cashLong="12872.
total="12872.
<EquitySummaryByRep
cashLong="12879.
total="12879.
</EquitySummaryInBa
Mon Dec 17, 2012 11:06 am (PST) . Posted by:
"ecwmba@sbcglobal.net" ecwmba@sbcglobal.net
I am having troulbe with F9 not working. I am using Excel 2010. Any tips or suggestions?
Eric
--- In smf_addin@yahoogroups.com , "iamruf" <iam.samw@...> wrote:
>
> SMF-Template-RCHGetYahooQuotes.xls 163 KB rharmelink Aug 14, 2007
> A template with an example of using the RCHGetYahooQuotes() function.
> I have downloaded this template to Excel 2010 but it will not run with either F9 or Shift F9.
> Please advise if there is something else I need to do.
> Thanks
>
Eric
--- In smf_addin@yahoogrou
>
> SMF-Template-
> A template with an example of using the RCHGetYahooQuotes(
> I have downloaded this template to Excel 2010 but it will not run with either F9 or Shift F9.
> Please advise if there is something else I need to do.
> Thanks
>
Mon Dec 17, 2012 11:22 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Did you look at the suggestions earlier in this thread? Were they relevant
to your situation?
My first thoughts are what was mentioned there -- Temporary Internet Files,
unresolved links, or regional settings.
On Mon, Dec 17, 2012 at 12:06 PM, ecwmba@sbcglobal.net <ecwmba@sbcglobal.net
> wrote:
> I am having troulbe with F9 not working. I am using Excel 2010. Any tips
> or suggestions?
> Eric
>
> --- In smf_addin@yahoogroups.com , "iamruf" <iam.samw@...> wrote:
> >
> > SMF-Template-RCHGetYahooQuotes.xls 163 KB rharmelink Aug 14, 2007
> > A template with an example of using the RCHGetYahooQuotes() function.
> > I have downloaded this template to Excel 2010 but it will not run with
> either F9 or Shift F9.
> > Please advise if there is something else I need to do.
>
to your situation?
My first thoughts are what was mentioned there -- Temporary Internet Files,
unresolved links, or regional settings.
On Mon, Dec 17, 2012 at 12:06 PM, ecwmba@sbcglobal.
> wrote:
> I am having troulbe with F9 not working. I am using Excel 2010. Any tips
> or suggestions?
> Eric
>
> --- In smf_addin@yahoogrou
> >
> > SMF-Template-
> > A template with an example of using the RCHGetYahooQuotes(
> > I have downloaded this template to Excel 2010 but it will not run with
> either F9 or Shift F9.
> > Please advise if there is something else I need to do.
>
Mon Dec 17, 2012 5:39 pm (PST) . Posted by:
"McGinnis" mrpatmcginnis
Is it possible to extract all the data from this page and use that
information to reference to? If so what is that formula?
--- In smf_addin@yahoogrou
wrote:
>
> Sure. For example:
>
>
=RCHGetTableCell(
AMCD
> Ratio")
>
> On Sat, Dec 15, 2012 at 9:57 PM, Jacob Jose pepecan47@..
>
> >
> > Is it possible to extract data from this page?
> >
> > http://ca.advfn.
> >
> > I am particulary interested in
> >
> > 5-Y Average P/E Ratio
> >
> >
>
Mon Dec 17, 2012 6:24 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
You'd need to write a separate RCHGetTableCell() formula, similar to
the one already given, for each data item.
On Mon, Dec 17, 2012 at 6:39 PM, McGinnis <mrpatmcginnis@yahoo.com > wrote:
>
> Is it possible to extract all the data from this page and use that
> information to reference to? If so what is that formula?
the one already given, for each data item.
On Mon, Dec 17, 2012 at 6:39 PM, McGinnis <mrpatmcginnis@
>
> Is it possible to extract all the data from this page and use that
> information to reference to? If so what is that formula?
Mon Dec 17, 2012 6:19 pm (PST) . Posted by:
"Jorge" jagonzbe
Hello,
The following code is returning "Error": =RCHGetTableCell( "http://www.zacks.com/research/report.php? type=estimates& t="&A3,1,"Next Report Date")
Please advice
Thank you
Jorge
The following code is returning "Error": =RCHGetTableCell( "http://www.zacks.
Please advice
Thank you
Jorge
Mon Dec 17, 2012 6:27 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Zack's just changed the structure of their website, so most URLs will
probably need to be changed. Try:
=RCHGetTableCell( "http://www.zacks.com/stock/quote/ "&D4,1,"Next
Earnings Report Date")
On Mon, Dec 17, 2012 at 7:19 PM, Jorge <jagonzbe@bellsouth.net > wrote:
>
> The following code is returning "Error":
> =RCHGetTableCell( "http://www.zacks.com/research/report.php? type=estimates& t="&A3,1,"Next Report Date")
probably need to be changed. Try:
=RCHGetTableCell( "http://www.zacks.
Earnings Report Date")
On Mon, Dec 17, 2012 at 7:19 PM, Jorge <jagonzbe@bellsouth.
>
> The following code is returning "Error":
> =RCHGetTableCell( "http://www.zacks.
Tidak ada komentar:
Posting Komentar