[smf_addin] Digest Number 4557

EXCEL Stock Market Functions Add-in Group

4 Messages

Digest #4557

1a

Json Yahoo problem by "Carl Mims" aab3c65c4611ee62fa3f26b79f046867

1b

Re: Json Yahoo problem by "Randy Harmelink" rharmelink

2.1

Re: RCHGetYahooHistory by amitc@ymail.com

2.2

Re: RCHGetYahooHistory by "Randy Harmelink" rharmelink

Messages

1a

Json Yahoo problem

Sun Jun 16, 2019 7:33 pm (PDT) . Posted by:

"Carl Mims" aab3c65c4611ee62fa3f26b79f046867

I have been using the following to GetYahooJSON from within Visual Basic for some time with no problems. However, now I am getting 0 for TotalRevenue. Did something change

strTempRevenue = smfJSGetYahooJSON(strStockSymbol(intCurrent), "totalRevenue")
strTempCGS = smfJSGetYahooJSON(strStockSymbol(intCurrent), "costOfRevenue")
strTempNetIncome = smfJSGetYahooJSON(strStockSymbol(intCurrent), "netIncome")
strTempInventories = smfJSGetYahooJSON(strStockSymbol(intCurrent), "inventory")
strTempAssets = smfJSGetYahooJSON(strStockSymbol(intCurrent), "totalAssets")
strTempEquity = smfJSGetYahooJSON(strStockSymbol(intCurrent), "totalStockholderEquity")

Also, no big deal but =RCHGetElementNumber($C$1,13863). No longer gets Company Name…Did that change?

Carl Mims

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

1b

Re: Json Yahoo problem

Sun Jun 16, 2019 10:46 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Total revenue is working fine for me:

=smfGetYahooJSONField("MMM","financialData","quoteSummary.result.0.financialData.totalRevenue.raw")

I don't know what your formulas are doing.

There is an updates (and undocumented change) to smf-elements-2.txt on the
website for company names. But smfGetYahooPortfolioView() is probably a
better way to go because it can get a number of them in one Internet access..

On Sun, Jun 16, 2019 at 7:33 PM Carl Mims carlmims@... wrote:

> I have been using the following to GetYahooJSON from within Visual Basic
> for some time with no problems. However, now I am getting 0 for
> TotalRevenue. Did something change
>
> strTempRevenue = smfJSGetYahooJSON(strStockSymbol(intCurrent),
> "totalRevenue")
> strTempCGS = smfJSGetYahooJSON(strStockSymbol(intCurrent),
> "costOfRevenue")
> strTempNetIncome = smfJSGetYahooJSON(strStockSymbol(intCurrent),
> "netIncome")
> strTempInventories = smfJSGetYahooJSON(strStockSymbol(intCurrent),
> "inventory")
> strTempAssets = smfJSGetYahooJSON(strStockSymbol(intCurrent),
> "totalAssets")
> strTempEquity = smfJSGetYahooJSON(strStockSymbol(intCurrent),
> "totalStockholderEquity")
>
>
> Also, no big deal but =RCHGetElementNumber($C$1,13863). No longer gets
> Company Name…Did that change?
>
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

2.1

Re: RCHGetYahooHistory

Sun Jun 16, 2019 11:09 pm (PDT) . Posted by:

amitc@ymail.com

Hi Randy,

Sorry, weekend is investment time and this one was hectic.
With your specific formula, I get only headers


For more information, for me

=smfpricesbydates("GLD",DATE(2019,6,7)) = N/A

& for two dates in A50 & B50, say 10 month apart & 100 is days for SMA


=INDEX(SMFTech(RCHGetYahooHistory("GLD,YEAR($B50),MONTH($B50),DAY($B50),YEAR($A50),MONTH($A50),DAY($A50),,,,1,1,100+1,6),"SMA",100),100+1)



Thanks for your patience.


Also important, What excel version are you trying with? I have 2007 on Windows 7


Regards
Amit

Reply to sender . Reply to group . Reply via Web Post . All Messages (56) . Top ^

2.2

Re: RCHGetYahooHistory

Sun Jun 16, 2019 11:40 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Not sure what to tell you. Both of your formulas work fine here. Maybe
Yahoo had a glitch when you tried it? Try running the smfForceRecalculation
macro.

It could be that Yahoo no longer works with your version of the IE object
that EXCEL uses? Can you visit the historical quotes page using the "From
Web (Legacy)" option?

On Sun, Jun 16, 2019 at 11:13 PM ac11@... wrote:

>
> Sorry, weekend is investment time and this one was hectic.
> With your specific formula, I get only headers
>
> For more information, for me
> =smfpricesbydates("GLD",DATE(2019,6,7)) = N/A
> & for two dates in A50 & B50, say 10 month apart & 100 is days for SMA
>
> =
> INDEX(SMFTech(RCHGetYahooHistory("GLD,YEAR($B50),MONTH($B50),DAY($B50),YEAR($A50),MONTH($A50),DAY($A50),,,,1,1,100+1,6),"SMA",100),100+1)
>
> Thanks for your patience.
>
> Also important, What excel version are you trying with? I have 2007 on
> Windows 7
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (56) . Top ^

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

Visit Your Group

• Privacy • Unsubscribe • Terms of Use