4 Messages
Digest #4494
Messages
Fri Mar 1, 2019 3:36 pm (PST) . Posted by:
aznshmlsguy
I am having trouble locating an updated version of the above template stated above. Can someone direct me?
Fri Mar 1, 2019 4:29 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Hmm. It's on the website, but not on the page listing all of the
templates...
http://ogres-crypt.com/SMF/Templates/smfGetYahooHistory-Example-By-Parameter.xls
On Fri, Mar 1, 2019 at 4:36 PM aznshmlsguy@... wrote:
> I am having trouble locating an updated version of the above template
> stated above. Can someone direct me?
>
>
>
templates...
http://ogres-crypt.com/SMF/Templates/smfGetYahooHistory-Example-By-Parameter.xls
On Fri, Mar 1, 2019 at 4:36 PM aznshmlsguy@
> I am having trouble locating an updated version of the above template
> stated above. Can someone direct me?
>
>
>
Fri Mar 1, 2019 6:09 pm (PST) . Posted by:
sjagers
Is anyone else having trouble getting stock prices tonight (Friday, 3/1/19, 6:00pm EST)?
I'm using smfPricesBetween and smfPricesByDates to get historical prices for a lot of stock symbols. This process has always worked flawlessly until tonight. Most symbols work correctly, but many return a blank. The symbols that don't work correctly are: ^DJI, ^GSPC, SRG, SWN, TCMD, TDW, ZIXI, SPPI, CLNY, CORE, XRAY, EBIX, KOP.
I can see all the prices and dates for those symbols on the Yahoo Finance Historical page, but they're not pulling into my Excel spreadsheet with the SMF Add-In.
I've tried several things to fix this -- run the recalculate macro, saved and reopened the spreadsheet, restarted my PC, try a different computer -- but they don't help.
This has not been a problem until tonight. Any ideas? Did Yahoo change their website again?
I think I'm using the latest version of the Add-In (RCH_Stock_Market_Functions-2.1.2018.01.24). My PC is Windows 10 with Excel 2007. FYI - My Windows Vista PC has the same problem.
Thanks.
I'm using smfPricesBetween and smfPricesByDates to get historical prices for a lot of stock symbols. This process has always worked flawlessly until tonight. Most symbols work correctly, but many return a blank. The symbols that don't work correctly are: ^DJI, ^GSPC, SRG, SWN, TCMD, TDW, ZIXI, SPPI, CLNY, CORE, XRAY, EBIX, KOP.
I can see all the prices and dates for those symbols on the Yahoo Finance Historical page, but they're not pulling into my Excel spreadsheet with the SMF Add-In.
I've tried several things to fix this -- run the recalculate macro, saved and reopened the spreadsheet, restarted my PC, try a different computer -- but they don't help.
This has not been a problem until tonight. Any ideas? Did Yahoo change their website again?
I think I'm using the latest version of the Add-In (RCH_Stock_Market_
Thanks.
Fri Mar 1, 2019 10:14 pm (PST) . Posted by:
"luther kinchen" lutherkinchen
The same exact thing happened to me this evening. I forced the recalculation several times and I was only getting about 1/2 of the prices pulling into the array.
I shut down and restarted excel twice and got the same result.
Went out for dinner, came back, rebooted excel and same result. I then hit f9 a time or two and clicked save file a couple times. When I looked back at the spreadsheet, all the prices were there.
I think it must have been a yahoo glitch. I hope they have it fixed for good p, because I'm back to normal again.
Good luck,
Luther
Sent from my iPad
> On Mar 1, 2019, at 8:09 PM, sjagers@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
> Is anyone else having trouble getting stock prices tonight (Friday, 3/1/19, 6:00pm EST)?
>
> I'm using smfPricesBetween and smfPricesByDates to get historical prices for a lot of stock symbols. This process has always worked flawlessly until tonight. Most symbols work correctly, but many return a blank. The symbols that don't work correctly are: ^DJI, ^GSPC, SRG, SWN, TCMD, TDW, ZIXI, SPPI, CLNY, CORE, XRAY, EBIX, KOP.
>
> I can see all the prices and dates for those symbols on the Yahoo Finance Historical page, but they're not pulling into my Excel spreadsheet with the SMF Add-In.
>
>
>
> I've tried several things to fix this -- run the recalculate macro, saved and reopened the spreadsheet, restarted my PC, try a different computer -- but they don't help.
>
>
>
> This has not been a problem until tonight. Any ideas? Did Yahoo change their website again?
>
> I think I'm using the latest version of the Add-In (RCH_Stock_Market_Functions-2.1.2018.01.24). My PC is Windows 10 with Excel 2007. FYI - My Windows Vista PC has the same problem.
>
>
>
> Thanks.
>
>
I shut down and restarted excel twice and got the same result.
Went out for dinner, came back, rebooted excel and same result. I then hit f9 a time or two and clicked save file a couple times. When I looked back at the spreadsheet, all the prices were there.
I think it must have been a yahoo glitch. I hope they have it fixed for good p, because I'm back to normal again.
Good luck,
Luther
Sent from my iPad
> On Mar 1, 2019, at 8:09 PM, sjagers@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
> Is anyone else having trouble getting stock prices tonight (Friday, 3/1/19, 6:00pm EST)?
>
> I'm using smfPricesBetween and smfPricesByDates to get historical prices for a lot of stock symbols. This process has always worked flawlessly until tonight. Most symbols work correctly, but many return a blank. The symbols that don't work correctly are: ^DJI, ^GSPC, SRG, SWN, TCMD, TDW, ZIXI, SPPI, CLNY, CORE, XRAY, EBIX, KOP.
>
> I can see all the prices and dates for those symbols on the Yahoo Finance Historical page, but they're not pulling into my Excel spreadsheet with the SMF Add-In.
>
>
>
> I've tried several things to fix this -- run the recalculate macro, saved and reopened the spreadsheet, restarted my PC, try a different computer -- but they don't help.
>
>
>
> This has not been a problem until tonight. Any ideas? Did Yahoo change their website again?
>
> I think I'm using the latest version of the Add-In (RCH_Stock_Market_
>
>
>
> Thanks.
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar