15 Messages
Digest #3973
Messages
Tue Apr 18, 2017 7:52 pm (PDT) . Posted by:
rr76012
Is anyone else having problems with "rchGetYahooHistory", none of my spreadsheets are working?
Tue Apr 18, 2017 7:54 pm (PDT) . Posted by:
for30sqn
Many thanks Randy. I guess I need to pay more attention to the smf_addin group. Your help is greatly appreciated. Thanks again. Allen
Tue Apr 18, 2017 7:56 pm (PDT) . Posted by:
bizmark_ee
Thanks!
Re-trying my reply as the the first one did not seem to go through.
The yahoo stuff works fine. But when I try =smfGetTagContent("http://www.google.com/finance?q=IBM","span",-1,"_el""",,,,1), it produces "Error". I checked the URL and it is showing a valid AH price right now for IBM.
Re-trying my reply as the the first one did not seem to go through.
The yahoo stuff works fine. But when I try =smfGetTagContent("http://www.google.com/finance?q=IBM","
Tue Apr 18, 2017 8:30 pm (PDT) . Posted by:
bizmark_ee
Thanks so much.
The Yahoo is working fine, but when I try to load the Google Finance after-hours price via this formula:
=smfGetTagContent("http://www.google.com/finance?q=IBM","span",-1,"_el""",,,,1)
it produces, "Error". The web page appears to have a valid after-hours price right now:
https://i.gyazo.com/580f1da5397aeec7fc2fdf90d81aff0d.png https://i.gyazo.com/580f1da5397aeec7fc2fdf90d81aff0d.png
https://i.gyazo.com/580f1da5397aeec7fc2fdf90d81aff0d.png
https://i.gyazo.com/580f1da5397aeec7fc2fdf90d81aff0d.png https://i.gyazo.com/580f1da5397aeec7fc2fdf90d81aff0d.png
View on i.gyazo.com https://i.gyazo.com/580f1da5397aeec7fc2fdf90d81aff0d.png
Preview by Yahoo
The Yahoo is working fine, but when I try to load the Google Finance after-hours price via this formula:
=smfGetTagContent("http://www.google.com/finance?q=IBM","span",-1,"_el""",,,,1)
it produces, "Error". The web page appears to have a valid after-hours price right now:
https://i.gyazo.com/580f1da5397aeec7fc2fdf90d81aff0d.png https://i.gyazo.com/580f1da5397aeec7fc2fdf90d81aff0d.png
https://i.gyazo.com/580f1da5397aeec7fc2fdf90d81aff0d.png
https://i.gyazo.com/580f1da5397aeec7fc2fdf90d81aff0d.png https://i.gyazo.com/580f1da5397aeec7fc2fdf90d81aff0d.png
View on i.gyazo.com https://i.gyazo.com/580f1da5397aeec7fc2fdf90d81aff0d.png
Preview by Yahoo
Tue Apr 18, 2017 9:08 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
IBM is working fine for me...
Oddly enough, SPY is not working now, and I used that when I was creating
the formulas, but now it has no after hours data when I go to the web page.
I noticed the after hours data returned from Yahoo and Google for SPY were
not consistent, so maybe there's an issue someplace there? But now, neither
of them have after-hours data. Hmm.
Maybe try using the "https://" protocol instead of "http:://"?
On Tue, Apr 18, 2017 at 7:56 PM, dustinsmoak@
.. wrote:
>
> The yahoo stuff works fine. But when I try =smfGetTagContent("http://www.
> google.com/finance?q=IBM","span";,-1,"_el""",,,,1), it produces "Error".
> I checked the URL and it is showing a valid AH price right now for IBM.
>
Oddly enough, SPY is not working now, and I used that when I was creating
the formulas, but now it has no after hours data when I go to the web page.
I noticed the after hours data returned from Yahoo and Google for SPY were
not consistent, so maybe there's an issue someplace there? But now, neither
of them have after-hours data. Hmm.
Maybe try using the "https://" protocol instead of "http:://"?
On Tue, Apr 18, 2017 at 7:56 PM, dustinsmoak@
.. wrote:
>
> The yahoo stuff works fine. But when I try =smfGetTagContent("http://www.
> google.com/finance?
> I checked the URL and it is showing a valid AH price right now for IBM.
>
Tue Apr 18, 2017 8:02 pm (PDT) . Posted by:
yolande_tulasse
Hi Randy.
Thanks for the update, now my spreadsheet works again perfectly.
Question though: what's the best way to get a company's description on Yahoo?
(e.g.: on http://finance.yahoo.com/quote/SCHN/profile?p=SCHN http://finance.yahoo.com/quote/SCHN/profile?p=SCHN
=> Schnitzer Steel Industries, Inc. recycles ferrous and nonferrous scrap metals; and manufactures finished steel products worldwide. It operates through two segments, Auto and Metals Recycling (AMR) and Steel Manufacturing Business (SMB). The AMR segment buys, collects, processes, recycles, sells, and brokers scrap metals, as well as processes mixed and large pieces of scrap metal into smaller pieces by crushing, torching, shearing, shredding, and sorting. This segment offers ferrous scrap metal, a feedstock used in the production of finished steel products; and nonferrous products, including aluminum, copper, stainless steel, nickel, brass, titanium, lead, high temperature alloys, and joint products. It sells ferrous and nonferrous recycled metal products to steel mills, foundries, and smelters. This segment also procures salvaged vehicles and sells serviceable used auto parts from these vehicles through its 52 self-service auto parts stores in the United States and Western Canada, as well as sells auto bodies and parts containing ferrous and nonferrous materials, such as engines, transmissions, and alternators to wholesalers. The SMB segment produces various finished steel products using recycled metal and other raw materials. It offers semi-finished goods, which include billets; and finished goods consisting of rebar, coiled rebar, wire rods, merchant bars, and other specialty products. This segment serves steel service centers, construction industry subcontractors, steel fabricators, wire drawers, and farm and wood products suppliers. Schnitzer Steel Industries, Inc. was founded in 1906 and is headquartered in Portland, Oregon.)
Thanks for the update, now my spreadsheet works again perfectly.
Question though: what's the best way to get a company's description on Yahoo?
(e.g.: on http://finance.yahoo.com/quote/SCHN/profile?p=SCHN http://finance.yahoo.com/quote/SCHN/profile?p=SCHN
=> Schnitzer Steel Industries, Inc. recycles ferrous and nonferrous scrap metals; and manufactures finished steel products worldwide. It operates through two segments, Auto and Metals Recycling (AMR) and Steel Manufacturing Business (SMB). The AMR segment buys, collects, processes, recycles, sells, and brokers scrap metals, as well as processes mixed and large pieces of scrap metal into smaller pieces by crushing, torching, shearing, shredding, and sorting. This segment offers ferrous scrap metal, a feedstock used in the production of finished steel products; and nonferrous products, including aluminum, copper, stainless steel, nickel, brass, titanium, lead, high temperature alloys, and joint products. It sells ferrous and nonferrous recycled metal products to steel mills, foundries, and smelters. This segment also procures salvaged vehicles and sells serviceable used auto parts from these vehicles through its 52 self-service auto parts stores in the United States and Western Canada, as well as sells auto bodies and parts containing ferrous and nonferrous materials, such as engines, transmissions, and alternators to wholesalers. The SMB segment produces various finished steel products using recycled metal and other raw materials. It offers semi-finished goods, which include billets; and finished goods consisting of rebar, coiled rebar, wire rods, merchant bars, and other specialty products. This segment serves steel service centers, construction industry subcontractors, steel fabricators, wire drawers, and farm and wood products suppliers. Schnitzer Steel Industries, Inc. was founded in 1906 and is headquartered in Portland, Oregon.)
Tue Apr 18, 2017 8:16 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
That would be the "longBusinessSummary" field from the JSON call to the
"assetProfile" module. Try:
=smfstrExtr(RCHGetWebData("
https://query1.finance.yahoo.com/v10/finance/quoteSummary/
"&C20&"?modules=assetProfile"),"""longBusinessSummary"":""",""",""")
On Tue, Apr 18, 2017 at 8:02 PM, yolande_tulasse@
...wrote:
>
> Question though: what's the best way to get a company's description on
> Yahoo?
>
> (e.g.: on http://finance.yahoo.com/quote/SCHN/profile?p=SCHN
> => Schnitzer Steel Industries, Inc. recycles ferrous and nonferrous scrap
> metals; and manufactures finished steel products worldwide. It operates
> through two segments, Auto and Metals Recycling (AMR) and Steel
> Manufacturing Business (SMB). The AMR segment buys, collects, processes,
> recycles, sells, and brokers scrap metals, as well as processes mixed and
> large pieces of scrap metal into smaller pieces by crushing, torching,
> shearing, shredding, and sorting. This segment offers ferrous scrap metal,
> a feedstock used in the production of finished steel products; and
> nonferrous products, including aluminum, copper, stainless steel, nickel,
> brass, titanium, lead, high temperature alloys, and joint products. It
> sells ferrous and nonferrous recycled metal products to steel mills,
> foundries, and smelters. This segment also procures salvaged vehicles and
> sells serviceable used auto parts from these vehicles through its 52
> self-service auto parts stores in the United States and Western Canada, as
> well as sells auto bodies and parts containing ferrous and nonferrous
> materials, such as engines, transmissions, and alternators to wholesalers.
> The SMB segment produces various finished steel products using recycled
> metal and other raw materials. It offers semi-finished goods, which include
> billets; and finished goods consisting of rebar, coiled rebar, wire rods,
> merchant bars, and other specialty products. This segment serves steel
> service centers, construction industry subcontractors, steel fabricators,
> wire drawers, and farm and wood products suppliers. Schnitzer Steel
> Industries, Inc. was founded in 1906 and is headquartered in Portland,
> Oregon.)
>
>
>
>
>
>
"assetProfile" module. Try:
=smfstrExtr(RCHGetWebData("
https://query1.finance.yahoo.com/v10/finance/quoteSummary/
"&C20&"?modules=assetProfile"),"""longBusinessSummary"":""",""",""")
On Tue, Apr 18, 2017 at 8:02 PM, yolande_tulasse@
...wrote:
>
> Question though: what's the best way to get a company's description on
> Yahoo?
>
> (e.g.: on http://finance.yahoo.com/quote/SCHN/profile?p=SCHN
> => Schnitzer Steel Industries, Inc. recycles ferrous and nonferrous scrap
> metals; and manufactures finished steel products worldwide. It operates
> through two segments, Auto and Metals Recycling (AMR) and Steel
> Manufacturing Business (SMB). The AMR segment buys, collects, processes,
> recycles, sells, and brokers scrap metals, as well as processes mixed and
> large pieces of scrap metal into smaller pieces by crushing, torching,
> shearing, shredding, and sorting. This segment offers ferrous scrap metal,
> a feedstock used in the production of finished steel products; and
> nonferrous products, including aluminum, copper, stainless steel, nickel,
> brass, titanium, lead, high temperature alloys, and joint products. It
> sells ferrous and nonferrous recycled metal products to steel mills,
> foundries, and smelters. This segment also procures salvaged vehicles and
> sells serviceable used auto parts from these vehicles through its 52
> self-service auto parts stores in the United States and Western Canada, as
> well as sells auto bodies and parts containing ferrous and nonferrous
> materials, such as engines, transmissions, and alternators to wholesalers.
> The SMB segment produces various finished steel products using recycled
> metal and other raw materials. It offers semi-finished goods, which include
> billets; and finished goods consisting of rebar, coiled rebar, wire rods,
> merchant bars, and other specialty products. This segment serves steel
> service centers, construction industry subcontractors, steel fabricators,
> wire drawers, and farm and wood products suppliers. Schnitzer Steel
> Industries, Inc. was founded in 1906 and is headquartered in Portland,
> Oregon.)
>
>
>
>
>
>
Wed Apr 19, 2017 7:56 am (PDT) . Posted by:
yolande_tulasse
You're the bloody best mate! Thanks a lot
Tue Apr 18, 2017 8:25 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Have you updated to the new version of the add-in that was announced two
days ago?
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/31666
On Tue, Apr 18, 2017 at 7:52 PM, rr76012@
.. wrote:
> Is anyone else having problems with "rchGetYahooHistory", none of my
> spreadsheets are working?
>
>
days ago?
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/31666
On Tue, Apr 18, 2017 at 7:52 PM, rr76012@
.. wrote:
> Is anyone else having problems with "rchGetYahooHi
> spreadsheets are working?
>
>
Tue Apr 18, 2017 8:57 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
It would be necessary to extract data from the new JSON calls that Yahoo
does. For example, using the field you asked about:
=smfConvertData(smfstrExtr(smfWord(RCHGetWebData("https:/
/query1.finance.yahoo.com/v10/finance/quoteSummary/RY?region=CA&modules=
cashflowStatementHistory"),2,"""changeToNetincome"":"),"""raw"":",","))
=smfConvertData(smfstrExtr(smfWord(RCHGetWebData("*https://query1.finance.yahoo.com/v10/finance/quoteSummary/RY?region=CA&modules=cashflowStatementHistory
<https://query1.finance.yahoo.com/v10/finance/quoteSummary/RY?region=CA&modules=cashflowStatementHistory>*
"),3,"""changeToNetincome"":"),"""raw"":",","))
=smfConvertData(smfstrExtr(smfWord(RCHGetWebData("https:/
/query1.finance.yahoo.com/v10/finance/quoteSummary/RY?region=CA&modules=
cashflowStatementHistory"),4,"""changeToNetincome"":"),"""raw"":",","))
Step-by-step, that's:
------------------------------
1. Get the raw JSON data for the financial statement:
=RCHGetWebData("https://query1.finance.yahoo.com/v10/
finance/quoteSummary/RY?region=CA&modules=cashflowStatementHistory")
The "region=CA" is what gets Canadian data.
Modules applicable to financial statements:
incomeStatementHistory
incomeStatementHistoryQuarterly
balanceSheetHistory
balanceSheetHistoryQuarterly
cashflowStatementHistory
cashflowStatementHistoryQuarterly
------------------------------
2. Divide the retrieved data up into words by using the appropriate field
name. In this case:
=smfWord(RCHGetWebData(...),2,"""changeToNetincome"":")
Word "1" would be everything prior to the first occurrence, so you'd want
occurrences 2 thru n. For annual, that 2 thru 4. For quarterly, that's 2
thru 5.
You'd need to figure out the appropriate field names. I don't have a
definitive list.
------------------------------
3. Extract the raw data for the field, and convert the extracted string to
a number (if possible):
=smfConvertData(smfStrExtr(...),"""raw"":",","))
------------------------------
You'd have to check the JSON data to find out the appropriate field names
to use, but doing this might give you most of the field names:
1. Open the SMF-Quick-Webpage-Examination workbook.
2. Go to the "By Cascading Value" worksheet
3. Enter the desired URL in the "Webpage" cell. For example:
https://query1.finance.yahoo.com/v10/finance/quoteSummary/
RY?region=CA&modules=cashflowStatementHistory
4. Put this in the "String" cell:
},"
That should get you a list of something like:
},"netIncome":{"raw":780300000…
},"depreciation":{"raw":115400…
},"changeToNetincome":{"raw":4…
},"changeToLiabilities":{"raw"…
},"changeToOperatingActivities…
},"totalCashFromOperatingActiv…
},"capitalExpenditures":{"raw"…
},"investments":{"raw":-133100…
},"otherCashflowsFromInvesting…
On Tue, Apr 18, 2017 at 6:52 PM, pmanz@
... wrote:
<pmanz@usa.net>
>
>
> Can anybody tell me how to change this to get it working again under new
> Yahoo protocol
>
> =RCHGetTableCell("https://ca.finance.yahoo.com/q/cf?s=" & A1 &
> "&annual",1,"Period Ending","Adjustments To Net Income",,,,"Add to
> Portfolio")
>
> everything using element numbers seems restored with new add in. Many
> thanks Randy
>
does. For example, using the field you asked about:
=smfConvertData(smfstrExtr(smfWord(RCHGetWebData("https:/
/query1.finance.yahoo.com/v10/finance/quoteSummary/RY?region=CA&modules=
cashflowStatementHistory"),2,"""changeToNetincome"":"),"""raw"":",","))
=smfConvertData(smfstrExtr(smfWord(RCHGetWebData("*https://query1.finance.yahoo.com/v10/finance/quoteSummary/RY?region=CA&modules=cashflowStatementHistory
<https://query1.finance.yahoo.com/v10/finance/quoteSummary/RY?region=CA&modules=cashflowStatementHistory>*
"),3,"""changeToNetincome"":"),"""raw"":",","))
=smfConvertData(smfstrExtr(smfWord(RCHGetWebData("https:/
/query1.finance.yahoo.com/v10/finance/quoteSummary/RY?region=CA&modules=
cashflowStatementHistory"),4,"""changeToNetincome"":"),"""raw"":",","))
Step-by-step, that's:
------------------------------
1. Get the raw JSON data for the financial statement:
=RCHGetWebData("https://query1.finance.yahoo.com/v10/
finance/quoteSummary/RY?region=CA&modules=cashflowStatementHistory")
The "region=CA" is what gets Canadian data.
Modules applicable to financial statements:
incomeStatementHistory
incomeStatementHistoryQuarterly
balanceSheetHistory
balanceSheetHistoryQuarterly
cashflowStatementHistory
cashflowStatementHistoryQuarterly
------------------------------
2. Divide the retrieved data up into words by using the appropriate field
name. In this case:
=smfWord(RCHGetWebData(...),2,"""changeToNetincome"":")
Word "1" would be everything prior to the first occurrence, so you'd want
occurrences 2 thru n. For annual, that 2 thru 4. For quarterly, that's 2
thru 5.
You'd need to figure out the appropriate field names. I don't have a
definitive list.
------------------------------
3. Extract the raw data for the field, and convert the extracted string to
a number (if possible):
=smfConvertData(smfStrExtr(...),"""raw"":",","))
------------------------------
You'd have to check the JSON data to find out the appropriate field names
to use, but doing this might give you most of the field names:
1. Open the SMF-Quick-Webpage-Examination workbook.
2. Go to the "By Cascading Value" worksheet
3. Enter the desired URL in the "Webpage" cell. For example:
https://query1.finance.yahoo.com/v10/finance/quoteSummary/
RY?region=CA&modules=cashflowStatementHistory
4. Put this in the "String" cell:
},"
That should get you a list of something like:
},"netIncome":{"raw":780300000…
},"depreciation":{"raw":115400…
},"changeToNetincome":{"raw":4…
},"changeToLiabilities":{"raw"…
},"changeToOperatingActivities…
},"totalCashFromOperatingActiv…
},"capitalExpenditures":{"raw"…
},"investments":{"raw":-133100…
},"otherCashflowsFromInvesting…
On Tue, Apr 18, 2017 at 6:52 PM, pmanz@
... wrote:
<pmanz@usa.net>
>
>
> Can anybody tell me how to change this to get it working again under new
> Yahoo protocol
>
> =RCHGetTableCell("https://ca.finance.yahoo.com/q/cf?s=" & A1 &
> "&annual"
> Portfolio"
>
> everything using element numbers seems restored with new add in. Many
> thanks Randy
>
Wed Apr 19, 2017 4:58 am (PDT) . Posted by:
"Ron Spruell" hashky
Randy -
RCHGetElementNumber 609 and 625 stopped working.
Stock Market Functions add-in, Version 2.1.2017.04.
Ron Spruell
Wed Apr 19, 2017 5:26 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
The following changes were made to my copy of smf-elements-2.txt yesterday:
-- Updated elements #609 to #612 (Current year estimates from Yahoo) on
smf-elements-2.txt, for label changes on web page
-- Obsoleted elements #625 to #632 (Current P/E and PEG ratios from Yahoo)
on smf-elements-2.txt, dropped from web page
I just uploaded that file and the element documentation XLS, although the
web page still lists older dates. I'm waiting to see if more updates need
to be made...
On Wed, Apr 19, 2017 at 4:54 AM, Ron Spruell hashky@
...wrote:
>
> RCHGetElementNumber 609 and 625 stopped working.
>
> Stock Market Functions add-in, Version 2.1.2017.04.17 (C:\SMF Add-In;
> Windows (32-bit) NT 6.01; 14.0; ; Local; 1)
>
>
>
-- Updated elements #609 to #612 (Current year estimates from Yahoo) on
smf-elements-
-- Obsoleted elements #625 to #632 (Current P/E and PEG ratios from Yahoo)
on smf-elements-
I just uploaded that file and the element documentation XLS, although the
web page still lists older dates. I'm waiting to see if more updates need
to be made...
On Wed, Apr 19, 2017 at 4:54 AM, Ron Spruell hashky@
...wrote:
>
> RCHGetElementNumber 609 and 625 stopped working.
>
> Stock Market Functions add-in, Version 2.1.2017.04.
> Windows (32-bit) NT 6.01; 14.0; ; Local; 1)
>
>
>
Wed Apr 19, 2017 6:03 am (PDT) . Posted by:
"Ron Spruell" hashky
Thanks for the quick response..
I guess I will have to calculate the P/E.
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: "Michael Thomas thomas91112@yahoo.com [smf_addin]" <smf_addin@yahoogroups.com>
Sent: Wednesday, April 19, 2017 7:26 AM
Subject: Re: [smf_addin] Yahoo: RCHGetElementNumber
The following changes were made to my copy of smf-elements-2.txt yesterday:
-- Updated elements #609 to #612 (Current year estimates from Yahoo) on smf-elements-2.txt, for label changes on web page
-- Obsoleted elements #625 to #632 (Current P/E and PEG ratios from Yahoo) on smf-elements-2.txt, dropped from web page
I just uploaded that file and the element documentation XLS, although the web page still lists older dates. I'm waiting to see if more updates need to be made...
On Wed, Apr 19, 2017 at 4:54 AM, Ron Spruell hashky@...wrote:
RCHGetElementNumber 609 and 625 stopped working.
Stock Market Functions add-in, Version 2.1.2017.04.17 (C:\SMF Add-In; Windows (32-bit) NT 6.01; 14.0; ; Local; 1)
#yiv0018225404 #yiv0018225404 -- #yiv0018225404ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0018225404 #yiv0018225404ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0018225404 #yiv0018225404ygrp-mkp #yiv0018225404hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0018225404 #yiv0018225404ygrp-mkp #yiv0018225404ads {margin-bottom:10px;}#yiv0018225404 #yiv0018225404ygrp-mkp .yiv0018225404ad {padding:0 0;}#yiv0018225404 #yiv0018225404ygrp-mkp .yiv0018225404ad p {margin:0;}#yiv0018225404 #yiv0018225404ygrp-mkp .yiv0018225404ad a {color:#0000ff;text-decoration:none;}#yiv0018225404 #yiv0018225404ygrp-sponsor #yiv0018225404ygrp-lc {font-family:Arial;}#yiv0018225404 #yiv0018225404ygrp-sponsor #yiv0018225404ygrp-lc #yiv0018225404hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0018225404 #yiv0018225404ygrp-sponsor #yiv0018225404ygrp-lc .yiv0018225404ad {margin-bottom:10px;padding:0 0;}#yiv0018225404 #yiv0018225404actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0018225404 #yiv0018225404activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0018225404 #yiv0018225404activity span {font-weight:700;}#yiv0018225404 #yiv0018225404activity span:first-child {text-transform:uppercase;}#yiv0018225404 #yiv0018225404activity span a {color:#5085b6;text-decoration:none;}#yiv0018225404 #yiv0018225404activity span span {color:#ff7900;}#yiv0018225404 #yiv0018225404activity span .yiv0018225404underline {text-decoration:underline;}#yiv0018225404 .yiv0018225404attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0018225404 .yiv0018225404attach div a {text-decoration:none;}#yiv0018225404 .yiv0018225404attach img {border:none;padding-right:5px;}#yiv0018225404 .yiv0018225404attach label {display:block;margin-bottom:5px;}#yiv0018225404 .yiv0018225404attach label a {text-decoration:none;}#yiv0018225404 blockquote {margin:0 0 0 4px;}#yiv0018225404 .yiv0018225404bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0018225404 .yiv0018225404bold a {text-decoration:none;}#yiv0018225404 dd.yiv0018225404last p a {font-family:Verdana;font-weight:700;}#yiv0018225404 dd.yiv0018225404last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0018225404 dd.yiv0018225404last p span.yiv0018225404yshortcuts {margin-right:0;}#yiv0018225404 div.yiv0018225404attach-table div div a {text-decoration:none;}#yiv0018225404 div.yiv0018225404attach-table {width:400px;}#yiv0018225404 div.yiv0018225404file-title a, #yiv0018225404 div.yiv0018225404file-title a:active, #yiv0018225404 div.yiv0018225404file-title a:hover, #yiv0018225404 div.yiv0018225404file-title a:visited {text-decoration:none;}#yiv0018225404 div.yiv0018225404photo-title a, #yiv0018225404 div.yiv0018225404photo-title a:active, #yiv0018225404 div.yiv0018225404photo-title a:hover, #yiv0018225404 div.yiv0018225404photo-title a:visited {text-decoration:none;}#yiv0018225404 div#yiv0018225404ygrp-mlmsg #yiv0018225404ygrp-msg p a span.yiv0018225404yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0018225404 .yiv0018225404green {color:#628c2a;}#yiv0018225404 .yiv0018225404MsoNormal {margin:0 0 0 0;}#yiv0018225404 o {font-size:0;}#yiv0018225404 #yiv0018225404photos div {float:left;width:72px;}#yiv0018225404 #yiv0018225404photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv0018225404 #yiv0018225404photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0018225404 #yiv0018225404reco-category {font-size:77%;}#yiv0018225404 #yiv0018225404reco-desc {font-size:77%;}#yiv0018225404 .yiv0018225404replbq {margin:4px;}#yiv0018225404 #yiv0018225404ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0018225404 #yiv0018225404ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0018225404 #yiv0018225404ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0018225404 #yiv0018225404ygrp-mlmsg select, #yiv0018225404 input, #yiv0018225404 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0018225404 #yiv0018225404ygrp-mlmsg pre, #yiv0018225404 code {font:115% monospace;}#yiv0018225404 #yiv0018225404ygrp-mlmsg * {line-height:1.22em;}#yiv0018225404 #yiv0018225404ygrp-mlmsg #yiv0018225404logo {padding-bottom:10px;}#yiv0018225404 #yiv0018225404ygrp-msg p a {font-family:Verdana;}#yiv0018225404 #yiv0018225404ygrp-msg p#yiv0018225404attach-count span {color:#1E66AE;font-weight:700;}#yiv0018225404 #yiv0018225404ygrp-reco #yiv0018225404reco-head {color:#ff7900;font-weight:700;}#yiv0018225404 #yiv0018225404ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0018225404 #yiv0018225404ygrp-sponsor #yiv0018225404ov li a {font-size:130%;text-decoration:none;}#yiv0018225404 #yiv0018225404ygrp-sponsor #yiv0018225404ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0018225404 #yiv0018225404ygrp-sponsor #yiv0018225404ov ul {margin:0;padding:0 0 0 8px;}#yiv0018225404 #yiv0018225404ygrp-text {font-family:Georgia;}#yiv0018225404 #yiv0018225404ygrp-text p {margin:0 0 1em 0;}#yiv0018225404 #yiv0018225404ygrp-text tt {font-size:120%;}#yiv0018225404 #yiv0018225404ygrp-vital ul li:last-child {border-right:none !important;}#yiv0018225404
I guess I will have to calculate the P/E.
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: "Michael Thomas thomas91112@yahoo.com [smf_addin]" <smf_addin@yahoogroups.com>
Sent: Wednesday, April 19, 2017 7:26 AM
Subject: Re: [smf_addin] Yahoo: RCHGetElementNumber
The following changes were made to my copy of smf-elements-
-- Updated elements #609 to #612 (Current year estimates from Yahoo) on smf-elements-
-- Obsoleted elements #625 to #632 (Current P/E and PEG ratios from Yahoo) on smf-elements-
I just uploaded that file and the element documentation XLS, although the web page still lists older dates. I'm waiting to see if more updates need to be made...
On Wed, Apr 19, 2017 at 4:54 AM, Ron Spruell hashky@...wrote:
RCHGetElementNumber 609 and 625 stopped working.
Stock Market Functions add-in, Version 2.1.2017.04.
#yiv0018225404 #yiv0018225404 -- #yiv0018225404ygrp-
Wed Apr 19, 2017 5:19 am (PDT) . Posted by:
mg4aef7j4zwa2y7zzws4cqaegxt5dnnipddqjrk4
We have a client who is having problems with the latest SMF addin.
At first no data was coming through until we saw there was a recent update, which has since been installed and confirmed to be working.
However the client has noticed that the data given is out of date. The most recent data is from 10 April.
The client can get the spreadsheet to update its data by doing the following:
-Untick and renable the SMF addin in Excel
-Ctrl+shift+enter on the date column in the affected array. This updates the values.*
Saving/Closing and reopening the document shows the data continues to not be updated.
*When this is done the formula changes from a long string to short forumla
i.e. ='<path-to-addin>'!RCHGetYahooHistory("SCLP.L") to =RCHGetYahooHistory("SCLP.L")
End User Details
Windows 7 Professional
Excel Professional 2010 (14.0.7173.5000, 32-bit)
Unfortuntley we did not design the spreadsheet and are not sure where, if any, changes need to be made. Can anyone please assist us in understanding why the add-in is not behaving correctly?
At first no data was coming through until we saw there was a recent update, which has since been installed and confirmed to be working.
However the client has noticed that the data given is out of date. The most recent data is from 10 April.
The client can get the spreadsheet to update its data by doing the following:
-Untick and renable the SMF addin in Excel
-Ctrl+shift+
Saving/Closing and reopening the document shows the data continues to not be updated.
*When this is done the formula changes from a long string to short forumla
i.e. ='<path-
End User Details
Windows 7 Professional
Excel Professional 2010 (14.0.7173.5000, 32-bit)
Unfortuntley we did not design the spreadsheet and are not sure where, if any, changes need to be made. Can anyone please assist us in understanding why the add-in is not behaving correctly?
Wed Apr 19, 2017 6:08 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
When a path is in front of the function, it means there was a location
error. I suspect when the latest version of the add-in was installed, it
was not installed into the same location as when the workbook in question
was saved.
This happens because EXCEL saves the hard-coded location of the add-in for
its functions whenever a workbook is saved. Later, when the workbook is
opened, if that saved location doesn't match the current location of the
add-in as defined by the add-in manager, EXCEL tags the function as an
unresolved link and leaves the path on the function. If everything is
consistent, it removes the hard-coded path from the function.
A quick fix is to run the smfFixLinks macro that is part of the add-in. I
have this on my Quick Access Toolbar, because I see a lot of workbooks
where the add-in was installed in a location other than that currently
recommended in the installation instructions.
Once the workbook is saved, the problem should not reappear when the
workbook is opened again. UNLESS the add-in is moved again. :(
On Wed, Apr 19, 2017 at 4:13 AM,
mg4aef7j4zwa2y7zzws4cqaegxt5dnnipddqjrk4@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> We have a client who is having problems with the latest SMF addin.
>
> At first no data was coming through until we saw there was a recent
> update, which has since been installed and confirmed to be working.
>
> However the client has noticed that the data given is out of date. The
> most recent data is from 10 April.
>
> The client can get the spreadsheet to update its data by doing the
> following:
>
> -Untick and renable the SMF addin in Excel
> -Ctrl+shift+enter on the date column in the affected array. This updates
> the values.*
>
> Saving/Closing and reopening the document shows the data continues to not
> be updated.
>
> *When this is done the formula changes from a long string to short forumla
>
> i.e. ='<path-to-addin>'!RCHGetYahooHistory("SCLP.L") to
> =RCHGetYahooHistory("SCLP.L")
>
> End User Details
>
> Windows 7 Professional
> Excel Professional 2010 (14.0.7173.5000, 32-bit)
>
> Unfortuntley we did not design the spreadsheet and are not sure where, if
> any, changes need to be made. Can anyone please assist us in understanding
> why the add-in is not behaving correctly?
>
>
error. I suspect when the latest version of the add-in was installed, it
was not installed into the same location as when the workbook in question
was saved.
This happens because EXCEL saves the hard-coded location of the add-in for
its functions whenever a workbook is saved. Later, when the workbook is
opened, if that saved location doesn't match the current location of the
add-in as defined by the add-in manager, EXCEL tags the function as an
unresolved link and leaves the path on the function. If everything is
consistent, it removes the hard-coded path from the function.
A quick fix is to run the smfFixLinks macro that is part of the add-in. I
have this on my Quick Access Toolbar, because I see a lot of workbooks
where the add-in was installed in a location other than that currently
recommended in the installation instructions.
Once the workbook is saved, the problem should not reappear when the
workbook is opened again. UNLESS the add-in is moved again. :(
On Wed, Apr 19, 2017 at 4:13 AM,
mg4aef7j4zwa2y7zzws4cqaegxt5dnnipddqjrk4@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> We have a client who is having problems with the latest SMF addin.
>
> At first no data was coming through until we saw there was a recent
> update, which has since been installed and confirmed to be working.
>
> However the client has noticed that the data given is out of date. The
> most recent data is from 10 April.
>
> The client can get the spreadsheet to update its data by doing the
> following:
>
> -Untick and renable the SMF addin in Excel
> -Ctrl+shift+
> the values.*
>
> Saving/Closing and reopening the document shows the data continues to not
> be updated.
>
> *When this is done the formula changes from a long string to short forumla
>
> i.e. ='<path-
> =RCHGetYahooHistory
>
> End User Details
>
> Windows 7 Professional
> Excel Professional 2010 (14.0.7173.5000, 32-bit)
>
> Unfortuntley we did not design the spreadsheet and are not sure where, if
> any, changes need to be made. Can anyone please assist us in understanding
> why the add-in is not behaving correctly?
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar