15 Messages
Digest #4198
Messages
Thu Nov 2, 2017 8:32 pm (PDT) . Posted by:
indinvestor111
Randy,
The new function works beautifully! Thanks. Was wondering if it were possible to add "EBITDA" and perhaps EPS estimates at some point.
Thanks!!!
The new function works beautifully! Thanks. Was wondering if it were possible to add "EBITDA" and perhaps EPS estimates at some point.
Thanks!!!
Fri Nov 3, 2017 12:28 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I have no control over it. The limitation is on what Yahoo provides in the
feed.
You might want to consider doing an export of a Zack's screen. They allow
downloading of thousands of tickers in a single download. So you could grab
the data once a week (or whatever), and do lookups into that downloaded
data?
On Thu, Nov 2, 2017 at 8:32 PM, elandry@
...
wrote:
> The new function works beautifully! Thanks. Was wondering if it were
> possible to add "EBITDA" and perhaps EPS estimates at some point.
>
>
>
feed.
You might want to consider doing an export of a Zack's screen. They allow
downloading of thousands of tickers in a single download. So you could grab
the data once a week (or whatever), and do lookups into that downloaded
data?
On Thu, Nov 2, 2017 at 8:32 PM, elandry@
...
wrote:
> The new function works beautifully! Thanks. Was wondering if it were
> possible to add "EBITDA" and perhaps EPS estimates at some point.
>
>
>
Fri Nov 3, 2017 2:14 am (PDT) . Posted by:
"Robbie Geary" rgearyiii
Does the example
=smfGetYahooPortfolioView("IBM,MMM","01020304050607080910111213141516171819202122232425262728293031323334",,1)
get everything that is available?
On Fri, Nov 3, 2017 at 6:28 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> I have no control over it. The limitation is on what Yahoo provides in the
> feed.
>
> You might want to consider doing an export of a Zack's screen. They allow
> downloading of thousands of tickers in a single download. So you could grab
> the data once a week (or whatever), and do lookups into that downloaded
> data?
>
> On Thu, Nov 2, 2017 at 8:32 PM, elandry@
> ...
> wrote:
>
>> The new function works beautifully! Thanks. Was wondering if it were
>> possible to add "EBITDA" and perhaps EPS estimates at some point.
>>
>>
>>
>
--
Robbie Geary
=smfGetYahooPortfolioView("IBM,MMM","01020304050607080910111213141516171819202122232425262728293031323334",,1)
get everything that is available?
On Fri, Nov 3, 2017 at 6:28 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> I have no control over it. The limitation is on what Yahoo provides in the
> feed.
>
> You might want to consider doing an export of a Zack's screen. They allow
> downloading of thousands of tickers in a single download. So you could grab
> the data once a week (or whatever), and do lookups into that downloaded
> data?
>
> On Thu, Nov 2, 2017 at 8:32 PM, elandry@
> ...
> wrote:
>
>> The new function works beautifully! Thanks. Was wondering if it were
>> possible to add "EBITDA" and perhaps EPS estimates at some point.
>>
>>
>>
>
--
Robbie Geary
Fri Nov 3, 2017 2:41 am (PDT) . Posted by:
"Robbie Geary" rgearyiii
Given that the data may be listed in a different order than the one the
symbols are listed in within the first argument, a handy feature might be
to create a special element number that populates its corresponding column
with the original order number so that the array of cells can be sorted
back into the order in which the ticker symbols were provided.
On Fri, Nov 3, 2017 at 8:14 PM, Robbie Geary <rgearyiii@gmail.com> wrote:
> Does the example
>
> =smfGetYahooPortfolioView("IBM,MMM","010203040506070809101112131415
> 16171819202122232425262728293031323334",,1)
>
> get everything that is available?
>
>
> On Fri, Nov 3, 2017 at 6:28 PM, Randy Harmelink rharmelink@gmail.com
> [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>>
>>
>> I have no control over it. The limitation is on what Yahoo provides in
>> the feed.
>>
>> You might want to consider doing an export of a Zack's screen. They allow
>> downloading of thousands of tickers in a single download. So you could grab
>> the data once a week (or whatever), and do lookups into that downloaded
>> data?
>>
>> On Thu, Nov 2, 2017 at 8:32 PM, elandry@
>> ...
>> wrote:
>>
>>> The new function works beautifully! Thanks. Was wondering if it were
>>> possible to add "EBITDA" and perhaps EPS estimates at some point.
>>>
>>>
>>>
>>
>
>
>
> --
> Robbie Geary
>
--
Robbie Geary
symbols are listed in within the first argument, a handy feature might be
to create a special element number that populates its corresponding column
with the original order number so that the array of cells can be sorted
back into the order in which the ticker symbols were provided.
On Fri, Nov 3, 2017 at 8:14 PM, Robbie Geary <rgearyiii@gmail.com> wrote:
> Does the example
>
> =smfGetYahooPortfolioView("IBM,MMM","010203040506070809101112131415
> 16171819202122232425262728293031323334",,1)
>
> get everything that is available?
>
>
> On Fri, Nov 3, 2017 at 6:28 PM, Randy Harmelink rharmelink@gmail.com
> [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>>
>>
>> I have no control over it. The limitation is on what Yahoo provides in
>> the feed.
>>
>> You might want to consider doing an export of a Zack's screen. They allow
>> downloading of thousands of tickers in a single download. So you could grab
>> the data once a week (or whatever), and do lookups into that downloaded
>> data?
>>
>> On Thu, Nov 2, 2017 at 8:32 PM, elandry@
>> ...
>> wrote:
>>
>>> The new function works beautifully! Thanks. Was wondering if it were
>>> possible to add "EBITDA" and perhaps EPS estimates at some point.
>>>
>>>
>>>
>>
>
>
>
> --
> Robbie Geary
>
--
Robbie Geary
Fri Nov 3, 2017 2:41 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Good news. It looks like EBITDA and "EPS Est Next Year" may be available?
On Thu, Nov 2, 2017 at 8:32 PM, elandry@
...
wrote:
> The new function works beautifully! Thanks. Was wondering if it were
> possible to add "EBITDA" and perhaps EPS estimates at some point.
>
>
>
On Thu, Nov 2, 2017 at 8:32 PM, elandry@
...
wrote:
> The new function works beautifully! Thanks. Was wondering if it were
> possible to add "EBITDA" and perhaps EPS estimates at some point.
>
>
>
Fri Nov 3, 2017 2:45 am (PDT) . Posted by:
"Robbie Geary" rgearyiii
How about Previous Close and Change %? These are useful for validation
(checking for internal consistency) of the other quote items.
On Fri, Nov 3, 2017 at 8:41 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> Good news. It looks like EBITDA and "EPS Est Next Year" may be available?
>
> On Thu, Nov 2, 2017 at 8:32 PM, elandry@
> ...
> wrote:
>
>> The new function works beautifully! Thanks. Was wondering if it were
>> possible to add "EBITDA" and perhaps EPS estimates at some point.
>>
>>
>>
>
--
Robbie Geary
(checking for internal consistency) of the other quote items.
On Fri, Nov 3, 2017 at 8:41 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> Good news. It looks like EBITDA and "EPS Est Next Year" may be available?
>
> On Thu, Nov 2, 2017 at 8:32 PM, elandry@
> ...
> wrote:
>
>> The new function works beautifully! Thanks. Was wondering if it were
>> possible to add "EBITDA" and perhaps EPS estimates at some point.
>>
>>
>>
>
--
Robbie Geary
Fri Nov 3, 2017 2:56 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
It was something I was considering. The routine wasn't really completed
before I released it. It's been something I've been working on off and on
for a while. The loss of RCHGetYahooQuotes() forced me to release it
earlier than I had planned.
It's more complicated than merely sorting. If the ticker symbol isn't
valid, Yahoo just ignores it in the returned data. So a blank line needs to
exist for those missing ticker symbols.
What I was thinking of doing is matching up each returned ticker to the
original passed ticker, thus leaving some lines blank. I think that can be
done, since I'm just passing a comma-delimited list of ticker symbols. I
should be able to split them up into an array, and then look up in that
array which output line the data goes into, instead of just using the next
available line. It may slow things down a little, for a large request.
But I hadn't gotten past thinking about it. I was seeing the data in the
same order nearly 100% of the time. But now I see currency quotes always
get returned first, and not necessarily in the same order they were sent. I
never even looked at currency tickers before this.
I tend to write functions for things I do, and am just sharing the results.
Not what would happen in a commercial venture. :(
On Fri, Nov 3, 2017 at 2:41 AM, Robbie Geary rgearyiii@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
> Given that the data may be listed in a different order than the one the
> symbols are listed in within the first argument, a handy feature might be
> to create a special element number that populates its corresponding column
> with the original order number so that the array of cells can be sorted
> back into the order in which the ticker symbols were provided.
>
>
>
before I released it. It's been something I've been working on off and on
for a while. The loss of RCHGetYahooQuotes() forced me to release it
earlier than I had planned.
It's more complicated than merely sorting. If the ticker symbol isn't
valid, Yahoo just ignores it in the returned data. So a blank line needs to
exist for those missing ticker symbols.
What I was thinking of doing is matching up each returned ticker to the
original passed ticker, thus leaving some lines blank. I think that can be
done, since I'm just passing a comma-delimited list of ticker symbols. I
should be able to split them up into an array, and then look up in that
array which output line the data goes into, instead of just using the next
available line. It may slow things down a little, for a large request.
But I hadn't gotten past thinking about it. I was seeing the data in the
same order nearly 100% of the time. But now I see currency quotes always
get returned first, and not necessarily in the same order they were sent. I
never even looked at currency tickers before this.
I tend to write functions for things I do, and am just sharing the results.
Not what would happen in a commercial venture. :(
On Fri, Nov 3, 2017 at 2:41 AM, Robbie Geary rgearyiii@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
> Given that the data may be listed in a different order than the one the
> symbols are listed in within the first argument, a handy feature might be
> to create a special element number that populates its corresponding column
> with the original order number so that the array of cells can be sorted
> back into the order in which the ticker symbols were provided.
>
>
>
Thu Nov 2, 2017 8:40 pm (PDT) . Posted by:
"V. Shankar" tarakayan
So all the work done by Randy using yahoo gone? This has been great for various portfolio analysis and never thought of alternatives. Is smfyahooportfolioview also down?
What about one offered by excel using MSN money? I used work on this till I found smf....anyone is using this?
Shankar
Sent from my iPhone
> On 03-Nov-2017, at 2:52 AM, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
> 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?
>
>
What about one offered by excel using MSN money? I used work on this till I found smf....anyone is using this?
Shankar
Sent from my iPhone
> On 03-Nov-2017, at 2:52 AM, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
> If you only do a few, you can do:
>
> =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?
>
>
Fri Nov 3, 2017 12:37 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
As far as I know, smfGetYahooPortfolioView() is working OK right now. The
only change in the pipeline is to allow non-US currencies.
All of the alternatives I've looked at were for exports of defined
portfolios or watch lists.
On Thu, Nov 2, 2017 at 8:23 PM, 'V. Shankar' tarakayan@yahoo.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
> So all the work done by Randy using yahoo gone? This has been great for
> various portfolio analysis and never thought of alternatives. Is
> smfyahooportfolioview also down?
>
> What about one offered by excel using MSN money? I used work on this till
> I found smf....anyone is using this?
> Shankar
>
>
>
only change in the pipeline is to allow non-US currencies.
All of the alternatives I've looked at were for exports of defined
portfolios or watch lists.
On Thu, Nov 2, 2017 at 8:23 PM, 'V. Shankar' tarakayan@yahoo.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
> So all the work done by Randy using yahoo gone? This has been great for
> various portfolio analysis and never thought of alternatives. Is
> smfyahooportfoliovi
>
> What about one offered by excel using MSN money? I used work on this till
> I found smf....anyone is using this?
> Shankar
>
>
>
Thu Nov 2, 2017 11:52 pm (PDT) . Posted by:
tombeckman@rocketmail.com
Hi, Can anyone explain the smfGetYahooPortfolioView "Last Traded" date format? I somehow could not see the obvious...
Thanks.
Thanks.
Thu Nov 2, 2017 11:53 pm (PDT) . Posted by:
"Home" SUNIL_M_DHOOT
Randy,
I downloaded the latest addin and then used the following
=smfgetyahooportfolioview(b6:b188,"0115",,1)
Where column B has the ticker symbols. This returns the ticker symbol and value.
This works well except occasionally it skips some ticker symbols and goes to the next one.
What is causing some ticker symbols to skip?
Sunil Dhoot
Sent from my iPhone
> On Nov 2, 2017, at 9:09 PM, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
> As I mentioned on the blog entry, the template itself was the only real documentation.
>
> You'd just need something like:
>
> =smfGetYahooPortfolioView(C5:C6,"01153034",,1)
>
> You should always return the ticker symbol, because the returned data may not match the order of the passed ticker symbols.
>
> On Thu, Nov 2, 2017 at 6:46 PM, bameyer@
> ...
> wrote:
>> I am trying to find the documentation for the smfGetYahooPortfolioView function. The documentation page does not seem to contain it. I have updated to the RCH_Stock_Market_Functions-2.1.2017.11.02 version. I am only trying to pull 3 pieces of data - Last Price, Forward PE and Dividend Yield. I tried to pull just the last price with the following =smfGetYahooPortfolioView($B$4,"15",,1) but all it returns is "Last Price" instead of the value of
>>
>> t
>> he last price.
>> If it is possible to pull just elements 15, 30 and 34 that is all I am hoping for from the workaround.
>>
>>
>>
>
>
I downloaded the latest addin and then used the following
=smfgetyahooportfolioview(b6:b188,"0115",,1)
Where column B has the ticker symbols. This returns the ticker symbol and value.
This works well except occasionally it skips some ticker symbols and goes to the next one.
What is causing some ticker symbols to skip?
Sunil Dhoot
Sent from my iPhone
> On Nov 2, 2017, at 9:09 PM, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
> As I mentioned on the blog entry, the template itself was the only real documentation.
>
> You'd just need something like:
>
> =smfGetYahooPortfol
>
> You should always return the ticker symbol, because the returned data may not match the order of the passed ticker symbols.
>
> On Thu, Nov 2, 2017 at 6:46 PM, bameyer@
> ...
> wrote:
>> I am trying to find the documentation for the smfGetYahooPortfoli
>>
>> t
>> he last price.
>> If it is possible to pull just elements 15, 30 and 34 that is all I am hoping for from the workaround.
>>
>>
>>
>
>
Fri Nov 3, 2017 12:40 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
It's a UNIX date.
You can convert it into an EXCEL serial date time with something like:
=smfUNIX2Date(A2)
The integer portion is the date. The fractional portion is the time. Just
apply a date/time format to the result and you should be fine.
On Thu, Nov 2, 2017 at 8:22 PM, tbeckman@
...
wrote:
>
> Hi, Can anyone explain the smfGetYahooPortfolioView "Last Traded" date
> format?
> I somehow could not see the obvious...
>
>
>
You can convert it into an EXCEL serial date time with something like:
=smfUNIX2Date(
The integer portion is the date. The fractional portion is the time. Just
apply a date/time format to the result and you should be fine.
On Thu, Nov 2, 2017 at 8:22 PM, tbeckman@
...
wrote:
>
> Hi, Can anyone explain the smfGetYahooPortfoli
> format?
> I somehow could not see the obvious...
>
>
>
Fri Nov 3, 2017 12:51 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Which ticker symbols are you having problems with?
I've seen two situations for skipping:
1. Not a valid ticker symbol
2. Non-US currency combination (i.e. CADAUD=X). This is fixed for the next
release.
On Thu, Nov 2, 2017 at 9:22 PM, Home sdhoot@
...
wrote:
>
> I downloaded the latest addin and then used the following
> =smfgetyahooportfolioview(b6:b188,"0115",,1)
> Where column B has the ticker symbols. This returns the ticker symbol and
> value.
>
> This works well except occasionally it skips some ticker symbols and goes
> to the next one.
>
> What is causing some ticker symbols to skip?
>
>
I've seen two situations for skipping:
1. Not a valid ticker symbol
2. Non-US currency combination (i.e. CADAUD=X). This is fixed for the next
release.
On Thu, Nov 2, 2017 at 9:22 PM, Home sdhoot@
...
wrote:
>
> I downloaded the latest addin and then used the following
> =smfgetyahooportfol
> Where column B has the ticker symbols. This returns the ticker symbol and
> value.
>
> This works well except occasionally it skips some ticker symbols and goes
> to the next one.
>
> What is causing some ticker symbols to skip?
>
>
Fri Nov 3, 2017 12:26 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
For the blog, there's a link way on the bottom left that says: "Subscribe
to".
I think any service can come up with a way to prevent the add-in from
accessing the data. It's why I tell people to try and minimize the amount
of data they grab. If it becomes a burden, the sources have all the more
reason to prevent it. Too many people think that just because the data is
free and they can get it with little effort, they are entitled to all the
data. Even if they don't really need it, or even use it.
In the end, I wish I was getting the data from my broker. I can get live
quotes from them when I'm logged in. Imagine if they had a tool like the
add-in that could allow their customers access to the data, for trading.
They could even require a certain amount of trading per month.
I'm not a fan of Google. Their options quotes are now nearly worthless --
too many gaps in the data. And they are currently unplugging their
portfolios. To me, that doesn't bode well for the future of their
commitment to providing financial data.
On Thu, Nov 2, 2017 at 7:21 PM, earladamy@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> The Blog looks like a great idea for quick reference and I've bookmarked
> it. I've looked all over for a way to subscribe to an RSS feed but don't
> see any?
>
> Yahoo seems to have a goal of preventing downloading without viewing
> advertising. Visit the website populated with advertising, enter a symbol
> and download data. That is clearly ok. But downloading without viewing ads
> is not ok. I assume that this has turned into a cat and mouse game of
> finding the holes and closing them. How much difficulty will they have in
> shutting down the JSON based scraping your are doing now?
>
> If all one needs is a current real-time quote, how do you feel about the
> quality of Google quotes versus Yahoo?
>
>
>
to".
I think any service can come up with a way to prevent the add-in from
accessing the data. It's why I tell people to try and minimize the amount
of data they grab. If it becomes a burden, the sources have all the more
reason to prevent it. Too many people think that just because the data is
free and they can get it with little effort, they are entitled to all the
data. Even if they don't really need it, or even use it.
In the end, I wish I was getting the data from my broker. I can get live
quotes from them when I'm logged in. Imagine if they had a tool like the
add-in that could allow their customers access to the data, for trading.
They could even require a certain amount of trading per month.
I'm not a fan of Google. Their options quotes are now nearly worthless --
too many gaps in the data. And they are currently unplugging their
portfolios. To me, that doesn't bode well for the future of their
commitment to providing financial data.
On Thu, Nov 2, 2017 at 7:21 PM, earladamy@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> The Blog looks like a great idea for quick reference and I've bookmarked
> it. I've looked all over for a way to subscribe to an RSS feed but don't
> see any?
>
> Yahoo seems to have a goal of preventing downloading without viewing
> advertising. Visit the website populated with advertising, enter a symbol
> and download data. That is clearly ok. But downloading without viewing ads
> is not ok. I assume that this has turned into a cat and mouse game of
> finding the holes and closing them. How much difficulty will they have in
> shutting down the JSON based scraping your are doing now?
>
> If all one needs is a current real-time quote, how do you feel about the
> quality of Google quotes versus Yahoo?
>
>
>
Fri Nov 3, 2017 12:45 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
These currency combinations should work in the next release. They didn't
fit the extraction pattern I was using.
On Thu, Nov 2, 2017 at 3:44 PM, peterejkt@
...
wrote:
>
> Seems like some currency pairs don't work as they did previously. I can
> work around using combinations of other pairs, but strange that they don't
> work now.
>
> AUDGBP=X
> AUDIDR=X
>
>
>
fit the extraction pattern I was using.
On Thu, Nov 2, 2017 at 3:44 PM, peterejkt@
...
wrote:
>
> Seems like some currency pairs don't work as they did previously. I can
> work around using combinations of other pairs, but strange that they don't
> work now.
>
> AUDGBP=X
> AUDIDR=X
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar