11 New Messages
Digest #2589
Messages
Thu Apr 18, 2013 5:54 am (PDT) . Posted by:
"ssztaba" ssztaba
I'm new to working with the smf Excel add-in.
I'm trying to gather a list of option prices, bid and ask, on about 50 - 100 different options with different expiration months (from April to next February). The sample files I see seem to show only getting prices from the same month.
Is there a way to get prices for differing option expiration months ??
Is there a basic "User Manual," or "Tutorial"; for downloading ??
What actually causes the functions to go out and get the data requested?? I don't see any "Update prices" or similar type activating button on the sample spreadsheets. As the prices change throughout the day, there must be some way of requesting the latest data, no ??
Thanks
I'm trying to gather a list of option prices, bid and ask, on about 50 - 100 different options with different expiration months (from April to next February). The sample files I see seem to show only getting prices from the same month.
Is there a way to get prices for differing option expiration months ??
Is there a basic "User Manual," or "Tutorial"
What actually causes the functions to go out and get the data requested?? I don't see any "Update prices" or similar type activating button on the sample spreadsheets. As the prices change throughout the day, there must be some way of requesting the latest data, no ??
Thanks
Thu Apr 18, 2013 6:20 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
Check the documentation folder in the files section
Randy's doc isn't the greatest but his add-in is the best.
-----Original Message-----
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of ssztaba
Sent: Thursday, April 18, 2013 8:54 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] General info
I'm new to working with the smf Excel add-in.
I'm trying to gather a list of option prices, bid and ask, on about 50 - 100
different options with different expiration months (from April to next
February). The sample files I see seem to show only getting prices from
the same month.
Is there a way to get prices for differing option expiration months ??
Is there a basic "User Manual," or "Tutorial"; for downloading ??
What actually causes the functions to go out and get the data requested??
I don't see any "Update prices" or similar type activating button on the
sample spreadsheets. As the prices change throughout the day, there must
be some way of requesting the latest data, no ??
Thanks
------------------------------------
Yahoo! Groups Links
Randy's doc isn't the greatest but his add-in is the best.
-----Original Message-----
From: smf_addin@yahoogrou
Of ssztaba
Sent: Thursday, April 18, 2013 8:54 AM
To: smf_addin@yahoogrou
Subject: [smf_addin] General info
I'm new to working with the smf Excel add-in.
I'm trying to gather a list of option prices, bid and ask, on about 50 - 100
different options with different expiration months (from April to next
February). The sample files I see seem to show only getting prices from
the same month.
Is there a way to get prices for differing option expiration months ??
Is there a basic "User Manual," or "Tutorial"
What actually causes the functions to go out and get the data requested??
I don't see any "Update prices" or similar type activating button on the
sample spreadsheets. As the prices change throughout the day, there must
be some way of requesting the latest data, no ??
Thanks
------------
Yahoo! Groups Links
Thu Apr 18, 2013 7:53 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Check out the smfGetOptionQuotes() function.
Also check out the options entry in the LINKS area of the group. It walks
through some of the various option functions.
Also in the LINKS area of the group, take a look at the
smfForceRecalculation item. It's what you'll need to update web pages the
data is extracted from.
On Thu, Apr 18, 2013 at 5:54 AM, ssztaba <ssjurik@optonline.net > wrote:
>
> I'm trying to gather a list of option prices, bid and ask, on about 50 -
> 100 different options with different expiration months (from April to next
> February). The sample files I see seem to show only getting prices from
> the same month.
>
> Is there a way to get prices for differing option expiration months ??
>
> Is there a basic "User Manual," or "Tutorial"; for downloading ??
>
> What actually causes the functions to go out and get the data requested??
> I don't see any "Update prices" or similar type activating button on the
> sample spreadsheets. As the prices change throughout the day, there must
> be some way of requesting the latest data, no ??
>
Also check out the options entry in the LINKS area of the group. It walks
through some of the various option functions.
Also in the LINKS area of the group, take a look at the
smfForceRecalculati
data is extracted from.
On Thu, Apr 18, 2013 at 5:54 AM, ssztaba <ssjurik@optonline.
>
> I'm trying to gather a list of option prices, bid and ask, on about 50 -
> 100 different options with different expiration months (from April to next
> February). The sample files I see seem to show only getting prices from
> the same month.
>
> Is there a way to get prices for differing option expiration months ??
>
> Is there a basic "User Manual," or "Tutorial"
>
> What actually causes the functions to go out and get the data requested??
> I don't see any "Update prices" or similar type activating button on the
> sample spreadsheets. As the prices change throughout the day, there must
> be some way of requesting the latest data, no ??
>
Thu Apr 18, 2013 6:18 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
I'm pretty sure they are aware that it has not been done. Its correct now.
The last thing they need is a million people sending them a notice.
It's a free service have a little patience or use a FEE service then you can
complain.
-----Original Message-----
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of bizmark_ee
Sent: Wednesday, April 17, 2013 10:51 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Yahoo contact
Anyone have a Yahoo help contact email address? Their historical data has
not updated tonight (it's normally 90-100% done by this time, but appears as
if nothing has been updated at all).
E.g.,
http://finance.yahoo.com/q/hp?s=GLD+Historical+Prices shows only through
close of Apr 16.
I can't seem to find a way to alert to them.
------------------------------------
Yahoo! Groups Links
The last thing they need is a million people sending them a notice.
It's a free service have a little patience or use a FEE service then you can
complain.
-----Original Message-----
From: smf_addin@yahoogrou
Of bizmark_ee
Sent: Wednesday, April 17, 2013 10:51 PM
To: smf_addin@yahoogrou
Subject: [smf_addin] Yahoo contact
Anyone have a Yahoo help contact email address? Their historical data has
not updated tonight (it's normally 90-100% done by this time, but appears as
if nothing has been updated at all).
E.g.,
http://finance.
close of Apr 16.
I can't seem to find a way to alert to them.
------------
Yahoo! Groups Links
Thu Apr 18, 2013 8:54 am (PDT) . Posted by:
"bizmark_ee" bizmark_ee
I don't know what you're talking about, but it's definitely NOT fixed as of right now. Pretty significant issue when your historical data is 18 hours of date. As someone who used to work in the data dept. at ESPN, I can say that being alerted to real problems by users was never a bad thing. The earlier the better. What was counterproductive was people using the same channels to bitch about personal computer issues or aesthetics.
Hence, the reason I had asked if anyone here had a real contact at Yahoo.
--- In smf_addin@yahoogrou
>
> I'm pretty sure they are aware that it has not been done. Its correct now.
>
> The last thing they need is a million people sending them a notice.
>
> It's a free service have a little patience or use a FEE service then you can
> complain.
>
> -----Original Message-----
> From: smf_addin@yahoogrou
> Of bizmark_ee
> Sent: Wednesday, April 17, 2013 10:51 PM
> To: smf_addin@yahoogrou
> Subject: [smf_addin] Yahoo contact
>
> Anyone have a Yahoo help contact email address? Their historical data has
> not updated tonight (it's normally 90-100% done by this time, but appears as
> if nothing has been updated at all).
>
> E.g.,
> http://finance.
> close of Apr 16.
>
> I can't seem to find a way to alert to them.
>
>
>
> ------------
>
> Yahoo! Groups Links
>
Thu Apr 18, 2013 9:29 am (PDT) . Posted by:
"Mark Knecht" mw_knecht
On Thu, Apr 18, 2013 at 8:54 AM, bizmark_ee <dustinsmoak@live.com > wrote:
>
>
>
> I don't know what you're talking about, but it's definitely NOT fixed as of
> right now. Pretty significant issue when your historical data is 18 hours of
> date. As someone who used to work in the data dept. at ESPN, I can say that
> being alerted to real problems by users was never a bad thing. The earlier
> the better. What was counterproductive was people using the same channels to
> bitch about personal computer issues or aesthetics.
>
> Hence, the reason I had asked if anyone here had a real contact at Yahoo.
It's a known problem. People using other programs (not Randy's stuff)
to access Yahoo Finance data are also reporting problems. I'm told (by
no one I trust) that Yahoo knows about it. It will get fixed when it
gets fixed.
If you have time-sensitive data needs and require better reliability
then look to purchase your data. My experience with Yahoo is that this
happens 3-4 times a year over the last 5-10 years. Sometimes it's only
hours late in the evening, sometimes 1-2 days. It happens.
Good luck,
Mark
>
>
>
> I don't know what you're talking about, but it's definitely NOT fixed as of
> right now. Pretty significant issue when your historical data is 18 hours of
> date. As someone who used to work in the data dept. at ESPN, I can say that
> being alerted to real problems by users was never a bad thing. The earlier
> the better. What was counterproductive was people using the same channels to
> bitch about personal computer issues or aesthetics.
>
> Hence, the reason I had asked if anyone here had a real contact at Yahoo.
It's a known problem. People using other programs (not Randy's stuff)
to access Yahoo Finance data are also reporting problems. I'm told (by
no one I trust) that Yahoo knows about it. It will get fixed when it
gets fixed.
If you have time-sensitive data needs and require better reliability
then look to purchase your data. My experience with Yahoo is that this
happens 3-4 times a year over the last 5-10 years. Sometimes it's only
hours late in the evening, sometimes 1-2 days. It happens.
Good luck,
Mark
Thu Apr 18, 2013 6:38 am (PDT) . Posted by:
"colinmmoors" colinmmoors
hi, looks like yahoo has yet to update history for yesterday. is there a way to replace yahoo with google or nasdaq? thanks, colin
Thu Apr 18, 2013 7:49 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Depending on what you use them for, they might be a possible source. But
you'd need to use one of the other add-in functions and do it on your own.
On Thu, Apr 18, 2013 at 6:38 AM, colinmmoors <colinmmoors@yahoo.com > wrote:
> hi, looks like yahoo has yet to update history for yesterday. is there a
> way to replace yahoo with google or nasdaq? thanks, colin
>
you'd need to use one of the other add-in functions and do it on your own.
On Thu, Apr 18, 2013 at 6:38 AM, colinmmoors <colinmmoors@
> hi, looks like yahoo has yet to update history for yesterday. is there a
> way to replace yahoo with google or nasdaq? thanks, colin
>
Thu Apr 18, 2013 4:46 pm (PDT) . Posted by:
"David Murphy" jshgfhjsgdfhjgsdfutef
Hi Randy
First of all, thanks very much for your help so far; when I first
thought about tracking realtime stock data via Excel, even though I have
11 years experience of working with Excel, I didn't think it was going
to be easy... then I stumbled across your Yahoo group - woohoo !
If I might presume on your patience and kindness a bit more, I am trying
to load in the data from a Yahoo portfolio I have created with US
stocks; so I took the examples you gave me and tried to amend to the new
source to get as a start the current price for Google
ie replacing
=smfGetTagContent("http://www.nasdaq.com/symbol/amzn/real-time ","div",-1,"id=""qwidget_lastsale""")
with
=smfGetTagContent("http://uk.finance.yahoo.com/portfolio/pf_2/view/v1 ","div",-1,"id=""yfs_l84_goog""")
but this gives "error"
Of course you won't be able to access my portfolio to see what's going
wrong, so I have included below the page source - if you have a few
minutes spare, would you be able to take a look to see what the prob
might be ?
Many thanks in advance
Dave
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd ">
<html lang="en-GB">
<head>
<title>US | Stock Prices | Portfolios | YAHOO! Finance</title>
<meta http-equiv="Content-Type"content="text/html; charset=utf-8"/>
<meta name="description"content=""/>
<meta name="keywords"content="Track your investment portfolios and stock watchlists with the latest stock prices, charts, news and more on Yahoo! Finance."/>
<link rel="stylesheet"type="text/css"href="http://l.yimg.com/bm/combo?fi/common/p/d/static/js/2.0.253765/yui_2.8.0/build/reset-fonts-grids/2.0.0/mini/reset-fonts-grids.css&fi/common/p/d/static/js/2.0.253765/yui_2.8.0/build/tabview/assets/skins/sam/2.0.0/mini/tabview.css&fi/common/p/d/static/css/2.0.253765/2.0.0/mini/yui_helper.css&fi/common/p/d/static/css/2.0.253765/2.0.0/mini/yfi_base.css&fi/common/p/d/static/css/2.0.253765/2.0.0/mini/portfolios-common.css&fi/common/p/d/static/css/2.0.253765/2.0.0/mini/yfi_nav_lego.css&fi/common/p/d/static/css/2.0.253765/2.0.0/mini/yfi_nav_topnav_base_lego.css&fi/common/p/d/static/css/2.0.253765/2.0.0/mini/yfi_nav_topnav_theme_lego.css&fi/common/p/d/static/css/2.0.253765/2.0.0/mini/yfi_nav_portfolio.css&fi/common/p/d/static/css/2.0.253765/2.0.0/mini/yfi_nav_quotebar.css&fi/common/p/d/static/css/2.0.253765/2.0.0/mini/yfi_streaming.css&fi/common/p/d/static/css/2.0.253765/2.0.0/mini/yfi_info_box.css&fi/common/p/d/static/css/2.0.253765/2.0.0/mini/yfi_dropdown_select.css&fi/common/p/d/static/css/2.0.253765/2.0.0/mini/yfi_tablist.css&fi/common/p/d/static/css/2.0.253765/2.0.0/mini/yfi_add_symbol.css&fi/common/p/d/static/css/2.0.253765/2.0.0/mini/yfi_total_value.css&fi/common/p/d/static/css/2.0.253765/2.0.0/mini/yfi_quotes_table.css&fi/common/p/d/static/css/2.0.253765/2.0.0/mini/yfi_pagination.css&fi/common/p/d/static/css/2.0.253765/2.0.0/mini/yfi_recent_news.css&fi/common/p/d/static/css/2.0.253765/2.0.0/mini/yfi_nav_footer_base.css&fi/common/p/d/static/css/2.0.253765/2.0.0/mini/yfi_nav_footer_theme.css&fi/common/p/d/static/css/2.0.253765/2.0.0/mini/yfi_symbol_suggest.css&fi/common/p/d/static/css/2.0.253765/2.0.0/mini/yfi_paginate.css&fi/common/p/d/static/css/2.0.253765/2.0.0/mini/yfi_table_column_sort.css&fi/common/p/d/static/css/2.0.253765/2.0.0/mini/lego.css&fi/common/p/d/static/css/2.0.253765/2.0.0/mini/yfi_theme_teal.css <view-source:http://l.yimg.com/bm/combo?fi/common/p/d/static/js/2.0.253765/yui_2.8.0/build/reset-fonts-grids/2.0.0/mini/reset-fonts-grids.css&fi/common/p/d/static/js/2.0.253765/yui_2.8.0/build/tabview/assets/skins/sam/2.0.0/mini/tabview.css&fi/common/p/d/static/css/2.0.253765/2.0.0/mini/yui_helper.css&fi/common/p/d/static/css/2.0.253765/2.0.0/mini/yfi_base.css&fi/common/p/d/static/css/2.0.253765/2.0.0/mini/portfolios-common.css&fi/common/p/d/static/css/2.0.253765/2.0.0/mini/yfi_nav_lego.css&fi/common/p/d/static/css/2.0.253765/2.0.0/mini/yfi_nav_topnav_base_lego.css&fi/common/p/d/static/css/2.0.253765/2.0.0/mini/yfi_nav_topnav_theme_lego.css&fi/common/p/d/static/css/2.0.253765/2.0.0/mini/yfi_nav_portfolio.css&fi/common/p/d/static/css/2.0.253765/2.0.0/mini/yfi_nav_quotebar.css&fi/common/p/d/static/css/2.0.253765/2.0.0/mini/yfi_streaming.css&fi/common/p/d/static/css/2.0.253765/2.0.0/mini/yfi_info_box.css&fi/common/p/d/static/css/2.0.253765/2.0.0/mini/yfi_dropdown_select.css&fi/common/p/d/static/css/2.0.253765/2.0.0/mini/yfi_tablist.css&fi/common/p/d/static/css/2.0.253765/2.0.0/mini/yfi_add_symbol.css&fi/common/p/d/static/css/2.0.253765/2.0.0/mini/yfi_total_value.css&fi/common/p/d/static/css/2.0.253765/2.0.0/mini/yfi_quotes_table.css&fi/common/p/d/static/css/2.0.253765/2.0.0/mini/yfi_pagination.css&fi/common/p/d/static/css/2.0.253765/2.0.0/mini/yfi_recent_news.css&fi/common/p/d/static/css/2.0.253765/2.0.0/mini/yfi_nav_footer_base.css&fi/common/p/d/static/css/2.0.253765/2.0.0/mini/yfi_nav_footer_theme.css&fi/common/p/d/static/css/2.0.253765/2.0.0/mini/yfi_symbol_suggest.css&fi/common/p/d/static/css/2.0.253765/2.0.0/mini/yfi_paginate.css&fi/common/p/d/static/css/2.0.253765/2.0.0/mini/yfi_table_column_sort.css&fi/common/p/d/static/css/2.0.253765/2.0.0/mini/lego.css&fi/common/p/d/static/css/2.0.253765/2.0.0/mini/yfi_theme_teal.css >"/>
<script type="text/javascript">document.documentElement.className += ' js';</script>
<script>
document.domain="finance.yahoo.com";
</script>
</head>
<body class="yfi-portfolios usetexttransform"id="yfi-portfolios-my-portfolios">
<div id="yfi-doc"class="yui-t7 GB_en_GB">
<div id="hd">
<link type='text/css'rel='stylesheet'href='http://l.yimg.com/zz/combo?kx/ucs/uh/css/291/yunivhead-min.css&kx/ucs/uh/css/221/logo-min.css&kx/ucs/avatar/css/17/avatar-min.css&kx/ucs/notif_v2/css/145/notifications_v2-min.css&kx/ucs/mailcount/css/39/mailcount_v2-min.css&kx/ucs/mailcount/css/37/mail_preview-min.css&kx/ucs/search/css/190/search_all-min.css&kx/ucs/search/css/190/search_buttons-min.css <view-source:http://l.yimg.com/zz/combo?kx/ucs/uh/css/291/yunivhead-min.css&kx/ucs/uh/css/221/logo-min.css&kx/ucs/avatar/css/17/avatar-min.css&kx/ucs/notif_v2/css/145/notifications_v2-min.css&kx/ucs/mailcount/css/39/mailcount_v2-min.css&kx/ucs/mailcount/css/37/mail_preview-min.css&kx/ucs/search/css/190/search_all-min.css&kx/ucs/search/css/190/search_buttons-min.css >'/><style>/* customizable */
#yUnivHead{}
#yUnivHead .yuhead-bullet-down{background-position:right -119px;}
/* font color */
#yUnivHead {color:#fff;}
#yUnivHead a{color:#fff;}
#yUnivHead a:hover{color:#fff;}
#yuhead-hd #yuhead-mepanel-cont #yuhead-mepanel li.yuhead-me{border-color:#fff;}
#yuhead-hd #yuhead-com-links-cont #yuhead-com-links li.yuhead-com-link-item{border-color:#fff;}
.yuhead-logo h2 a{color:#fff;}
/* promo color */
#yUnivHead #yuhead-promo .yucs-promo-label{color:#fff;}
#yUnivHead #yuhead-promo a{color:#fff;}
#yUnivHead #yuhead-promo a:hover{color:#fff;}
/* background, border, gradients */
#yUnivHead {
background:transparent;
}
/* trending promo background - match to header top background */
#yUnivHead .yucs-trending-anim .yucs-trending-anim-fade {
background:transparent;
}
/*logos*/
#yUnivHead .yuhead-logo h2 {background-position:0px -120px;}
#yUnivHead .yuhead-logo h2.small {background-position:0px -360px;}</style><div id="yUnivHead"class="yucs-en-gb"data-lang="en-gb"data-property="finance"data-flight="1366327654"data-uhvc="/;_ylt=An118dT257mIT2iuyN.tRyRmzbFG;_ylu=X3oDMTFkOTFpZ2hhBHNlYwNVSCBWaWV3IENvdW50BHNsawNVSCAyIFN0YW5kYXJkIFBhZ2UgVmlldw--"> <div class="yucs-eprivacy yucs-activate hide"data-nagtext="By using Yahoo!, you agree that we and our {thirdPartiesLink}partners{linkEnd} may set cookies for purposes such as customizing content and advertising. To learn more, review our {cookieLink}Privacy Policy{linkEnd}"data-ylt-cookielink="http://us.lrd.yahoo.com/_ylt=Arl212FEu14ivhQoktc2CAdmzbFG;_ylu=X3oDMTFwNTdvMjc3BHNlYwNVSCBFVSBlUHJpdmFjeSBOYWcgYmFyBHNsawNVSCBFVSBlUHJpdmFjeSBDb29raWUgbGluaw--/SIG=123u7nj09/EXP=1367537254/**http%3A//info.yahoo.com/privacy/uk/yahoo/cookies/ "data-ylt-aimlink="http://us.lrd.yahoo.com/_ylt=Aidwvs_gIxvlval2d6Vy_zlmzbFG;_ylu=X3oDMTFtMjZ0djRlBHNlYwNVSCBFVSBlUHJpdmFjeSBOYWcgYmFyBHNsawNVSCBFVSBlUHJpdmFjeSBBSU0gbGluaw--/SIG=12pvgtjpk/EXP=1367537254/**http%3A//info.yahoo.com/privacy/uk/yahoo/opt_out/targeting/details.html "data-ylt-thirdPartieslink="http://us.lrd.yahoo.com/_ylt=Au6FGDnCP5ZWTkNUaMHj3jtmzbFG;_ylu=X3oDMTFtMjZ0djRlBHNlYwNVSCBFVSBlUHJpdmFjeSBOYWcgYmFyBHNsawNVSCBFVSBlUHJpdmFjeSBBSU0gbGluaw--/SIG=128edi6mg/EXP=1367537254/**http%3A//info.yahoo.com/privacy/uk/yahoo/thirdparties/ "data-ylt-nagbaropen="/;_ylt=AhIDPcsT9MrC6.UAM2p5lkhmzbFG;_ylu=X3oDMTFydW0wN3BvBHNlYwNVSCBFVSBlUHJpdmFjeSBOYWcgYmFyBHNsawNVSCBFVSBlUHJpdmFjeSBOYWdiYXIgb3BlbmVk"data-ylt-nagbarclose="/;_ylt=AshJ.wZAV4Yfixzr05CxaV9mzbFG;_ylu=X3oDMTFyZm90c2xuBHNlYwNVSCBFVSBlUHJpdmFjeSBOYWcgYmFyBHNsawNVSCBFVSBlUHJpdmFjeSBOYWdiYXIgY2xvc2Vk"data-autohide="false";data-linktarget="_top";data-close-txt="Close this window"></div> <a href="#yuhead-search <view-source:http://uk.finance.yahoo.com/portfolio/pf_2/view/v1#yuhead-search >"class="yucs-skipto-search yucs-activate">Skip to search.</a> <div id="yuhead-hd"class="yuhead-clearfix"> <div id="yuhead-mepanel-cont"> <ul id="yuhead-mepanel"class="yucs-toolbar yucs-activate"aria-label="User Services"><li id="yuhead-username"class="yucs-menu yuhead-nodivide yuhead-nopad yucs-um-activate"> <a class="yuhead-firstname yltasis"aria-haspopup="true"rel="nofollow"target="_top"href="http://us.lrd.yahoo.com/_ylt=AiGL286TEVXlt4j1UhDifKBmzbFG;_ylu=X3oDMTEyMzJ1NzdlBHNlYwNVSCBVc2VyIFN1cHBvcnQEc2xrA1VIIFByb2ZpbGU-/SIG=11dsjie1c/EXP=1367537254/**http%3A//profile.yahoo.com/ <view-source:http://us.lrd.yahoo.com/_ylt=AiGL286TEVXlt4j1UhDifKBmzbFG;_ylu=X3oDMTEyMzJ1NzdlBHNlYwNVSCBVc2VyIFN1cHBvcnQEc2xrA1VIIFByb2ZpbGU-/SIG=11dsjie1c/EXP=1367537254/**http%3A//profile.yahoo.com/ >"> <span class="yucs-avatar yucs-av-activate"data-user="David";data-prof="Avatar"data-crumb="CYYvu3nurR/"data-guid="JUKTDRFBJBKVGDW2MKKTNIPT34"></span> <span class="yuhead-hi">Hi, </span><span class="yuhead-name";>David</span> <span class="yucs-menu-access sp yuhead-bullet-down"></span> </a> <ul id="yuhead-useroptions";class="yucs-menu-left hide"> <li class="first-child";> You are signed in as:<span class="yuhead-yid">cybersurferuk@goo...</span> </li> <li> <a href="http://us.lrd.yahoo.com/_ylt=Aqn4Csj4BZyPnCmPsG3Jh3ZmzbFG;_ylu=X3oDMTFiZGFzNWQ1BHNlYwNVSCBVc2VyIFN1cHBvcnQEc2xrA1VIIFByb2ZpbGUgRHJvcGRvd24-/SIG=11dsjie1c/EXP=1367537254/**http%3A//profile.yahoo.com/ <view-source:http://us.lrd.yahoo.com/_ylt=Aqn4Csj4BZyPnCmPsG3Jh3ZmzbFG;_ylu=X3oDMTFiZGFzNWQ1BHNlYwNVSCBVc2VyIFN1cHBvcnQEc2xrA1VIIFByb2ZpbGUgRHJvcGRvd24-/SIG=11dsjie1c/EXP=1367537254/**http%3A//profile.yahoo.com/ >"target="_top"rel="nofollow"> Profile</a> </li> <li> <a href="https://us.lrd.yahoo.com/_ylt=ArgoaIwZjITmSC.LBPfJvo1mzbFG;_ylu=X3oDMTE3YW1nY2phBHNlYwNVSCBVc2VyIFN1cHBvcnQEc2xrA1VIIEFjY291bnQgSW5mbw--/SIG=165qk0inc/EXP=1367537254/**https%3A//edit.yahoo.com/mc2.0/
First of all, thanks very much for your help so far; when I first
thought about tracking realtime stock data via Excel, even though I have
11 years experience of working with Excel, I didn't think it was going
to be easy... then I stumbled across your Yahoo group - woohoo !
If I might presume on your patience and kindness a bit more, I am trying
to load in the data from a Yahoo portfolio I have created with US
stocks; so I took the examples you gave me and tried to amend to the new
source to get as a start the current price for Google
ie replacing
=smfGetTagContent(
with
=smfGetTagContent(
but this gives "error"
Of course you won't be able to access my portfolio to see what's going
wrong, so I have included below the page source - if you have a few
minutes spare, would you be able to take a look to see what the prob
might be ?
Many thanks in advance
Dave
<!DOCTYPE HTML PUBLIC "-//W3C/
<html lang="en-
<head>
<title>
<meta http-equiv="
<meta name="descript
<meta name="keywords
<link rel="styleshee
<script type="text/
<script>
document.domain=
</script>
</head>
<body class="
<div id="yfi-
<div id="hd"
<link type='text/
#yUnivHead{}
#yUnivHead .yuhead-bullet-
/* font color */
#yUnivHead {color:#fff;
#yUnivHead a{color:#fff;
#yUnivHead a:hover{color:
#yuhead-hd #yuhead-mepanel-
#yuhead-hd #yuhead-com-
.yuhead-logo h2 a{color:#fff;
/* promo color */
#yUnivHead #yuhead-promo .yucs-promo-
#yUnivHead #yuhead-promo a{color:#fff;
#yUnivHead #yuhead-promo a:hover{color:
/* background, border, gradients */
#yUnivHead {
background:transpar
}
/* trending promo background - match to header top background */
#yUnivHead .yucs-trending-
background:transpar
}
/*logos*/
#yUnivHead .yuhead-logo h2 {background-
#yUnivHead .yuhead-logo h2.small {background-