15 Messages
Digest #4195
Messages
Thu Nov 2, 2017 2:09 pm (PDT) . Posted by:
marsh_gerda
Thanks Randy - really appreciate your work. Marshall
Thu Nov 2, 2017 2:13 pm (PDT) . Posted by:
smmarder
I also appreciate all of your fine work. I have relied on the Yahoo quotes simply to pull down a stock quote into a singe cell in my spreadsheet and then use that to calculate a number of other cells. Is there any other way to pull down a quote into a excel cell? or are we out of luck?
Thanks
Thanks
Thu Nov 2, 2017 2:22 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
If you only do a few, you can do:
=smfGetYahooPortfolioView("MMM","15")
Otherwise, if you do a number of different fields and/or tickers, please do
the array-entered version. Otherwise, it just encourages Yahoo to shut the
process down, because they get inundated with requests.
On Thu, Nov 2, 2017 at 2:13 PM, smmarder@
...
wrote:
>
> I also appreciate all of your fine work. I have relied on the Yahoo quotes
> simply to pull down a stock quote into a singe cell in my spreadsheet and
> then use that to calculate a number of other cells. Is there any other way
> to pull down a quote into a excel cell? or are we out of luck?
>
=smfGetYahooPortfol
Otherwise, if you do a number of different fields and/or tickers, please do
the array-entered version. Otherwise, it just encourages Yahoo to shut the
process down, because they get inundated with requests.
On Thu, Nov 2, 2017 at 2:13 PM, smmarder@
...
wrote:
>
> I also appreciate all of your fine work. I have relied on the Yahoo quotes
> simply to pull down a stock quote into a singe cell in my spreadsheet and
> then use that to calculate a number of other cells. Is there any other way
> to pull down a quote into a excel cell? or are we out of luck?
>
Thu Nov 2, 2017 3:00 pm (PDT) . Posted by:
smmarder
I just tried that and the return in the cell was : "#NAME?"
Thu Nov 2, 2017 2:18 pm (PDT) . Posted by:
lewglenn
OK, Randy, I read your announcement that RCHGetYahooQuotes may be no more. Below is a vba code snippet that I've been using:
'Following code extracts the previous, open, high, low, last trade, date and time of last trade,
' and 50-day SMA for each of the listings in SelStr
Sheets(MySheet).Select
Range("A2:I70") = RCHGetYahooQuotes(SelStr, "spohgl1d1t1m3", , Now(), 0)
Is there another way of getting this info? Do I need to download a new version of the add-in? The one I'm using was created on 9/17/2017.
Thanks.
'Following code extracts the previous, open, high, low, last trade, date and time of last trade,
' and 50-day SMA for each of the listings in SelStr
Sheets(MySheet)
Range("
Is there another way of getting this info? Do I need to download a new version of the add-in? The one I'm using was created on 9/17/2017.
Thanks.
Thu Nov 2, 2017 2:26 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You'd need to change that over to the smfGetYahooPortfolioView() function,
but not all of those fields are available. And, yes, you would need the
latest version of the add-in.
BTW, the NOW() parameter there was useless.
On Thu, Nov 2, 2017 at 2:18 PM, lewglenn@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> OK, Randy, I read your announcement that RCHGetYahooQuotes may be no more.
> Below is a vba code snippet that I've been using:
>
> 'Following code extracts the previous, open, high, low, last trade, date
> and time of last trade,
> ' and 50-day SMA for each of the listings in SelStr
> Sheets(MySheet).Select
> Range("A2:I70") = RCHGetYahooQuotes(SelStr, "spohgl1d1t1m3", , Now(),
> 0)
>
> Is there another way of getting this info? Do I need to download a new
> version of the add-in? The one I'm using was created on 9/17/2017.
>
>
but not all of those fields are available. And, yes, you would need the
latest version of the add-in.
BTW, the NOW() parameter there was useless.
On Thu, Nov 2, 2017 at 2:18 PM, lewglenn@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> OK, Randy, I read your announcement that RCHGetYahooQuotes may be no more.
> Below is a vba code snippet that I've been using:
>
> 'Following code extracts the previous, open, high, low, last trade, date
> and time of last trade,
> ' and 50-day SMA for each of the listings in SelStr
> Sheets(MySheet)
> Range("
> 0)
>
> Is there another way of getting this info? Do I need to download a new
> version of the add-in? The one I'm using was created on 9/17/2017.
>
>
Thu Nov 2, 2017 2:41 pm (PDT) . Posted by:
"Yahoo!" lewglenn
What fields are available? or unavailable? Where can I find the documentation for the parameter list of the smfGetYahooPortfolioView() function?
Thanks again for fighting the battle!
On Thursday, November 2, 2017, 2:26:44 PM PDT, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
You'd need to change that over to the smfGetYahooPortfolioView() function, but not all of those fields are available. And, yes, you would need the latest version of the add-in.
BTW, the NOW() parameter there was useless.
On Thu, Nov 2, 2017 at 2:18 PM, lewglenn@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
OK, Randy, I read your announcement that RCHGetYahooQuotes may be no more. Below is a vba code snippet that I've been using:
'Following code extracts the previous, open, high, low, last trade, date and time of last trade,
' and 50-day SMA for each of the listings in SelStr
Sheets(MySheet).Select
Range("A2:I70") = RCHGetYahooQuotes(SelStr, "spohgl1d1t1m3", , Now(), 0)
Is there another way of getting this info? Do I need to download a new version of the add-in? The one I'm using was created on 9/17/2017.
#yiv2832380682 #yiv2832380682 -- #yiv2832380682ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2832380682 #yiv2832380682ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2832380682 #yiv2832380682ygrp-mkp #yiv2832380682hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2832380682 #yiv2832380682ygrp-mkp #yiv2832380682ads {margin-bottom:10px;}#yiv2832380682 #yiv2832380682ygrp-mkp .yiv2832380682ad {padding:0 0;}#yiv2832380682 #yiv2832380682ygrp-mkp .yiv2832380682ad p {margin:0;}#yiv2832380682 #yiv2832380682ygrp-mkp .yiv2832380682ad a {color:#0000ff;text-decoration:none;}#yiv2832380682 #yiv2832380682ygrp-sponsor #yiv2832380682ygrp-lc {font-family:Arial;}#yiv2832380682 #yiv2832380682ygrp-sponsor #yiv2832380682ygrp-lc #yiv2832380682hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2832380682 #yiv2832380682ygrp-sponsor #yiv2832380682ygrp-lc .yiv2832380682ad {margin-bottom:10px;padding:0 0;}#yiv2832380682 #yiv2832380682actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2832380682 #yiv2832380682activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2832380682 #yiv2832380682activity span {font-weight:700;}#yiv2832380682 #yiv2832380682activity span:first-child {text-transform:uppercase;}#yiv2832380682 #yiv2832380682activity span a {color:#5085b6;text-decoration:none;}#yiv2832380682 #yiv2832380682activity span span {color:#ff7900;}#yiv2832380682 #yiv2832380682activity span .yiv2832380682underline {text-decoration:underline;}#yiv2832380682 .yiv2832380682attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2832380682 .yiv2832380682attach div a {text-decoration:none;}#yiv2832380682 .yiv2832380682attach img {border:none;padding-right:5px;}#yiv2832380682 .yiv2832380682attach label {display:block;margin-bottom:5px;}#yiv2832380682 .yiv2832380682attach label a {text-decoration:none;}#yiv2832380682 blockquote {margin:0 0 0 4px;}#yiv2832380682 .yiv2832380682bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2832380682 .yiv2832380682bold a {text-decoration:none;}#yiv2832380682 dd.yiv2832380682last p a {font-family:Verdana;font-weight:700;}#yiv2832380682 dd.yiv2832380682last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2832380682 dd.yiv2832380682last p span.yiv2832380682yshortcuts {margin-right:0;}#yiv2832380682 div.yiv2832380682attach-table div div a {text-decoration:none;}#yiv2832380682 div.yiv2832380682attach-table {width:400px;}#yiv2832380682 div.yiv2832380682file-title a, #yiv2832380682 div.yiv2832380682file-title a:active, #yiv2832380682 div.yiv2832380682file-title a:hover, #yiv2832380682 div.yiv2832380682file-title a:visited {text-decoration:none;}#yiv2832380682 div.yiv2832380682photo-title a, #yiv2832380682 div.yiv2832380682photo-title a:active, #yiv2832380682 div.yiv2832380682photo-title a:hover, #yiv2832380682 div.yiv2832380682photo-title a:visited {text-decoration:none;}#yiv2832380682 div#yiv2832380682ygrp-mlmsg #yiv2832380682ygrp-msg p a span.yiv2832380682yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2832380682 .yiv2832380682green {color:#628c2a;}#yiv2832380682 .yiv2832380682MsoNormal {margin:0 0 0 0;}#yiv2832380682 o {font-size:0;}#yiv2832380682 #yiv2832380682photos div {float:left;width:72px;}#yiv2832380682 #yiv2832380682photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv2832380682 #yiv2832380682photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2832380682 #yiv2832380682reco-category {font-size:77%;}#yiv2832380682 #yiv2832380682reco-desc {font-size:77%;}#yiv2832380682 .yiv2832380682replbq {margin:4px;}#yiv2832380682 #yiv2832380682ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2832380682 #yiv2832380682ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2832380682 #yiv2832380682ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2832380682 #yiv2832380682ygrp-mlmsg select, #yiv2832380682 input, #yiv2832380682 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2832380682 #yiv2832380682ygrp-mlmsg pre, #yiv2832380682 code {font:115% monospace;}#yiv2832380682 #yiv2832380682ygrp-mlmsg * {line-height:1.22em;}#yiv2832380682 #yiv2832380682ygrp-mlmsg #yiv2832380682logo {padding-bottom:10px;}#yiv2832380682 #yiv2832380682ygrp-msg p a {font-family:Verdana;}#yiv2832380682 #yiv2832380682ygrp-msg p#yiv2832380682attach-count span {color:#1E66AE;font-weight:700;}#yiv2832380682 #yiv2832380682ygrp-reco #yiv2832380682reco-head {color:#ff7900;font-weight:700;}#yiv2832380682 #yiv2832380682ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2832380682 #yiv2832380682ygrp-sponsor #yiv2832380682ov li a {font-size:130%;text-decoration:none;}#yiv2832380682 #yiv2832380682ygrp-sponsor #yiv2832380682ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2832380682 #yiv2832380682ygrp-sponsor #yiv2832380682ov ul {margin:0;padding:0 0 0 8px;}#yiv2832380682 #yiv2832380682ygrp-text {font-family:Georgia;}#yiv2832380682 #yiv2832380682ygrp-text p {margin:0 0 1em 0;}#yiv2832380682 #yiv2832380682ygrp-text tt {font-size:120%;}#yiv2832380682 #yiv2832380682ygrp-vital ul li:last-child {border-right:none !important;}#yiv2832380682
Thanks again for fighting the battle!
On Thursday, November 2, 2017, 2:26:44 PM PDT, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
You'd need to change that over to the smfGetYahooPortfolioView() function, but not all of those fields are available. And, yes, you would need the latest version of the add-in.
BTW, the NOW() parameter there was useless.
On Thu, Nov 2, 2017 at 2:18 PM, lewglenn@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
OK, Randy, I read your announcement that RCHGetYahooQuotes may be no more. Below is a vba code snippet that I've been using:
'Following code extracts the previous, open, high, low, last trade, date and time of last trade,
' and 50-day SMA for each of the listings in SelStr
Sheets(MySheet)
Range("
Is there another way of getting this info? Do I need to download a new version of the add-in? The one I'm using was created on 9/17/2017.
#yiv2832380682 #yiv2832380682 -- #yiv2832380682ygrp-
Thu Nov 2, 2017 2:54 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The example is the only documentation at this time.
On Thu, Nov 2, 2017 at 2:40 PM, Yahoo! lewglenn@
...
wrote:
>
> What fields are available? or unavailable? Where can I find the
> documentation for the parameter list of the smfGetYahooPortfolioView()
> function?
>
>
>
On Thu, Nov 2, 2017 at 2:40 PM, Yahoo! lewglenn@
...
wrote:
>
> What fields are available? or unavailable? Where can I find the
> documentation for the parameter list of the smfGetYahooPortfoli
> function?
>
>
>
Thu Nov 2, 2017 2:19 pm (PDT) . Posted by:
dzaveski
FYI - I am seeing the same issue with a spreadsheet that I use everyday. Today... no data..
Thu Nov 2, 2017 2:27 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
See the announcement for the last few days:
https://smf-add-in.blogspot.com/
On Thu, Nov 2, 2017 at 2:02 PM, rho49m@
...
wrote:
> I have a strange problem, I used SMF to update a Excel spreadsheet of
> stock holdings. This worked with an array for years. Today the spreadsheets
> don't download data, Nothing happens at all. If I enter
> =RCHGetYahooQuotes("IBM") in a data cell nothing happens. I have tried
> the obvious, downloaded the latest ,zip file 02-11-17, tried to re enable
> the add-in in excel, which seemed to indicate the plugin was installed.
>
> Any idea what I should do next?
>
>
>
https://smf-add-in.blogspot.com/
On Thu, Nov 2, 2017 at 2:02 PM, rho49m@
...
wrote:
> I have a strange problem, I used SMF to update a Excel spreadsheet of
> stock holdings. This worked with an array for years. Today the spreadsheets
> don't download data, Nothing happens at all. If I enter
> =RCHGetYahooQuotes(
> the obvious, downloaded the latest ,zip file 02-11-17, tried to re enable
> the add-in in excel, which seemed to indicate the plugin was installed.
>
> Any idea what I should do next?
>
>
>
Thu Nov 2, 2017 2:26 pm (PDT) . Posted by:
bob_15861586
Randy,
I now have it working. Thank you very much.
Bob
I now have it working. Thank you very much.
Bob
Thu Nov 2, 2017 2:33 pm (PDT) . Posted by:
ssztaba
Randy,
Yahoo does currently have a csv file export function for a listing of stocks and prices.
Here's the link I used: https://finance.yahoo.com/portfolio/pf_1/view/view_3 https://finance.yahoo.com/portfolio/pf_1/view/view_3
I had to enter the symbols manually. There is an export feature which will give the symbol and latest price. The name of the security does not seem to get exported.
I don't know if this is of any use to you.
All the best,
Stan
Yahoo does currently have a csv file export function for a listing of stocks and prices.
Here's the link I used: https://finance.yahoo.com/portfolio/pf_1/view/view_3 https://finance.yahoo.com/portfolio/pf_1/view/view_3
I had to enter the symbols manually. There is an export feature which will give the symbol and latest price. The name of the security does not seem to get exported.
I don't know if this is of any use to you.
All the best,
Stan
Thu Nov 2, 2017 2:38 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
That link is to one of your own personal portfolio views. The export
feature there is a customized one for that specific portfolio and its view.
The export file is not available to the add-in.
On Thu, Nov 2, 2017 at 2:33 PM, ssztaba@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Yahoo does currently have a csv file export function for a listing of
> stocks and prices.
>
> Here's the link I used: https://finance.yahoo.com/
> portfolio/pf_1/view/view_3
>
> I had to enter the symbols manually. There is an export feature which
> will give the symbol and latest price. The name of the security does not
> seem to get exported.
>
> I don't know if this is of any use to you.
>
>
feature there is a customized one for that specific portfolio and its view.
The export file is not available to the add-in.
On Thu, Nov 2, 2017 at 2:33 PM, ssztaba@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Yahoo does currently have a csv file export function for a listing of
> stocks and prices.
>
> Here's the link I used: https://finance.yahoo.com/
> portfolio/pf_
>
> I had to enter the symbols manually. There is an export feature which
> will give the symbol and latest price. The name of the security does not
> seem to get exported.
>
> I don't know if this is of any use to you.
>
>
Thu Nov 2, 2017 2:40 pm (PDT) . Posted by:
aeonff
Any idea what query I can use to parse various currency exchange rates?
What about getting "company name" from the ticker? for example MSFT = Microsoft
What about getting "company name" from the ticker? for example MSFT = Microsoft
Thu Nov 2, 2017 2:57 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The new smfGetYahooPortfolioView() can be used for both of those. See the
template. A currency ticker symbol would be something like:
USDCAD=X
Oddly enough, for the portfolio view, Yahoo returns all of the currency
quotes first...
On Thu, Nov 2, 2017 at 2:40 PM, ori@
...
wrote:
> Any idea what query I can use to parse various currency exchange rates?
>
> What about getting "company name" from the ticker? for example MSFT =
> Microsoft
>
>
>
template. A currency ticker symbol would be something like:
USDCAD=X
Oddly enough, for the portfolio view, Yahoo returns all of the currency
quotes first...
On Thu, Nov 2, 2017 at 2:40 PM, ori@
...
wrote:
> Any idea what query I can use to parse various currency exchange rates?
>
> What about getting "company name" from the ticker? for example MSFT =
> Microsoft
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar