15 Messages
Digest #4188
Messages
Tue Oct 31, 2017 8:24 pm (PDT) . Posted by:
joelfp2000
Randy,
Thanks! I got it to work just fine looking for the 1,3 and 5 year category rankings!
I appreciate all of your help.
Happy Halloween!
Joel
Thanks! I got it to work just fine looking for the 1,3 and 5 year category rankings!
I appreciate all of your help.
Happy Halloween!
Joel
Tue Oct 31, 2017 8:48 pm (PDT) . Posted by:
"Omar Jaleel" saanajaleel
Is it possible to pull this? I am trying to get the EUR/USD monthly price
for the past 10 years.
Here is the site that I am using:
https://www.investing.com/currencies/eur-usd-historical-data
This is the formula that I am using: =RCHGetHTMLTable("
https://www.investing.com/currencies/eur-usd-historical-data",">Monthly)
The formula pulls daily data for the past month regardless of how I modify
it.
Thanks for you help.
--
for the past 10 years.
Here is the site that I am using:
https://www.investing.com/currencies/eur-usd-historical-data
This is the formula that I am using: =RCHGetHTMLTable("
https://www.investing.com/currencies/eur-usd-historical-data","
The formula pulls daily data for the past month regardless of how I modify
it.
Thanks for you help.
--
Wed Nov 1, 2017 1:45 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
You need a bookmarkable URL so the web page contains the data. The URL you
are using only has the daily data.
They do a POST request to an AJAX file to get the data, but I don't see a
way to intercept it with the add-in.
On Tue, Oct 31, 2017 at 8:48 PM, Omar Jaleel omar.jaleel@
...
wrote:
>
> Is it possible to pull this? I am trying to get the EUR/USD monthly price
> for the past 10 years.
>
> Here is the site that I am using: https://www.investing.com/
> currencies/eur-usd-historical-data
>
> This is the formula that I am using: =RCHGetHTMLTable("https://www.
> investing.com/currencies/eur-usd-historical-data",">Monthly)
>
> The formula pulls daily data for the past month regardless of how I modify
> it.
>
>
>
are using only has the daily data.
They do a POST request to an AJAX file to get the data, but I don't see a
way to intercept it with the add-in.
On Tue, Oct 31, 2017 at 8:48 PM, Omar Jaleel omar.jaleel@
...
wrote:
>
> Is it possible to pull this? I am trying to get the EUR/USD monthly price
> for the past 10 years.
>
> Here is the site that I am using: https://www.investing.com/
> currencies/eur-usd-historical-data
>
> This is the formula that I am using: =RCHGetHTMLTable("https://www.
> investing.com/
>
> The formula pulls daily data for the past month regardless of how I modify
> it.
>
>
>
Wed Nov 1, 2017 12:29 am (PDT) . Posted by:
zbgb952
Randy...
I did a search of my computer and it cannot find the smffixlinks macro. Where is it found? Can I download it from somewhere?...and if so, where? And then how do I set it up?
Currently, when I click Alt-f8 it does not show up. In fact the box that shows up is blank!!!
What is going on?
I recently clicked a button in Excel that supposedly updated it. Could that have created the problem?
Thanks.
I did a search of my computer and it cannot find the smffixlinks macro. Where is it found? Can I download it from somewhere?..
Currently, when I click Alt-f8 it does not show up. In fact the box that shows up is blank!!!
What is going on?
I recently clicked a button in Excel that supposedly updated it. Could that have created the problem?
Thanks.
Wed Nov 1, 2017 1:25 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
It's within the add-in. Alt+F8 only shows you macros in open workbooks, not
those from add-ins. You'd have to type the name in yourself, and then the
greyed out buttons should activate.
On Wed, Nov 1, 2017 at 12:29 AM, mb0329@
...
wrote:
>
> I did a search of my computer and it cannot find the smffixlinks macro.
> Where is it found? Can I download it from somewhere?...and if so, where?
> And then how do I set it up?
>
> Currently, when I click Alt-f8 it does not show up. In fact the box that
> shows up is blank!!!
>
> What is going on?
>
> I recently clicked a button in Excel that supposedly updated it. Could
> that have created the problem?
>
>
those from add-ins. You'd have to type the name in yourself, and then the
greyed out buttons should activate.
On Wed, Nov 1, 2017 at 12:29 AM, mb0329@
...
wrote:
>
> I did a search of my computer and it cannot find the smffixlinks macro.
> Where is it found? Can I download it from somewhere?..
> And then how do I set it up?
>
> Currently, when I click Alt-f8 it does not show up. In fact the box that
> shows up is blank!!!
>
> What is going on?
>
> I recently clicked a button in Excel that supposedly updated it. Could
> that have created the problem?
>
>
Wed Nov 1, 2017 5:21 am (PDT) . Posted by:
brad.reel
Anyone having problems pulling IBD data this morning or yesterday? I was able to pull data on Monday, but could not get anything last night or this morning. I checked and I am logged in to IBD site. I pulled up IE browser within Excel and confirmed. I was also able to get to the stock check-up page via the IE browser in Excel. I didn't have time to pull down the IBD template from Randy's site and test that before I left for work. Was just curious if anyone else was experiencing issues.
Wed Nov 1, 2017 8:12 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Did you update your element definitions?
https://smf-add-in.blogspot.com/
On Wed, Nov 1, 2017 at 5:21 AM, brad.reel@
...
wrote:
> Anyone having problems pulling IBD data this morning or yesterday? I was
> able to pull data on Monday, but could not get anything last night or this
> morning. I checked and I am logged in to IBD site. I pulled up IE browser
> within Excel and confirmed. I was also able to get to the stock check-up
> page via the IE browser in Excel. I didn't have time to pull down the IBD
> template from Randy's site and test that before I left for work. Was just
> curious if anyone else was experiencing issues.
>
https://smf-add-in.blogspot.com/
On Wed, Nov 1, 2017 at 5:21 AM, brad.reel@
...
wrote:
> Anyone having problems pulling IBD data this morning or yesterday? I was
> able to pull data on Monday, but could not get anything last night or this
> morning. I checked and I am logged in to IBD site. I pulled up IE browser
> within Excel and confirmed. I was also able to get to the stock check-up
> page via the IE browser in Excel. I didn't have time to pull down the IBD
> template from Randy's site and test that before I left for work. Was just
> curious if anyone else was experiencing issues.
>
Wed Nov 1, 2017 8:16 am (PDT) . Posted by:
"Brad Reel" reeldeal9090
Ummm...no :) Somehow I missed that communication! I looked back through
the conversations over the last couple of days and didn't see anything on
IBD. My bad. Thanks, Randy.
On Wed, Nov 1, 2017 at 10:12 AM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> Did you update your element definitions?
>
> https://smf-add-in.blogspot.com/
>
> On Wed, Nov 1, 2017 at 5:21 AM, brad.reel@
> ...
> wrote:
>
>> Anyone having problems pulling IBD data this morning or yesterday? I was
>> able to pull data on Monday, but could not get anything last night or this
>> morning. I checked and I am logged in to IBD site. I pulled up IE browser
>> within Excel and confirmed. I was also able to get to the stock check-up
>> page via the IE browser in Excel. I didn't have time to pull down the IBD
>> template from Randy's site and test that before I left for work. Was just
>> curious if anyone else was experiencing issues.
>>
>
>
>
the conversations over the last couple of days and didn't see anything on
IBD. My bad. Thanks, Randy.
On Wed, Nov 1, 2017 at 10:12 AM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> Did you update your element definitions?
>
> https://smf-add-in.blogspot.com/
>
> On Wed, Nov 1, 2017 at 5:21 AM, brad.reel@
> ...
> wrote:
>
>> Anyone having problems pulling IBD data this morning or yesterday? I was
>> able to pull data on Monday, but could not get anything last night or this
>> morning. I checked and I am logged in to IBD site. I pulled up IE browser
>> within Excel and confirmed. I was also able to get to the stock check-up
>> page via the IE browser in Excel. I didn't have time to pull down the IBD
>> template from Randy's site and test that before I left for work. Was just
>> curious if anyone else was experiencing issues.
>>
>
>
>
Wed Nov 1, 2017 6:54 am (PDT) . Posted by:
"Jonathan" jbr863
Hey Randy, I've tried this a few times and am not getting the same results as you. When I open the spreadsheet to which you linked me and enter "AGX", this is the result:
I have attached the full spreadsheet for your reference and, as a note, just updated to the 9/17 version of SMF a week or two ago. Any ideas on why I'm getting "Fiscal Period" instead of the numerical values for EV?
On Thursday, October 26, 2017, 2:20:14 AM PDT, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
You should use the template from the web site to get the item numbers:
smfGetGuruFocusItem-Full-Template.xls
Both Free Cash Flow and Enterprise Value seem to be working for AGX when I try it there:
| AGX | | | |
| | | | |
| Fiscal Period | Jan03 | Jan04 | Jan05 |
| Free Cash Flow | 0.2 | -0.7 | -2.5 |
| Enterprise Value | 3.7 | 5.3 | 18.2 |
GuruFocus must have added the "Net-Net" line item since I wrote the routine originally.
Are you a subscriber to GuruFocus? The next release of the add-in will be able to extract data from the 30-year CSV file. For example, something like:
=smfGetGuruFocusCSVItem("AGX","Net-Net Working Capital",2)
That last parameter can be 1 thru 153 or "A29" thru "A0" or "TTM" or "Q119" thru "Q0". For example:
| Line Item | 2 | 31 | 32 | 34 | 153 | | A29 | A0 | TTM | Q119 | Q0 |
| Fiscal Period | 198701 | 201701 | TTM/current | 198404 | 201707 | | 198701 | 201701 | TTM/current | 198404 | 201707 |
| Net-Net Working Capital | 0 | 13.68 | 16.45 | 0 | 16.45 | | 0 | 13.68 | 16.45 | 0 | 16.45 |
Much quicker and a lot more data. Of course, the quickest way to get all of the data would simply be:
=smfGetCSVFile("https://www.gurufocus.com/download_financials_in_CSV.php?symbol=AGX")
It's a lot of data! :)
On Wed, Oct 25, 2017 at 9:07 PM, Jonathan jbr863@... wrote:
smfGetGuruFocusItem worked for Free Cash Flow (Item # 137) but not for Enterprise Value (Item # 151) and Net Net Working Capital (no Item # was included). I got the item numbers from the smfLoadGuruFocusItems2 function. I got the item numbers for the smfGetGuruFocusData function from smfLoadGuruFocusItems.
On Wednesday, October 25, 2017, 1:45:26 PM PDT, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote: Try using smfGetGuruFocusItem() instead. smfGetGuruFocusData() is an older version of that routine and was never really mentioned other than in the add-in change log? Or did I announce it? Where did you get the #203 and #41?
On Wed, Oct 25, 2017 at 7:27 AM, jbr863@... wrote:
When I tried smfGetGuruFocusData(" AGX", 203, "Y") recently, where Item # 203 represents Free Cash Flow, it just returned the company name. From what I can tell the URL is forming correctly so it may be something in the extract and data processing lines.
I believe that I'm seeing a similar issue with Net Net Working Capital (Item # 41). Your help in figuring out why it's not pulling the correct numerical data will be appreciated, as always.
#yiv8174081611 #yiv8174081611 -- #yiv8174081611ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8174081611 #yiv8174081611ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8174081611 #yiv8174081611ygrp-mkp #yiv8174081611hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8174081611 #yiv8174081611ygrp-mkp #yiv8174081611ads {margin-bottom:10px;}#yiv8174081611 #yiv8174081611ygrp-mkp .yiv8174081611ad {padding:0 0;}#yiv8174081611 #yiv8174081611ygrp-mkp .yiv8174081611ad p {margin:0;}#yiv8174081611 #yiv8174081611ygrp-mkp .yiv8174081611ad a {color:#0000ff;text-decoration:none;}#yiv8174081611 #yiv8174081611ygrp-sponsor #yiv8174081611ygrp-lc {font-family:Arial;}#yiv8174081611 #yiv8174081611ygrp-sponsor #yiv8174081611ygrp-lc #yiv8174081611hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8174081611 #yiv8174081611ygrp-sponsor #yiv8174081611ygrp-lc .yiv8174081611ad {margin-bottom:10px;padding:0 0;}#yiv8174081611 #yiv8174081611actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8174081611 #yiv8174081611activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8174081611 #yiv8174081611activity span {font-weight:700;}#yiv8174081611 #yiv8174081611activity span:first-child {text-transform:uppercase;}#yiv8174081611 #yiv8174081611activity span a {color:#5085b6;text-decoration:none;}#yiv8174081611 #yiv8174081611activity span span {color:#ff7900;}#yiv8174081611 #yiv8174081611activity span .yiv8174081611underline {text-decoration:underline;}#yiv8174081611 .yiv8174081611attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8174081611 .yiv8174081611attach div a {text-decoration:none;}#yiv8174081611 .yiv8174081611attach img {border:none;padding-right:5px;}#yiv8174081611 .yiv8174081611attach label {display:block;margin-bottom:5px;}#yiv8174081611 .yiv8174081611attach label a {text-decoration:none;}#yiv8174081611 blockquote {margin:0 0 0 4px;}#yiv8174081611 .yiv8174081611bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8174081611 .yiv8174081611bold a {text-decoration:none;}#yiv8174081611 dd.yiv8174081611last p a {font-family:Verdana;font-weight:700;}#yiv8174081611 dd.yiv8174081611last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8174081611 dd.yiv8174081611last p span.yiv8174081611yshortcuts {margin-right:0;}#yiv8174081611 div.yiv8174081611attach-table div div a {text-decoration:none;}#yiv8174081611 div.yiv8174081611attach-table {width:400px;}#yiv8174081611 div.yiv8174081611file-title a, #yiv8174081611 div.yiv8174081611file-title a:active, #yiv8174081611 div.yiv8174081611file-title a:hover, #yiv8174081611 div.yiv8174081611file-title a:visited {text-decoration:none;}#yiv8174081611 div.yiv8174081611photo-title a, #yiv8174081611 div.yiv8174081611photo-title a:active, #yiv8174081611 div.yiv8174081611photo-title a:hover, #yiv8174081611 div.yiv8174081611photo-title a:visited {text-decoration:none;}#yiv8174081611 div#yiv8174081611ygrp-mlmsg #yiv8174081611ygrp-msg p a span.yiv8174081611yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8174081611 .yiv8174081611green {color:#628c2a;}#yiv8174081611 .yiv8174081611MsoNormal {margin:0 0 0 0;}#yiv8174081611 o {font-size:0;}#yiv8174081611 #yiv8174081611photos div {float:left;width:72px;}#yiv8174081611 #yiv8174081611photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv8174081611 #yiv8174081611photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8174081611 #yiv8174081611reco-category {font-size:77%;}#yiv8174081611 #yiv8174081611reco-desc {font-size:77%;}#yiv8174081611 .yiv8174081611replbq {margin:4px;}#yiv8174081611 #yiv8174081611ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8174081611 #yiv8174081611ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8174081611 #yiv8174081611ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8174081611 #yiv8174081611ygrp-mlmsg select, #yiv8174081611 input, #yiv8174081611 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8174081611 #yiv8174081611ygrp-mlmsg pre, #yiv8174081611 code {font:115% monospace;}#yiv8174081611 #yiv8174081611ygrp-mlmsg * {line-height:1.22em;}#yiv8174081611 #yiv8174081611ygrp-mlmsg #yiv8174081611logo {padding-bottom:10px;}#yiv8174081611 #yiv8174081611ygrp-msg p a {font-family:Verdana;}#yiv8174081611 #yiv8174081611ygrp-msg p#yiv8174081611attach-count span {color:#1E66AE;font-weight:700;}#yiv8174081611 #yiv8174081611ygrp-reco #yiv8174081611reco-head {color:#ff7900;font-weight:700;}#yiv8174081611 #yiv8174081611ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8174081611 #yiv8174081611ygrp-sponsor #yiv8174081611ov li a {font-size:130%;text-decoration:none;}#yiv8174081611 #yiv8174081611ygrp-sponsor #yiv8174081611ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8174081611 #yiv8174081611ygrp-sponsor #yiv8174081611ov ul {margin:0;padding:0 0 0 8px;}#yiv8174081611 #yiv8174081611ygrp-text {font-family:Georgia;}#yiv8174081611 #yiv8174081611ygrp-text p {margin:0 0 1em 0;}#yiv8174081611 #yiv8174081611ygrp-text tt {font-size:120%;}#yiv8174081611 #yiv8174081611ygrp-vital ul li:last-child {border-right:none !important;}#yiv8174081611
I have attached the full spreadsheet for your reference and, as a note, just updated to the 9/17 version of SMF a week or two ago. Any ideas on why I'm getting "Fiscal Period" instead of the numerical values for EV?
On Thursday, October 26, 2017, 2:20:14 AM PDT, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
You should use the template from the web site to get the item numbers:
smfGetGuruFocusItem-Full-Template.xls
Both Free Cash Flow and Enterprise Value seem to be working for AGX when I try it there:
| AGX | | | |
| | | | |
| Fiscal Period | Jan03 | Jan04 | Jan05 |
| Free Cash Flow | 0.2 | -0.7 | -2.5 |
| Enterprise Value | 3.7 | 5.3 | 18.2 |
GuruFocus must have added the "Net-Net" line item since I wrote the routine originally.
Are you a subscriber to GuruFocus? The next release of the add-in will be able to extract data from the 30-year CSV file. For example, something like:
=smfGetGuruFocusCSVItem("AGX","Net-Net Working Capital",2)
That last parameter can be 1 thru 153 or "A29" thru "A0" or "TTM" or "Q119" thru "Q0". For example:
| Line Item | 2 | 31 | 32 | 34 | 153 | | A29 | A0 | TTM | Q119 | Q0 |
| Fiscal Period | 198701 | 201701 | TTM/current | 198404 | 201707 | | 198701 | 201701 | TTM/current | 198404 | 201707 |
| Net-Net Working Capital | 0 | 13.68 | 16.45 | 0 | 16.45 | | 0 | 13.68 | 16.45 | 0 | 16.45 |
Much quicker and a lot more data. Of course, the quickest way to get all of the data would simply be:
=smfGetCSVFile("https://www.gurufocus.com/download_financials_in_CSV.php?symbol=AGX")
It's a lot of data! :)
On Wed, Oct 25, 2017 at 9:07 PM, Jonathan jbr863@... wrote:
smfGetGuruFocusItem worked for Free Cash Flow (Item # 137) but not for Enterprise Value (Item # 151) and Net Net Working Capital (no Item # was included). I got the item numbers from the smfLoadGuruFocusItems2 function. I got the item numbers for the smfGetGuruFocusData function from smfLoadGuruFocusItems.
On Wednesday, October 25, 2017, 1:45:26 PM PDT, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote: Try using smfGetGuruFocusItem
On Wed, Oct 25, 2017 at 7:27 AM, jbr863@... wrote:
When I tried smfGetGuruFocu
I believe that I'm seeing a similar issue with Net Net Working Capital (Item # 41). Your help in figuring out why it's not pulling the correct numerical data will be appreciated, as always.
#yiv8174081611 #yiv8174081611 -- #yiv8174081611ygrp-
Attachment(s) from Jonathan
1 of 1 File(s)
Wed Nov 1, 2017 8:40 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I don't see an image, if that's what you intended to show? The attachment
worked fine for me.
What do you get with:
=RCHGetElementNumber("Version")
=smfGetGuruFocusItem("AGX",137, "TTM",0)
=smfConvertData(smfGetTagContent("https://www.gurufocus.com/financials/AGX",
"div", -1, "id=""Rf""", "/term/total_freecashflow/", "yesttm"))
That last formula is what the smfGetGuruFocusItem() function is supposed
to be doing.
On Wed, Nov 1, 2017 at 6:54 AM, Jonathan jbr863@
...
wrote:
>
> I've tried this a few times and am not getting the same results as
> you. When I open the spreadsheet to which you linked me and enter "AGX",
> this is the result:
> [image: Inline image]
>
> I have attached the full spreadsheet for your reference and, as a note,
> just updated to the 9/17 version of SMF a week or two ago. Any ideas on
> why I'm getting "Fiscal Period" instead of the numerical values for EV?
>
>
>
worked fine for me.
What do you get with:
=RCHGetElementNumber("Version")
=smfGetGuruFocusItem("AGX",137, "TTM",0)
=smfConvertData(smfGetTagContent("https://www.gurufocus.com/financials/AGX",
"div"
That last formula is what the smfGetGuruFocusItem
to be doing.
On Wed, Nov 1, 2017 at 6:54 AM, Jonathan jbr863@
...
wrote:
>
> I've tried this a few times and am not getting the same results as
> you. When I open the spreadsheet to which you linked me and enter "AGX"
> this is the result:
> [image: Inline image]
>
> I have attached the full spreadsheet for your reference and, as a note,
> just updated to the 9/17 version of SMF a week or two ago. Any ideas on
> why I'm getting "Fiscal Period" instead of the numerical values for EV?
>
>
>
Wed Nov 1, 2017 10:16 am (PDT) . Posted by:
"Jonathan" jbr863
I don't know why the image got removed in my last email but I have included it as an attachment.
Free Cash Flow works fine (Item # 137) - hopefully the image comes through this time. The last two formulae correctly return TTM FCF as $176.90.
When I change the bottom two formulae to call item #151(Enterprise Value), the bottom two formulae return TTM EV as "Error":
| =RCHGetElementNumber("Version") | Stock Market Functions add-in, Version 2.1.2017.09.17 (C:\SMF Add-In; Windows (32-bit) NT 6.01; 15.0; ; ; 1) |
| =smfGetGuruFocusItem("AGX",151, "TTM",0) | Error |
| =smfConvertData(smfGetTagContent("https://www.gurufocus.com/financials/AGX", "div", -1, "id=""Rf""", "/term/ev/", "yesttm")) | Error |
On Wednesday, November 1, 2017, 8:44:33 AM PDT, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
I don't see an image, if that's what you intended to show? The attachment worked fine for me.
What do you get with:
=RCHGetElementNumber("Version")
=smfGetGuruFocusItem("AGX",137, "TTM",0)
=smfConvertData(smfGetTagContent("https://www.gurufocus.com/financials/AGX", "div", -1, "id=""Rf""", "/term/total_freecashflow/", "yesttm"))
That last formula is what the smfGetGuruFocusItem() function is supposed to be doing.
On Wed, Nov 1, 2017 at 6:54 AM, Jonathan jbr863@... wrote:
I've tried this a few times and am not getting the same results as you. When I open the spreadsheet to which you linked me and enter "AGX", this is the result:
I have attached the full spreadsheet for your reference and, as a note, just updated to the 9/17 version of SMF a week or two ago. Any ideas on why I'm getting "Fiscal Period" instead of the numerical values for EV?
#yiv2579469698 -- #yiv2579469698ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2579469698 #yiv2579469698ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2579469698 #yiv2579469698ygrp-mkp #yiv2579469698hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2579469698 #yiv2579469698ygrp-mkp #yiv2579469698ads {margin-bottom:10px;}#yiv2579469698 #yiv2579469698ygrp-mkp .yiv2579469698ad {padding:0 0;}#yiv2579469698 #yiv2579469698ygrp-mkp .yiv2579469698ad p {margin:0;}#yiv2579469698 #yiv2579469698ygrp-mkp .yiv2579469698ad a {color:#0000ff;text-decoration:none;}#yiv2579469698 #yiv2579469698ygrp-sponsor #yiv2579469698ygrp-lc {font-family:Arial;}#yiv2579469698 #yiv2579469698ygrp-sponsor #yiv2579469698ygrp-lc #yiv2579469698hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2579469698 #yiv2579469698ygrp-sponsor #yiv2579469698ygrp-lc .yiv2579469698ad {margin-bottom:10px;padding:0 0;}#yiv2579469698 #yiv2579469698actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2579469698 #yiv2579469698activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2579469698 #yiv2579469698activity span {font-weight:700;}#yiv2579469698 #yiv2579469698activity span:first-child {text-transform:uppercase;}#yiv2579469698 #yiv2579469698activity span a {color:#5085b6;text-decoration:none;}#yiv2579469698 #yiv2579469698activity span span {color:#ff7900;}#yiv2579469698 #yiv2579469698activity span .yiv2579469698underline {text-decoration:underline;}#yiv2579469698 .yiv2579469698attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2579469698 .yiv2579469698attach div a {text-decoration:none;}#yiv2579469698 .yiv2579469698attach img {border:none;padding-right:5px;}#yiv2579469698 .yiv2579469698attach label {display:block;margin-bottom:5px;}#yiv2579469698 .yiv2579469698attach label a {text-decoration:none;}#yiv2579469698 blockquote {margin:0 0 0 4px;}#yiv2579469698 .yiv2579469698bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2579469698 .yiv2579469698bold a {text-decoration:none;}#yiv2579469698 dd.yiv2579469698last p a {font-family:Verdana;font-weight:700;}#yiv2579469698 dd.yiv2579469698last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2579469698 dd.yiv2579469698last p span.yiv2579469698yshortcuts {margin-right:0;}#yiv2579469698 div.yiv2579469698attach-table div div a {text-decoration:none;}#yiv2579469698 div.yiv2579469698attach-table {width:400px;}#yiv2579469698 div.yiv2579469698file-title a, #yiv2579469698 div.yiv2579469698file-title a:active, #yiv2579469698 div.yiv2579469698file-title a:hover, #yiv2579469698 div.yiv2579469698file-title a:visited {text-decoration:none;}#yiv2579469698 div.yiv2579469698photo-title a, #yiv2579469698 div.yiv2579469698photo-title a:active, #yiv2579469698 div.yiv2579469698photo-title a:hover, #yiv2579469698 div.yiv2579469698photo-title a:visited {text-decoration:none;}#yiv2579469698 div#yiv2579469698ygrp-mlmsg #yiv2579469698ygrp-msg p a span.yiv2579469698yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2579469698 .yiv2579469698green {color:#628c2a;}#yiv2579469698 .yiv2579469698MsoNormal {margin:0 0 0 0;}#yiv2579469698 o {font-size:0;}#yiv2579469698 #yiv2579469698photos div {float:left;width:72px;}#yiv2579469698 #yiv2579469698photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv2579469698 #yiv2579469698photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2579469698 #yiv2579469698reco-category {font-size:77%;}#yiv2579469698 #yiv2579469698reco-desc {font-size:77%;}#yiv2579469698 .yiv2579469698replbq {margin:4px;}#yiv2579469698 #yiv2579469698ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2579469698 #yiv2579469698ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2579469698 #yiv2579469698ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2579469698 #yiv2579469698ygrp-mlmsg select, #yiv2579469698 input, #yiv2579469698 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2579469698 #yiv2579469698ygrp-mlmsg pre, #yiv2579469698 code {font:115% monospace;}#yiv2579469698 #yiv2579469698ygrp-mlmsg * {line-height:1.22em;}#yiv2579469698 #yiv2579469698ygrp-mlmsg #yiv2579469698logo {padding-bottom:10px;}#yiv2579469698 #yiv2579469698ygrp-msg p a {font-family:Verdana;}#yiv2579469698 #yiv2579469698ygrp-msg p#yiv2579469698attach-count span {color:#1E66AE;font-weight:700;}#yiv2579469698 #yiv2579469698ygrp-reco #yiv2579469698reco-head {color:#ff7900;font-weight:700;}#yiv2579469698 #yiv2579469698ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2579469698 #yiv2579469698ygrp-sponsor #yiv2579469698ov li a {font-size:130%;text-decoration:none;}#yiv2579469698 #yiv2579469698ygrp-sponsor #yiv2579469698ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2579469698 #yiv2579469698ygrp-sponsor #yiv2579469698ov ul {margin:0;padding:0 0 0 8px;}#yiv2579469698 #yiv2579469698ygrp-text {font-family:Georgia;}#yiv2579469698 #yiv2579469698ygrp-text p {margin:0 0 1em 0;}#yiv2579469698 #yiv2579469698ygrp-text tt {font-size:120%;}#yiv2579469698 #yiv2579469698ygrp-vital ul li:last-child {border-right:none !important;}#yiv2579469698
Free Cash Flow works fine (Item # 137) - hopefully the image comes through this time. The last two formulae correctly return TTM FCF as $176.90.
When I change the bottom two formulae to call item #151(Enterprise Value), the bottom two formulae return TTM EV as "Error":
| =RCHGetElementNumber("Version") | Stock Market Functions add-in, Version 2.1.2017.09.17 (C:\SMF Add-In; Windows (32-bit) NT 6.01; 15.0; ; ; 1) |
| =smfGetGuruFocusItem("AGX",151, "TTM",0) | Error |
| =smfConvertData(smfGetTagContent("https://www.gurufocus.com/financials/AGX", "div", -1, "id=""Rf""", "/term/ev/", "yesttm")) | Error |
On Wednesday, November 1, 2017, 8:44:33 AM PDT, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
I don't see an image, if that's what you intended to show? The attachment worked fine for me.
What do you get with:
=RCHGetElementNumber("Version")
=smfGetGuruFocusItem("AGX",137, "TTM",0)
=smfConvertData(smfGetTagContent("https://www.gurufocus.com/financials/AGX", "div"
That last formula is what the smfGetGuruFocusItem
On Wed, Nov 1, 2017 at 6:54 AM, Jonathan jbr863@... wrote:
I've tried this a few times and am not getting the same results as you. When I open the spreadsheet to which you linked me and enter "AGX"
I have attached the full spreadsheet for your reference and, as a note, just updated to the 9/17 version of SMF a week or two ago. Any ideas on why I'm getting "Fiscal Period" instead of the numerical values for EV?
#yiv2579469698 -- #yiv2579469698ygrp-
Attachment(s) from Jonathan
3 of 3 Photo(s)
Wed Nov 1, 2017 10:40 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Based on your results, I'd say you weren't logged in (i.e. no security
cookie for the IE object that EXCEL uses). That would allow the "TTM" for
"Free Cash Flow" to be returned, but not return a value for "Enterprise
Value".
To check, what do you get with:
=RCHGetWebData("https://www.gurufocus.com/new_index/","Premium Member
until",75)
I get:
Premium Member until 2018-01-11) , which covers <b>USA</b>.. <a href=https:
On Wed, Nov 1, 2017 at 10:11 AM, Jonathan jbr863@
...
wrote:
>
> I don't know why the image got removed in my last email but I have
> included it as an attachment.
>
> Free Cash Flow works fine (Item # 137) - hopefully the image comes through
> this time. The last two formulae correctly return TTM FCF as $176.90.
>
> [image: Inline image]
>
> When I change the bottom two formulae to call item #151(Enterprise Value),
> the bottom two formulae return TTM EV as "Error":
> =RCHGetElementNumber("Version")
> Stock Market Functions add-in, Version 2.1.2017.09.17 (C:\SMF Add-In;
> Windows (32-bit) NT 6.01; 15.0; ; ; 1)
> =smfGetGuruFocusItem("AGX",151, "TTM",0)
> Error
> =smfConvertData(smfGetTagContent("https://www.gurufocus.com/financials/AGX",
> "div", -1, "id=""Rf""", "/term/ev/", "yesttm"))
> Error
> [image: Inline image]
>
cookie for the IE object that EXCEL uses). That would allow the "TTM" for
"Free Cash Flow" to be returned, but not return a value for "Enterprise
Value".
To check, what do you get with:
=RCHGetWebData("https://www.gurufocus.com/new_index/","Premium Member
until",75)
I get:
Premium Member until 2018-01-11) , which covers <b>USA</b>.. <a href=https:
On Wed, Nov 1, 2017 at 10:11 AM, Jonathan jbr863@
...
wrote:
>
> I don't know why the image got removed in my last email but I have
> included it as an attachment.
>
> Free Cash Flow works fine (Item # 137) - hopefully the image comes through
> this time. The last two formulae correctly return TTM FCF as $176.90.
>
> [image: Inline image]
>
> When I change the bottom two formulae to call item #151(Enterprise Value),
> the bottom two formulae return TTM EV as "Error":
> =RCHGetElementNumber("Version")
> Stock Market Functions add-in, Version 2.1.2017.09.17 (C:\SMF Add-In;
> Windows (32-bit) NT 6.01; 15.0; ; ; 1)
> =smfGetGuruFocusItem("AGX",151, "TTM",0)
> Error
> =smfConvertData(smfGetTagContent("https://www.gurufocus.com/financials/AGX",
> "div"
> Error
> [image: Inline image]
>
Wed Nov 1, 2017 9:12 am (PDT) . Posted by:
"Jose Jacob" pepecan47
Hi Randy, I found the answer to my question, using DATEVALUE(A12), and formatting that cell.Thank you very much.
Regards, Jose L. Jacob
On Monday, October 30, 2017 1:07 PM, "Jose Jacob pepecan47@yahoo.ca [smf_addin]" <smf_addin@yahoogroups.com> wrote:
Hi Randy, I guess this is a very elementary question, how can I convert the data to an EXCEL serial date?
What is different from Yahoo history? I don't have this problem with the dates.
Regards, Jose L. Jacob
On Monday, October 30, 2017 11:42 AM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
It's text data. You'd need to convert it to an EXCEL serial date value in order for it to accept a date format.
On Mon, Oct 30, 2017 at 8:14 AM, Jose Jacob pepecan47@... wrote:
Hi Randy - I am having a little problem with the table. I want to format the "Date" column to yyyy-mm-dd, But is not accepting the formatting. Could it be that in the date some strange character is appended?
In the source of the web page this is what I see:
<tr class="odd">
<td class="left">Oct 27, 2017</td>
<td class="right">2.42%
</td>
</tr>
#yiv3595885642 #yiv3595885642 -- #yiv3595885642ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3595885642 #yiv3595885642ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3595885642 #yiv3595885642ygrp-mkp #yiv3595885642hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3595885642 #yiv3595885642ygrp-mkp #yiv3595885642ads {margin-bottom:10px;}#yiv3595885642 #yiv3595885642ygrp-mkp .yiv3595885642ad {padding:0 0;}#yiv3595885642 #yiv3595885642ygrp-mkp .yiv3595885642ad p {margin:0;}#yiv3595885642 #yiv3595885642ygrp-mkp .yiv3595885642ad a {color:#0000ff;text-decoration:none;}#yiv3595885642 #yiv3595885642ygrp-sponsor #yiv3595885642ygrp-lc {font-family:Arial;}#yiv3595885642 #yiv3595885642ygrp-sponsor #yiv3595885642ygrp-lc #yiv3595885642hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3595885642 #yiv3595885642ygrp-sponsor #yiv3595885642ygrp-lc .yiv3595885642ad {margin-bottom:10px;padding:0 0;}#yiv3595885642 #yiv3595885642actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3595885642 #yiv3595885642activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3595885642 #yiv3595885642activity span {font-weight:700;}#yiv3595885642 #yiv3595885642activity span:first-child {text-transform:uppercase;}#yiv3595885642 #yiv3595885642activity span a {color:#5085b6;text-decoration:none;}#yiv3595885642 #yiv3595885642activity span span {color:#ff7900;}#yiv3595885642 #yiv3595885642activity span .yiv3595885642underline {text-decoration:underline;}#yiv3595885642 .yiv3595885642attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3595885642 .yiv3595885642attach div a {text-decoration:none;}#yiv3595885642 .yiv3595885642attach img {border:none;padding-right:5px;}#yiv3595885642 .yiv3595885642attach label {display:block;margin-bottom:5px;}#yiv3595885642 .yiv3595885642attach label a {text-decoration:none;}#yiv3595885642 blockquote {margin:0 0 0 4px;}#yiv3595885642 .yiv3595885642bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3595885642 .yiv3595885642bold a {text-decoration:none;}#yiv3595885642 dd.yiv3595885642last p a {font-family:Verdana;font-weight:700;}#yiv3595885642 dd.yiv3595885642last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3595885642 dd.yiv3595885642last p span.yiv3595885642yshortcuts {margin-right:0;}#yiv3595885642 div.yiv3595885642attach-table div div a {text-decoration:none;}#yiv3595885642 div.yiv3595885642attach-table {width:400px;}#yiv3595885642 div.yiv3595885642file-title a, #yiv3595885642 div.yiv3595885642file-title a:active, #yiv3595885642 div.yiv3595885642file-title a:hover, #yiv3595885642 div.yiv3595885642file-title a:visited {text-decoration:none;}#yiv3595885642 div.yiv3595885642photo-title a, #yiv3595885642 div.yiv3595885642photo-title a:active, #yiv3595885642 div.yiv3595885642photo-title a:hover, #yiv3595885642 div.yiv3595885642photo-title a:visited {text-decoration:none;}#yiv3595885642 div#yiv3595885642ygrp-mlmsg #yiv3595885642ygrp-msg p a span.yiv3595885642yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3595885642 .yiv3595885642green {color:#628c2a;}#yiv3595885642 .yiv3595885642MsoNormal {margin:0 0 0 0;}#yiv3595885642 o {font-size:0;}#yiv3595885642 #yiv3595885642photos div {float:left;width:72px;}#yiv3595885642 #yiv3595885642photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv3595885642 #yiv3595885642photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3595885642 #yiv3595885642reco-category {font-size:77%;}#yiv3595885642 #yiv3595885642reco-desc {font-size:77%;}#yiv3595885642 .yiv3595885642replbq {margin:4px;}#yiv3595885642 #yiv3595885642ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3595885642 #yiv3595885642ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3595885642 #yiv3595885642ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3595885642 #yiv3595885642ygrp-mlmsg select, #yiv3595885642 input, #yiv3595885642 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3595885642 #yiv3595885642ygrp-mlmsg pre, #yiv3595885642 code {font:115% monospace;}#yiv3595885642 #yiv3595885642ygrp-mlmsg * {line-height:1.22em;}#yiv3595885642 #yiv3595885642ygrp-mlmsg #yiv3595885642logo {padding-bottom:10px;}#yiv3595885642 #yiv3595885642ygrp-msg p a {font-family:Verdana;}#yiv3595885642 #yiv3595885642ygrp-msg p#yiv3595885642attach-count span {color:#1E66AE;font-weight:700;}#yiv3595885642 #yiv3595885642ygrp-reco #yiv3595885642reco-head {color:#ff7900;font-weight:700;}#yiv3595885642 #yiv3595885642ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3595885642 #yiv3595885642ygrp-sponsor #yiv3595885642ov li a {font-size:130%;text-decoration:none;}#yiv3595885642 #yiv3595885642ygrp-sponsor #yiv3595885642ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3595885642 #yiv3595885642ygrp-sponsor #yiv3595885642ov ul {margin:0;padding:0 0 0 8px;}#yiv3595885642 #yiv3595885642ygrp-text {font-family:Georgia;}#yiv3595885642 #yiv3595885642ygrp-text p {margin:0 0 1em 0;}#yiv3595885642 #yiv3595885642ygrp-text tt {font-size:120%;}#yiv3595885642 #yiv3595885642ygrp-vital ul li:last-child {border-right:none !important;}#yiv3595885642
Regards, Jose L. Jacob
On Monday, October 30, 2017 1:07 PM, "Jose Jacob pepecan47@yahoo.ca [smf_addin]" <smf_addin@yahoogroups.com> wrote:
Hi Randy, I guess this is a very elementary question, how can I convert the data to an EXCEL serial date?
What is different from Yahoo history? I don't have this problem with the dates.
Regards, Jose L. Jacob
On Monday, October 30, 2017 11:42 AM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
It's text data. You'd need to convert it to an EXCEL serial date value in order for it to accept a date format.
On Mon, Oct 30, 2017 at 8:14 AM, Jose Jacob pepecan47@... wrote:
Hi Randy - I am having a little problem with the table. I want to format the "Date" column to yyyy-mm-dd, But is not accepting the formatting. Could it be that in the date some strange character is appended?
In the source of the web page this is what I see:
<tr class="
<td class="
<td class="
</td>
</tr>
#yiv3595885642 #yiv3595885642 -- #yiv3595885642ygrp-
Wed Nov 1, 2017 9:15 am (PDT) . Posted by:
"Jose Jacob" pepecan47
Gaston thank you very much for the link.
Regards, Jose L. Jacob
On Monday, October 30, 2017 2:52 PM, "Gaston Bullrich gaston.bullrich@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
goto
https://fred.stlouisfed.org/series/DGS10
download.
Get the addin from that page and download automatically into xcel.
On Sat, Oct 28, 2017 at 5:38 PM, Jose Jacob pepecan47@yahoo.ca [smf_addin] <smf_addin@yahoogroups.com> wrote:
Do you know how can I extract the 10 Year Treasury history from this source? In a table, so I can do a vlookup?
10 Year Treasury Rate by Month
|
|
|
| | |
|
|
|
| |
10 Year Treasury Rate by Month
By multpl Check out this fantastic 10 Year Treasury Rate table. | |
|
|
Regards, Jose L. Jacob
--
Gaston Bullrich
9 Island Avenue Apt 1406 Miami Beach, Florida 33139
Cel. 917 517 9907 #yiv8555016262 #yiv8555016262 -- #yiv8555016262ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8555016262 #yiv8555016262ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8555016262 #yiv8555016262ygrp-mkp #yiv8555016262hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8555016262 #yiv8555016262ygrp-mkp #yiv8555016262ads {margin-bottom:10px;}#yiv8555016262 #yiv8555016262ygrp-mkp .yiv8555016262ad {padding:0 0;}#yiv8555016262 #yiv8555016262ygrp-mkp .yiv8555016262ad p {margin:0;}#yiv8555016262 #yiv8555016262ygrp-mkp .yiv8555016262ad a {color:#0000ff;text-decoration:none;}#yiv8555016262 #yiv8555016262ygrp-sponsor #yiv8555016262ygrp-lc {font-family:Arial;}#yiv8555016262 #yiv8555016262ygrp-sponsor #yiv8555016262ygrp-lc #yiv8555016262hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8555016262 #yiv8555016262ygrp-sponsor #yiv8555016262ygrp-lc .yiv8555016262ad {margin-bottom:10px;padding:0 0;}#yiv8555016262 #yiv8555016262actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8555016262 #yiv8555016262activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8555016262 #yiv8555016262activity span {font-weight:700;}#yiv8555016262 #yiv8555016262activity span:first-child {text-transform:uppercase;}#yiv8555016262 #yiv8555016262activity span a {color:#5085b6;text-decoration:none;}#yiv8555016262 #yiv8555016262activity span span {color:#ff7900;}#yiv8555016262 #yiv8555016262activity span .yiv8555016262underline {text-decoration:underline;}#yiv8555016262 .yiv8555016262attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8555016262 .yiv8555016262attach div a {text-decoration:none;}#yiv8555016262 .yiv8555016262attach img {border:none;padding-right:5px;}#yiv8555016262 .yiv8555016262attach label {display:block;margin-bottom:5px;}#yiv8555016262 .yiv8555016262attach label a {text-decoration:none;}#yiv8555016262 blockquote {margin:0 0 0 4px;}#yiv8555016262 .yiv8555016262bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8555016262 .yiv8555016262bold a {text-decoration:none;}#yiv8555016262 dd.yiv8555016262last p a {font-family:Verdana;font-weight:700;}#yiv8555016262 dd.yiv8555016262last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8555016262 dd.yiv8555016262last p span.yiv8555016262yshortcuts {margin-right:0;}#yiv8555016262 div.yiv8555016262attach-table div div a {text-decoration:none;}#yiv8555016262 div.yiv8555016262attach-table {width:400px;}#yiv8555016262 div.yiv8555016262file-title a, #yiv8555016262 div.yiv8555016262file-title a:active, #yiv8555016262 div.yiv8555016262file-title a:hover, #yiv8555016262 div.yiv8555016262file-title a:visited {text-decoration:none;}#yiv8555016262 div.yiv8555016262photo-title a, #yiv8555016262 div.yiv8555016262photo-title a:active, #yiv8555016262 div.yiv8555016262photo-title a:hover, #yiv8555016262 div.yiv8555016262photo-title a:visited {text-decoration:none;}#yiv8555016262 div#yiv8555016262ygrp-mlmsg #yiv8555016262ygrp-msg p a span.yiv8555016262yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8555016262 .yiv8555016262green {color:#628c2a;}#yiv8555016262 .yiv8555016262MsoNormal {margin:0 0 0 0;}#yiv8555016262 o {font-size:0;}#yiv8555016262 #yiv8555016262photos div {float:left;width:72px;}#yiv8555016262 #yiv8555016262photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv8555016262 #yiv8555016262photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8555016262 #yiv8555016262reco-category {font-size:77%;}#yiv8555016262 #yiv8555016262reco-desc {font-size:77%;}#yiv8555016262 .yiv8555016262replbq {margin:4px;}#yiv8555016262 #yiv8555016262ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8555016262 #yiv8555016262ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8555016262 #yiv8555016262ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8555016262 #yiv8555016262ygrp-mlmsg select, #yiv8555016262 input, #yiv8555016262 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8555016262 #yiv8555016262ygrp-mlmsg pre, #yiv8555016262 code {font:115% monospace;}#yiv8555016262 #yiv8555016262ygrp-mlmsg * {line-height:1.22em;}#yiv8555016262 #yiv8555016262ygrp-mlmsg #yiv8555016262logo {padding-bottom:10px;}#yiv8555016262 #yiv8555016262ygrp-msg p a {font-family:Verdana;}#yiv8555016262 #yiv8555016262ygrp-msg p#yiv8555016262attach-count span {color:#1E66AE;font-weight:700;}#yiv8555016262 #yiv8555016262ygrp-reco #yiv8555016262reco-head {color:#ff7900;font-weight:700;}#yiv8555016262 #yiv8555016262ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8555016262 #yiv8555016262ygrp-sponsor #yiv8555016262ov li a {font-size:130%;text-decoration:none;}#yiv8555016262 #yiv8555016262ygrp-sponsor #yiv8555016262ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8555016262 #yiv8555016262ygrp-sponsor #yiv8555016262ov ul {margin:0;padding:0 0 0 8px;}#yiv8555016262 #yiv8555016262ygrp-text {font-family:Georgia;}#yiv8555016262 #yiv8555016262ygrp-text p {margin:0 0 1em 0;}#yiv8555016262 #yiv8555016262ygrp-text tt {font-size:120%;}#yiv8555016262 #yiv8555016262ygrp-vital ul li:last-child {border-right:none !important;}#yiv8555016262
Regards, Jose L. Jacob
On Monday, October 30, 2017 2:52 PM, "Gaston Bullrich gaston.bullrich@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
goto
https://fred.stlouisfed.org/series/DGS10
download.
Get the addin from that page and download automatically into xcel.
On Sat, Oct 28, 2017 at 5:38 PM, Jose Jacob pepecan47@yahoo.ca [smf_addin] <smf_addin@yahoogroups.com> wrote:
Do you know how can I extract the 10 Year Treasury history from this source? In a table, so I can do a vlookup?
10 Year Treasury Rate by Month
|
|
|
| | |
|
|
|
| |
10 Year Treasury Rate by Month
By multpl Check out this fantastic 10 Year Treasury Rate table. | |
|
|
Regards, Jose L. Jacob
--
Gaston Bullrich
9 Island Avenue Apt 1406 Miami Beach, Florida 33139
Cel. 917 517 9907 #yiv8555016262 #yiv8555016262 -- #yiv8555016262ygrp-
Wed Nov 1, 2017 1:30 pm (PDT) . Posted by:
codyklein
Is it me or did anyone else notice RCHGetYahooQuotes stopped working late this afternoon?
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar