Sabtu, 30 Juni 2018

[smf_addin] Digest Number 4351

5 Messages

Digest #4351

Messages

Fri Jun 29, 2018 8:16 am (PDT) . Posted by:

JCHyjun

Hello,


smfGetYahooPortfolioView from SMF-AddIn ver. 2.1.2017.11.30 worked fine with Excel 2010 and Windows 7 but in new Windows 10 laptop with the same Excel 2010 quotes are not updated (I got the absolutely the same numbers checking quotes at 10AM and 11AM during open market).


SMF-AddIn ver. 2.1.2018.01.24 does NOT work at all in Windows 10 laptop. One point I noticed that new XLA file is smaller than previous one (Is it supposed to be?).



I reinstalled SMF-AddIn ver. 2.1.2017.11.30 back and got the same problem of frozen quotes.



How to fix the problem?


Thank you
JCH



Fri Jun 29, 2018 9:11 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

You are using the smfForceRecalculation macro to force updates, right?

If that's not updating your quotes, make sure you have your Internet Option
set to always get a fresh copy of a web page.

On Fri, Jun 29, 2018 at 8:16 AM, jchyjun@
​...
wrote:

>
> smfGetYahooPortfolioView from SMF-AddIn ver. 2.1.2017.11.30 worked fine
> with Excel 2010 and Windows 7 but in new Windows 10 laptop with the same
> Excel 2010 quotes are not updated (I got the absolutely the same numbers
> checking quotes at 10AM and 11AM during open market).
>
> SMF-AddIn ver. 2.1.2018.01.24 does NOT work at all in Windows 10 laptop.
> One point I noticed that new XLA file is smaller than previous one (Is it
> supposed to be?).
>
> I reinstalled SMF-AddIn ver. 2.1.2017.11.30 back and got the same problem
> of frozen quotes.
>
> How to fix the problem?
>
>

Sat Jun 30, 2018 2:39 am (PDT) . Posted by:

timdbui

Hello,


I am sure this question had been asked before, but could anyone please tell me what are the SMF element numbers to get the company name and its latest stock price? Thanks so much for your help! Tim

Sat Jun 30, 2018 2:50 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

For current quotes, take a look at the smfGetYahooPortfolioView() function.
Both documentation and template are on the website.

On Sat, Jun 30, 2018 at 2:28 AM, timdbui@
​...
wrote:

> I am sure this question had been asked before, but could anyone please
> tell me what are the SMF element numbers to get the company name and its
> latest stock price? Thanks so much for your help! Tim
>
>

Sat Jun 30, 2018 4:30 am (PDT) . Posted by:

timdbui

Thank you for your quick reply, Randy!
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar