Minggu, 27 November 2016

[smf_addin] Digest Number 3851

11 Messages

Digest #3851

Messages

Sat Nov 26, 2016 7:56 am (PST) . Posted by:

rjemery7

What RCH/SMF functions would I use to retrieve Google Finance data, both current and historical, particularly indexes not available 24/7 from Yahoo? Examples would be:


INDEXDJX:DJI
INDEXDJX:DJT
INDEXDJX:DJU
INDEXSP:SP600
INDEXDJX:GDOW
INDEXSP:SPE350
INDEXSP:SPG1200
INDEXDB:3BNB



For these I seek closing prices for most recent close, 1 month, 3 month, 6 month, etc.




Sat Nov 26, 2016 3:14 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Sorry, but I've given up using current quotes from Google. Every time I
give out a formula, they change their page within a few months.

I'm not a fan of Google Finance. Google has clearly indicated it is not
committed to providing good data.

It's too much work to get historical data from Google for a specific point
in time, because you'd need to verify it was a trading day. Besides, those
numbers are worthless for indexes, because the historical numbers won't
have the context of dividends paid.

For something like the DJIA index, you could always look at the DIA ETF.

Can you use the price performance table at BarChart?

https://www.barchart.com/stocks/quotes/%24DOWI/performance

=smfGetTagContent("https://www.barchart.com/stocks/quotes/$DOWI/performance","span",1,">
1-month",,,,1)

On Sat, Nov 26, 2016 at 8:56 AM, rjemery@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> What RCH/SMF functions would I use to retrieve Google Finance data, both
> current and historical, particularly indexes not available 24/7 from
> Yahoo? Examples would be:
>
> INDEXDJX:DJI
>
> INDEXDJX:DJT
>
> INDEXDJX:DJU
>
> INDEXSP:SP600
>
> INDEXDJX:GDOW
>
> INDEXSP:SPE350
>
> INDEXSP:SPG1200
>
> INDEXDB:3BNB
>
> For these I seek closing prices for most recent close, 1 month, 3 month, 6
> month, etc.
>
>

Sat Nov 26, 2016 8:01 am (PST) . Posted by:

rjemery7

What would be a reliable source for currencies and commodities data (current and historical), and what RCH/smf functions would I then use to retrieve that information?



Sat Nov 26, 2016 2:26 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Sorry. No idea. I don't do anything with currencies or commodities.

On Sat, Nov 26, 2016 at 9:01 AM, rjemery@
​...wrote:

> What would be a reliable source for currencies and commodities data
> (current and historical), and what RCH/smf functions would I then use to
> retrieve that information?
>
>

Sat Nov 26, 2016 8:04 am (PST) . Posted by:

rjemery7

For any ticker, how could I obtain the dates when the 52-week high and low occurred? What RCH/smf functions would I use?



Sat Nov 26, 2016 8:22 am (PST) . Posted by:

rjemery7

How would I retrieve the dates of when the 52-week high or low occurred? What RCH/smf functions should be used for that information?



Sat Nov 26, 2016 2:37 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

See the smfPricesBetween () function.

On Sat, Nov 26, 2016 at 9:22 AM, rjemery@
​...wrote:

> How would I retrieve the dates of when the 52-week high or low occurred?
> What RCH/smf functions should be used for that information?
>
>

Sat Nov 26, 2016 1:43 pm (PST) . Posted by:

CostelloT

Randy, Is the smfGetYahooOptionQuote function still working? My spreadsheet has not been working for the past few days.


Thanks,


Tony


Sat Nov 26, 2016 2:56 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

*sigh*

Yahoo changed the structure of the previous close and the header, which
contained the last price, change in $, and % change.

Everything else was still working though.

You should have given me a specific formula though. I checked bid and ask
prices, which still worked, and almost didn't look any further than that.

I've uploaded my changes with:

http://ogres-crypt.com/SMF/RCH_Stock_Market_Functions-2.1.2016.11.26.zip

However, it's unofficial, as I want to see how it works when the market is
open, to make sure Yahoo doesn't have a different page structure between a
closed and open market.

On Sat, Nov 26, 2016 at 2:43 PM, costellot@
​...wrote:

> Is the smfGetYahooOptionQuote function still working? My spreadsheet
> has not been working for the past few days.
>
>

Sat Nov 26, 2016 3:04 pm (PST) . Posted by:

CostelloT

Randy,
Sorry for the lack of information. I was trying to retrieve the "Last" price. Your fix worked great!

Your the man!

Tony

Sat Nov 26, 2016 2:30 pm (PST) . Posted by:

rvdidit


That happened to me several weeks ago. It did come back, I had my portfolio last week.
But now my email sometimes doesnt load. Error message says come back later. And I already drink...lol

---In smf_addin@yahoogroups.com, <ddockstader@...> wrote :

Anyone know what Yahoo is doing to their finance site? All of a sudden my portfolio has disappeared and I can't get anything with the smfGetYahooPortfolioView function. These guys may drive me to drink!
Dave



For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar