15 Messages
Digest #4192
Messages
Thu Nov 2, 2017 7:57 am (PDT) . Posted by:
weldenc
I'm trying to figure out how to use this function. I previously used RCHGetYahooQuotes. It's worked for many years and is a godsend.
I've downloaded the new ZIP file, V 2017.10.31 and installed it and downloaded the example spreadsheet, smfGetYahooPortfolioView-Example.xls. http://ogres-crypt.com/SMF/Templates/smfGetYahooPortfolioView-Example.xls
I can't seem to figure out how to add additional stock symbols to the list. When the example spreadsheet first loads, all the fields are populated. If I add a stock symbol in B7, I immediately get #NAME? in all cells. The contents of all cells are
='D:\SMF Add-in\RCH_Stock_Market_Functions.xla'!smfGetYahooPortfolioView($B$4:$B$411,$C$2:$AJ$2,,1)
Can someone give me a few clues about where to go from here? TIA
I've downloaded the new ZIP file, V 2017.10.31 and installed it and downloaded the example spreadsheet, smfGetYahooPortfolioView-Example.xls. http://ogres-crypt.com/SMF/Templates/smfGetYahooPortfolioView-Example.xls
I can't seem to figure out how to add additional stock symbols to the list. When the example spreadsheet first loads, all the fields are populated. If I add a stock symbol in B7, I immediately get #NAME? in all cells. The contents of all cells are
='D:\
Can someone give me a few clues about where to go from here? TIA
Thu Nov 2, 2017 8:06 am (PDT) . Posted by:
msdalt
Thanks, Randy. I have updated two workbooks with new arrays & references and they seem to be working quite well. I did find one anomaly, however. It does not require immediate attention but I thought you might find it interesting.
When I put in the symbol for Marathon Petroleum, "MPC", I get its information but all securities below it in the list are unable to access their data. I have tried this on several worksheets and consistently encounter the malfunction. I have relocated MPC's symbol to the end of the list as a workaround but thought you might want to know about this.
Gratefully,
Michael
When I put in the symbol for Marathon Petroleum, "MPC"
Gratefully,
Michael
Thu Nov 2, 2017 8:39 am (PDT) . Posted by:
higrm
I too am having problems like Michael, in that certain symbols prevent all others from appearing. CLF, HTGC, ARI, OAKS and CY all cause anything else below them to not appear, when using the smfGetYahooPortfolioView-Example.xls http://ogres-crypt.com/SMF/Templates/smfGetYahooPortfolioView-Example.xls . So I do not have the option of just putting the only problem symbol on the bottom, I'll need to create as many queries as problem symbols. (Some of the above listed Tickers do not return a Symbol in column C, and for HTGC only the HTG is provided. Peculiar.)
Darn. I hope Yahoo will undo whatever they've done that is preventing the good old RCHGetYahoo from working.
Thanks for your fantastic support Randy. I don't know how you manage it. Truly amazing.
Darn. I hope Yahoo will undo whatever they've done that is preventing the good old RCHGetYahoo from working.
Thanks for your fantastic support Randy. I don't know how you manage it. Truly amazing.
Thu Nov 2, 2017 8:47 am (PDT) . Posted by:
john_hoel
My problem sounds like this except that I can sometimes get more data back. I suspect the specific symbol is not the real issue. I think Yahoo is dynamically throttling.
Thu Nov 2, 2017 9:16 am (PDT) . Posted by:
jik0
Add me to the list. First noticed it wasn't working last night (11/1/2017 around 9 PM), worked fine the previous day. Not working this morning either (11/2, 9 am). No prior probs. Anyone have word on when it will be fixed?
Thu Nov 2, 2017 8:16 am (PDT) . Posted by:
codyklein
Just enter it like this for line by line:
=IF(B6="","",smfGetYahooPortfolioView(B6,"03"))
B6 is the ticker cell and in this case "03" is the co. name
The problem I had with the array is all the information below the first line disappears in some instances. Entering line by line seems to solve that problem.
=IF(B6="
B6 is the ticker cell and in this case "03" is the co. name
The problem I had with the array is all the information below the first line disappears in some instances. Entering line by line seems to solve that problem.
Thu Nov 2, 2017 9:30 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Because I don't want Yahoo inundated with data requests. I can't think of a
better reason for them to stop providing FREE data.
The reason to do it array-entered is so that only one request for data
needs to go to Yahoo for possibly hundreds of data items.
On Thu, Nov 2, 2017 at 7:39 AM, cooler_king@
...
wrote:
> I'm not sure why you would need to do this as an array. Is there an
> functionality where it just works line by line? I know that is less
> efficient, but that's how I use the add in.
>
> I'm not actually sure how the array works from the example, anyways.
>
better reason for them to stop providing FREE data.
The reason to do it array-entered is so that only one request for data
needs to go to Yahoo for possibly hundreds of data items.
On Thu, Nov 2, 2017 at 7:39 AM, cooler_king@
...
wrote:
> I'm not sure why you would need to do this as an array. Is there an
> functionality where it just works line by line? I know that is less
> efficient, but that's how I use the add in.
>
> I'm not actually sure how the array works from the example, anyways.
>
Thu Nov 2, 2017 9:16 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
That's the plan...
On Thu, Nov 2, 2017 at 5:29 AM, 'V. Shankar' tarakayan@
...
wrote:
>
> Ok. I switched To smfgetyahoo....So we wait for a while to see if
> RCHGetYahooQuotes works?
> Thanks..
>
>
>
On Thu, Nov 2, 2017 at 5:29 AM, 'V. Shankar' tarakayan@
...
wrote:
>
> Ok. I switched To smfgetyahoo.
> RCHGetYahooQuotes works?
> Thanks..
>
>
>
Thu Nov 2, 2017 9:20 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Sorry, no. I had that before and it caused problems...and the last thing I
want to do is have people doing a web page retrieval for a single item for
each of hundreds of ticker symbols.
On Thu, Nov 2, 2017 at 6:28 AM, elandry@
...
wrote:
> Like the others, I much appreciate the work you do on this excellent
> add-in! Was wondering if you've considered creating a get element function
> for the last price from the Yahoo KS page or or some other page as a backup
> for when the GetYahooQuotes server is acting up.
>
>
>
want to do is have people doing a web page retrieval for a single item for
each of hundreds of ticker symbols.
On Thu, Nov 2, 2017 at 6:28 AM, elandry@
...
wrote:
> Like the others, I much appreciate the work you do on this excellent
> add-in! Was wondering if you've considered creating a get element function
> for the last price from the Yahoo KS page or or some other page as a backup
> for when the GetYahooQuotes server is acting up.
>
>
>
Thu Nov 2, 2017 9:27 am (PDT) . Posted by:
indinvestor111
Thanks for the reply. I'll look at the work around released this AM.
Thu Nov 2, 2017 9:24 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Please don't do something like that for a number of stocks. I don't want
Yahoo to be burdened down with requests for individual data items, when the
function can get data for hundreds of stocks in one go. It's just not fair
to burden a free source of data with unnecessary data requests.
If you only need one or two, it would be:
=smfGetYahooPortfolioView("XOM","15")
On Thu, Nov 2, 2017 at 6:29 AM, bob_15861586@
...
wrote:
> I am hoping to use the function smfGetYahooPortfolioView to get the last
> value of a stock given its stock symbol. I was hoping to find detailed
> documentation on how this function works but I failed to find it. What I
> would like is to be able to place in a cell, something like: =
> smfGetYahooPortfolioView("XOM") and have the last value of XOM appear in
> the cell. By the way, XOM is the stock symbol for Exxon Mobil. Please tell
> me how to do this.
>
>
>
Yahoo to be burdened down with requests for individual data items, when the
function can get data for hundreds of stocks in one go. It's just not fair
to burden a free source of data with unnecessary data requests.
If you only need one or two, it would be:
=smfGetYahooPortfol
On Thu, Nov 2, 2017 at 6:29 AM, bob_15861586@
...
wrote:
> I am hoping to use the function smfGetYahooPortfoli
> value of a stock given its stock symbol. I was hoping to find detailed
> documentation on how this function works but I failed to find it. What I
> would like is to be able to place in a cell, something like: =
> smfGetYahooPortfoli
> the cell. By the way, XOM is the stock symbol for Exxon Mobil. Please tell
> me how to do this.
>
>
>
Thu Nov 2, 2017 9:25 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I've been noticing some issues myself. Not sure what's up.
On Thu, Nov 2, 2017 at 7:20 AM, john@
...
wrote:
>
> Yesterday I changed to smfGetYahooPortfolioView() with array-entry and it
> worked flawlessly. Today it mostly does not work. I get either the first
> cell only, or the first few cells only, or the function is entirely ignored.
>
> I tried recreating the array entry but nothing changed. I tried completely
> closing Excel, then reopen, no change.
>
>
>
On Thu, Nov 2, 2017 at 7:20 AM, john@
...
wrote:
>
> Yesterday I changed to smfGetYahooPortfoli
> worked flawlessly. Today it mostly does not work. I get either the first
> cell only, or the first few cells only, or the function is entirely ignored.
>
> I tried recreating the array entry but nothing changed. I tried completely
> closing Excel, then reopen, no change.
>
>
>
Thu Nov 2, 2017 9:39 am (PDT) . Posted by:
jaroldm70
Randy,
Check this out........https://stackoverflow.com/questions/44057580/yahoo-finance-api-changes-2017 https://stackoverflow.com/questions/44057580/yahoo-finance-api-changes-2017
May have to use Google as data source?
Check this out........https://stackoverflow.com/questions/44057580/yahoo-finance-api-changes-2017 https://stackoverflow.com/questions/44057580/yahoo-finance-api-changes-2017
May have to use Google as data source?
Thu Nov 2, 2017 9:39 am (PDT) . Posted by:
royy22
smfPricesByDates works fine for me with the dates across columns left to right and the results left to right across columns (eg, horizontal), however, when I run it Vertical (col of date, col of results) I get the first price propagated across all dates. Am I misreading the documentation, cause it sounds like that should work?
Thanks for any tips on the solving this.
PricebyDates NOT WORKING Vertical!
Date
PriceByDates 9/30/17 AAPL 154.12 8/31/17
154.12 7/31/17
154.12 6/30/17
154.12 5/31/17 154.12
Thanks for any tips on the solving this.
PricebyDates NOT WORKING Vertical!
Date
PriceByDates 9/30/17 AAPL 154.12 8/31/17
154.12 7/31/17
154.12 6/30/17
154.12 5/31/17 154.12
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar