Kamis, 09 November 2017

[smf_addin] Digest Number 4225[1 Attachment]

7 Messages

Digest #4225

Messages

Thu Nov 9, 2017 4:13 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

They seem to be working here:

01 15 87 17 18 19 20 21 00 51 52
*Ticker Symbol* *Symbol* *Last Price* *Last Traded Date/Time* *Change*
*Open* *High* *Low* *Volume* *--* *Prev Close* *% Chg*
LGMAX LGMAX $22.03 2017-11-09 06:46:03 PM -$0.08 -- -- -- -- -- $22.11
-0.36%
BIICX BIICX $11.06 2017-11-09 06:45:06 PM -$0.03 -- -- -- -- -- $11.09
-0.27%

Maybe depends on when things get updated?

On Thu, Nov 9, 2017 at 4:59 PM, Michael Thomas thomas91112@
​...
wrote:

>
> Can't seem to get Prev Close to work for Mutual Funds (LGMAX, BIICX,
> etc.), Last Price works fine. Plugged these tickers into the example
> spreadsheet you provided with the same results....must be a problem with
> Mutual Funds.
>
>

Thu Nov 9, 2017 4:22 pm (PST) . Posted by:

rr76012



Here is the version of smf-addin I am running is this the latest?


Stock Market Functions add-in, Version 2.1.2017.11.02 (C:\Program Files\SMF Add-In; Windows (32-bit) NT 6.02; 14.0; ; ; 1)




Do I need to download a newer version smf-addin to work with the :


smfGetYahooPortfolio spreadsheet? and get these downloads : smfGetYahooPortfolio 40,41,63,66,51,52


Thank You.


rr76012


Thu Nov 9, 2017 4:27 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

The latest release is 2017.11.08. See https://smf-add-in.blogspot.com and
http://ogres-crypt.com/SMF/

There were a number of smfGetYahooPortfolioView() changes since 2017.11.02.

There are currently two minor fixes for the function that are in the
pipeline and not released.

On Thu, Nov 9, 2017 at 5:22 PM, rr76012@
​...
wrote:

>
> Here is the version of smf-addin I am running is this the latest?
>
> Stock Market Functions add-in, Version 2.1.2017.11.02 (C:\Program
> Files\SMF Add-In; Windows (32-bit) NT 6.02; 14.0; ; ; 1)
>
> Do I need to download a newer version smf-addin to work with the :
>
> smfGetYahooPortfolio spreadsheet? and get these downloads
> : smfGetYahooPortfolio 40,41,63,66,51,52
>
>
>

Thu Nov 9, 2017 5:05 pm (PST) . Posted by:

pauljl52

https://core-api.barchart.com/v1/quotes/get?symbols=MMM&fields=symbol,lastPrice

I am having issues running smfGetBarchartPortfolioView-Example.xls on a WinXP machine with IE8 (Which I never use, i.e . IE8) all other aspects of smf including smfGetYahooPortfolioView.-example.xls run fine on this machine. I use this machine to run my Excel spreadsheets.

I decided to give this a try:
I have another machine running Win7 Pro with IE11 smfGetBarchartPortfolioView-Example.xls is running fine on this machine Even though IE 11 is having problems resolving address you suggested I try.

https://core- api.barchart.com/v1/quotes/ get?symbols=MMM&fields=symbol, lastPrice https://core-api.barchart.com/v1/quotes/get?symbols=MMM&fields=symbol,lastPrice

Using Firefox I get:
{"count":1,"total":1,"data":[{"symbol":"MMM","lastPrice":"228.39"}],"errors":null} as well on both computers
Both IE 8 and IE 11 have problems resolving this address:

Any ideas?

Thanks

Thu Nov 9, 2017 5:16 pm (PST) . Posted by:

borat_rules

Hey Randy I have attached my simple test file.

I also attached a screenshot of what I see on my screen when I typed in those 3 formulas which are in A6, A7 and A8.


thanks for taking a look, appreciate it.


SH
Attachment(s) from
1 of 1 File(s)

Thu Nov 9, 2017 5:18 pm (PST) . Posted by:

borat_rules

For some reason it will not allow me to attach the screenshot so the three cells have the following results on my computer

Stock Market Functions add-in, Version 2.1.2017.11.08 (C:\Utils\RCH_Stock_Market_Functions-2.1.2017.11.08; Windows (32-bit) NT 6.02; 14.0; ; ; 1)



228.39



{"count":1,"total":1,"data":[{"symbol":"MMM","lastPrice":"228.39"}],"errors":null}



cheers,


SH

Thu Nov 9, 2017 6:29 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

What I do see wrong is that you array-entered:

=smfGetYahooPortfolioView($A$3:$A$4,$B$1:$C$1,,1)

...into each individual cell instead of array-entering it once over the
entire range.

You should be array-entering it over the B2:C4 range.

I got #NAME? errors on your workbook until I ran the smfFixLinks, because
your add-in is in a different location than mine. And that means you will
have similar issues with the example worksheets I posted, until you correct
those unresolved links using the smfFixLinks macro.

I didn't see any screenshots, but I think I saw what I needed to see.

On Thu, Nov 9, 2017 at 6:16 PM, borat_rules@
​...
wrote:

>
> Hey Randy I have attached my simple test file.
>
> I also attached a screenshot of what I see on my screen when I typed in
> those 3 formulas which are in A6, A7 and A8.
>
> thanks for taking a look, appreciate it.
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 18.36

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)