4 Messages
Digest #4557
Messages
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
strTempRevenue = smfJSGetYahooJSON(
strTempCGS = smfJSGetYahooJSON(
strTempNetIncome = smfJSGetYahooJSON(
strTempInventories = smfJSGetYahooJSON(
strTempAssets = smfJSGetYahooJSON(
strTempEquity = smfJSGetYahooJSON(
Also, no big deal but =RCHGetElementNumbe
Carl Mims
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?
>
>
>
=smfGetYahooJSONFie
I don't know what your formulas are doing.
There is an updates (and undocumented change) to smf-elements-
website for company names. But smfGetYahooPortfoli
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(
> "totalRevenue&
> strTempCGS = smfJSGetYahooJSON(
> "costOfRevenue
> strTempNetIncome = smfJSGetYahooJSON(
> "netIncome&quo
> strTempInventories = smfJSGetYahooJSON(
> "inventory&quo
> strTempAssets = smfJSGetYahooJSON(
> "totalAssets&q
> strTempEquity = smfJSGetYahooJSON(
> "totalStockhol
>
>
> Also, no big deal but =RCHGetElementNumbe
> Company Name…Did that change?
>
>
>
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
Sorry, weekend is investment time and this one was hectic.
With your specific formula, I get only headers
For more information, for me
=smfpricesbydates(
& for two dates in A50 & B50, say 10 month apart & 100 is days for SMA
=INDEX(SMFTech(
Thanks for your patience.
Also important, What excel version are you trying with? I have 2007 on Windows 7
Regards
Amit
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
>
>
Yahoo had a glitch when you tried it? Try running the smfForceRecalculati
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(
> & for two dates in A50 & B50, say 10 month apart & 100 is days for SMA
>
> =
> INDEX(SMFTech(
>
> Thanks for your patience.
>
> Also important, What excel version are you trying with? I have 2007 on
> Windows 7
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar