6 Messages
Digest #4245
Messages
Thu Nov 23, 2017 5:27 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
FYI -- The new smfGetYahooPortfolioView() process does appear to get real
time quotes for stocks...
On Wed, Nov 22, 2017 at 5:15 PM, climbermel@
...
wrote:
>
> I know most of my tools that I use, don't require constantly up to date
> pricing. Yahoo was always at least 15 minutes behind, but that was fine
> for things like trade books and portfolio views. My trading of course is
> done off of RT data, but research and reporting I realized that a lot of
> times it was after hours anyway...
>
> So the point of my rambling is that since I had to rebuild everything, I
> took a look at how could I make things better and less reliant on one data
> feed like Yahoo. Well thanks to some helpful people in here, I have come
> up with a solution! I have played with a group of connected spreadsheets
> from Pete and his TtP-S group. That caused me to learn how he did it and I
> now have a collection of sheets that inter-connect to re-use data instead
> of always pulling the same data a gazillion times. (see Randy I have been
> listening over the years!)
>
> I've now taken it a step farther, by using Randy's portfolio view updates,
> Pete's handy spreadsheet that grabs data for all your tickers with the
> click of a button (based on the portfolio view) and then I've changed all
> my spreadsheets to grab price, name and other items as needed from that
> sheet.
>
> I did have to fix a bit of code in the example spreadsheet that Pete
> posted, but so far, not only does it work slick, they're all faster. So,
> I'm going to see if I can clean out any personal data and post an example
> as I think it would be a help to make sure that Yahoo doesn't pull any more
> plugs when all that old traffic moves over to a new area...
>
>
time quotes for stocks...
On Wed, Nov 22, 2017 at 5:15 PM, climbermel@
...
wrote:
>
> I know most of my tools that I use, don't require constantly up to date
> pricing. Yahoo was always at least 15 minutes behind, but that was fine
> for things like trade books and portfolio views. My trading of course is
> done off of RT data, but research and reporting I realized that a lot of
> times it was after hours anyway...
>
> So the point of my rambling is that since I had to rebuild everything, I
> took a look at how could I make things better and less reliant on one data
> feed like Yahoo. Well thanks to some helpful people in here, I have come
> up with a solution! I have played with a group of connected spreadsheets
> from Pete and his TtP-S group. That caused me to learn how he did it and I
> now have a collection of sheets that inter-connect to re-use data instead
> of always pulling the same data a gazillion times. (see Randy I have been
> listening over the years!)
>
> I've now taken it a step farther, by using Randy's portfolio view updates,
> Pete's handy spreadsheet that grabs data for all your tickers with the
> click of a button (based on the portfolio view) and then I've changed all
> my spreadsheets to grab price, name and other items as needed from that
> sheet.
>
> I did have to fix a bit of code in the example spreadsheet that Pete
> posted, but so far, not only does it work slick, they're all faster. So,
> I'm going to see if I can clean out any personal data and post an example
> as I think it would be a help to make sure that Yahoo doesn't pull any more
> plugs when all that old traffic moves over to a new area...
>
>
Thu Nov 23, 2017 5:28 pm (PST) . Posted by:
"Dennis Sesar" dennis@zis.com
This is the contents of old cell that worked perfectly/
=RCHGetYahooQuotes(C21,"l1")
I downloaded the new addin and the cell does not generate the quote. What am
I doing wrong
Dennis Sesar
18757 Burbank Blvd., Ste 116
Tarzana, CA 91356
Tel: 310.826.8634/818.206.8634 Ext 114
dennis@zis.com <mailto:dennis@zis.com>
=RCHGetYahooQuotes(C21,"l1")
I downloaded the new addin and the cell does not generate the quote. What am
I doing wrong
Dennis Sesar
18757 Burbank Blvd., Ste 116
Tarzana, CA 91356
Tel: 310.826.8634/818.206.8634 Ext 114
dennis@zis.com <mailto:dennis@zis.com>
Good morning and thanks Randy.
I use those elements for ETFs assessment.
Is there another alternative to get those Data Elements? Other
sources defined in the Add-In Data Elements such as IBD give
Error message.
Thanks again
Armando
-----Original Message-----
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]"
Sent: Nov 18, 2017 7:17 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] DATA ELEMENTS 4671 THROUGH 4679 and 4947
I'm getting a lot of timeouts on accessing the Morningstar web
pages those elements come from. It could be that Morningstar is
unplugging them. They are their old "print format" pages.
Re: Yahoo mutual fund elements -- see:
https://groups.google.com/d/msg/smf-addin/33cX75sYSlY/whTwlQmJCQA\
J
<https://groups.google.com/d/msg/smf-addin/33cX75sYSlY/whTwlQmJCQ\
AJ>
On Sat, Nov 18, 2017 at 11:42 AM, armando@... wrote:
The DE in the caption stopped working. The 46xx series are from
Morningstar the 4947 from Yahoo.
Any hints,
I use those elements for ETFs assessment.
Is there another alternative to get those Data Elements? Other
sources defined in the Add-In Data Elements such as IBD give
Error message.
Thanks again
Armando
-----Original Message-----
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]"
Sent: Nov 18, 2017 7:17 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] DATA ELEMENTS 4671 THROUGH 4679 and 4947
I'm getting a lot of timeouts on accessing the Morningstar web
pages those elements come from. It could be that Morningstar is
unplugging them. They are their old "print format" pages.
Re: Yahoo mutual fund elements -- see:
https://groups.google.com/d/msg/smf-addin/33cX75sYSlY/whTwlQmJCQA\
J
<https://groups.google.com/d/msg/smf-addin/33cX75sYSlY/whTwlQmJCQ\
AJ>
On Sat, Nov 18, 2017 at 11:42 AM, armando@... wrote:
The DE in the caption stopped working. The 46xx series are from
Morningstar the 4947 from Yahoo.
Any hints,
Thu Nov 23, 2017 6:23 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Only some of those fields work for ETFs.
For performance statistics, you could always use smfPricesByDates().
On Tue, Nov 21, 2017 at 2:56 AM, armando@
...
wrote:
>
> Good morning and thanks Randy.
>
> I use those elements for ETFs assessment.
>
> Is there another alternative to get those Data Elements? Other sources
> defined in the Add-In Data Elements such as IBD give Error message.
>
> -----Original Message-----
> From: "Randy Harmelink rharmelink@gmail.com [smf_addin]"
> Sent: Nov 18, 2017 7:17 PM
> To: smf_addin@yahoogroups.com
> Subject: Re: [smf_addin] DATA ELEMENTS 4671 THROUGH 4679 and 4947
>
>
>
> I'm getting a lot of timeouts on accessing the Morningstar web pages those
> elements come from. It could be that Morningstar is unplugging them. They
> are their old "print format" pages.
>
> Re: Yahoo mutual fund elements -- see: https://groups.google.
> com/d/msg/smf-addin/33cX75sYSlY/whTwlQmJCQAJ
>
> On Sat, Nov 18, 2017 at 11:42 AM, armando@
> ...
> wrote:
>
>> The DE in the caption stopped working. The 46xx series are from
>> Morningstar the 4947 from Yahoo.
>>
>> Any hints,
>>
>>
>>
For performance statistics, you could always use smfPricesByDates().
On Tue, Nov 21, 2017 at 2:56 AM, armando@
...
wrote:
>
> Good morning and thanks Randy.
>
> I use those elements for ETFs assessment.
>
> Is there another alternative to get those Data Elements? Other sources
> defined in the Add-In Data Elements such as IBD give Error message.
>
> -----Original Message-----
> From: "Randy Harmelink rharmelink@gmail.com [smf_addin]"
> Sent: Nov 18, 2017 7:17 PM
> To: smf_addin@yahoogroups.com
> Subject: Re: [smf_addin] DATA ELEMENTS 4671 THROUGH 4679 and 4947
>
>
>
> I'm getting a lot of timeouts on accessing the Morningstar web pages those
> elements come from. It could be that Morningstar is unplugging them. They
> are their old "print format" pages.
>
> Re: Yahoo mutual fund elements -- see: https://groups.google.
> com/d/msg/smf-
>
> On Sat, Nov 18, 2017 at 11:42 AM, armando@
> ...
> wrote:
>
>> The DE in the caption stopped working. The 46xx series are from
>> Morningstar the 4947 from Yahoo.
>>
>> Any hints,
>>
>>
>>
Thu Nov 23, 2017 7:45 pm (PST) . Posted by:
holmberg_tommy
Hi Randy,
For some reason this does not seem to be working anymore. What could be the reason?
Kind regards, Tommy
For some reason this does not seem to be working anymore. What could be the reason?
Kind regards, Tommy
Thu Nov 23, 2017 7:49 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Yahoo unplugged their current quotes CSV on 10/31, so RCHGetYahooQuotes()
is now dead. See the announcements blog for details and alternatives:
https://smf-add-in.blogspot.com/
On Thu, Nov 23, 2017 at 8:45 PM, holmberg_tommy@
...
wrote:
> For some reason this does not seem to be working anymore. What could be
> the reason?
>
>
>
is now dead. See the announcements blog for details and alternatives:
https://smf-add-in.blogspot.com/
On Thu, Nov 23, 2017 at 8:45 PM, holmberg_tommy@
...
wrote:
> For some reason this does not seem to be working anymore. What could be
> the reason?
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar