10 Messages
Digest #4288
2b
Re: Using GetYahooPortfolioView for a handful of Stocks and one stoc by "Randy Harmelink" rharmelink
Messages
Tue Jan 9, 2018 8:06 pm (PST) . Posted by:
sparkyjlg
Yes this works but pops up a box and opens up a separate spreadsheet. Is there a simple way to have the table open directly adjacent to the calling function in Excel, like your GETYAHOOHISTORY() provides yahoo quotes? Or is that functionality the "To Do" item
BTW suggest anyone advising Tiingo of spotted errors - unlike yahoo I've found they are interested & responsive in improving accuracy. So working with them seems like a good investment of my time....
BTW suggest anyone advising Tiingo of spotted errors - unlike yahoo I've found they are interested & responsive in improving accuracy. So working with them seems like a good investment of my time....
Tue Jan 9, 2018 10:31 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
The smfGetCSVFile() function I sent does display the data in the range it
is entered over. It shouldn't open up anything in a separate spreadsheet.
On Tue, Jan 9, 2018 at 9:06 PM, 1jkgriffin@
...
wrote:
>
> Yes this works but pops up a box and opens up a separate spreadsheet. Is
> there a simple way to have the table open directly adjacent to the calling
> function in Excel, like your GETYAHOOHISTORY() provides yahoo quotes? Or
> is that functionality the "To Do" item
>
> BTW suggest anyone advising Tiingo of spotted errors - unlike yahoo I've
> found they are interested & responsive in improving accuracy. So working
> with them seems like a good investment of my time....
>
is entered over. It shouldn'
On Tue, Jan 9, 2018 at 9:06 PM, 1jkgriffin@
...
wrote:
>
> Yes this works but pops up a box and opens up a separate spreadsheet. Is
> there a simple way to have the table open directly adjacent to the calling
> function in Excel, like your GETYAHOOHISTORY(
> is that functionality the "To Do" item
>
> BTW suggest anyone advising Tiingo of spotted errors - unlike yahoo I've
> found they are interested & responsive in improving accuracy. So working
> with them seems like a good investment of my time....
>
Wed Jan 10, 2018 8:56 pm (PST) . Posted by:
sparkyjlg
Just a final comment on the Tiingo API
A little web research for Excel shows how to use the Power Query to plug in the Tiingo web script for historical, pick whatever fields you want to display and set to refresh on open. And you can stack them side-by-side.
It isn't nearly as slick as your add-in but will meet my need perfectly for automation until something better comes along. For what I need Tiingo much better historic data than Yahoo.
A little web research for Excel shows how to use the Power Query to plug in the Tiingo web script for historical, pick whatever fields you want to display and set to refresh on open. And you can stack them side-by-side.
It isn't nearly as slick as your add-in but will meet my need perfectly for automation until something better comes along. For what I need Tiingo much better historic data than Yahoo.
Wed Jan 10, 2018 2:46 pm (PST) . Posted by:
lk1_2000
Hi, I'm using a "Master" list of mutual funds and stocks built with GetYahooPortfolioView in an Excel 2003 spreadsheet (Windows 7, 64). I added 9 stocks to my list today, and everything is working smoothly except ONE stock, Southern Company (SO) - nothing but the dreaded double dashes for the fields below.
Using =smfGetYahooPortfolioView(B4:B38,C2:G2,,1)
Any ideas? Is it just a SO thing for today, or is there something wrong?
15 78 79 17 52 Last Price Last Traded Date Last Traded Time Change % Chg
Thanks,
Linda
Using =smfGetYahooPortfol
Any ideas? Is it just a SO thing for today, or is there something wrong?
15 78 79 17 52 Last Price Last Traded Date Last Traded Time Change % Chg
Thanks,
Linda
Wed Jan 10, 2018 5:11 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
That's not much information to work with... :(
I just opened up the template and entered the SO ticker symbol, and it is
working fine. So it's not an issue with the ticker symbol.
What happens if you change the first ticker symbols in the list to be SO?
What do you get with:
=RCHGetElementNumber("Version")
On Wed, Jan 10, 2018 at 3:46 PM, lk1_2000@
...
wrote:
> Hi, I'm using a "Master" list of mutual funds and stocks built with
> GetYahooPortfolioView in an Excel 2003 spreadsheet (Windows 7, 64). I added
> 9 stocks to my list today, and everything is working smoothly except ONE
> stock, Southern Company (SO) - nothing but the dreaded double dashes for
> the fields below.
>
> Using =smfGetYahooPortfolioView(B4:B38,C2:G2,,1)
>
> Any ideas? Is it just a SO thing for today, or is there something wrong?
>
> 15 78 79 17 52
> Last Price Last Traded Date Last Traded Time Change % Chg
>
>
>
>
>
I just opened up the template and entered the SO ticker symbol, and it is
working fine. So it's not an issue with the ticker symbol.
What happens if you change the first ticker symbols in the list to be SO?
What do you get with:
=RCHGetElementNumbe
On Wed, Jan 10, 2018 at 3:46 PM, lk1_2000@
...
wrote:
> Hi, I'm using a "Master" list of mutual funds and stocks built with
> GetYahooPortfolioVi
> 9 stocks to my list today, and everything is working smoothly except ONE
> stock, Southern Company (SO) - nothing but the dreaded double dashes for
> the fields below.
>
> Using =smfGetYahooPortfol
>
> Any ideas? Is it just a SO thing for today, or is there something wrong?
>
> 15 78 79 17 52
> Last Price Last Traded Date Last Traded Time Change % Chg
>
>
>
>
>
Wed Jan 10, 2018 9:03 pm (PST) . Posted by:
"Barry Rosman" bnr0sman
I have been using it for month with the Portfolio view. Over the weekend it started tor freeze up calculating 17-22% of the spreadsheet and then froze.
It happens on both of my HP's. One old and one new.
Any suggestions?
Barry Rosman703-225-9857
It happens on both of my HP's. One old and one new.
Any suggestions?
Barry Rosman703-225-
Wed Jan 10, 2018 11:18 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Do you have just one smfGetYahooPortfolioView() function, or many? Are you
using any other functions with it? That is, could they be the problem?
Usually, when I see a "freeze", it's because a web page request is timing
out (usually takes about 60 seconds). And if you have multiple functions
going to that source of data, EACH request will be timing out. That could
create a LOOOOONG wait.
In any case, you can use the logging feature to attempt to see which web
requests are causing problems. See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/34208
On Wed, Jan 10, 2018 at 10:03 PM, Barry Rosman bnr0sman@
...
wrote:
>
> I have been using it for month with the Portfolio view. Over the weekend
> it started tor freeze up calculating 17-22% of the spreadsheet and then
> froze.
>
> It happens on both of my HP's. One old and one new.
>
> Any suggestions?
>
using any other functions with it? That is, could they be the problem?
Usually, when I see a "freeze", it's because a web page request is timing
out (usually takes about 60 seconds). And if you have multiple functions
going to that source of data, EACH request will be timing out. That could
create a LOOOOONG wait.
In any case, you can use the logging feature to attempt to see which web
requests are causing problems. See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/34208
On Wed, Jan 10, 2018 at 10:03 PM, Barry Rosman bnr0sman@
...
wrote:
>
> I have been using it for month with the Portfolio view. Over the weekend
> it started tor freeze up calculating 17-22% of the spreadsheet and then
> froze.
>
> It happens on both of my HP's. One old and one new.
>
> Any suggestions?
>
Thu Jan 11, 2018 6:43 am (PST) . Posted by:
"Higrm" higrm
Hello Randy,as I have several add-ins that provide context sensitive menu options, I do not see the SMF context sensitive menu option. Is there an alternative way to activate logging of a session on demand? Not having any issues, but would like to be able to trouble shoot any potential future problems myself if possible, via the logs.Thanks,Higrm
On Thursday, January 11, 2018, 8:19:23 AM GMT+1, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Do you have just one smfGetYahooPortfolioView() function, or many? Are you using any other functions with it? That is, could they be the problem? Usually, when I see a "freeze", it's because a web page request is timing out (usually takes about 60 seconds).. And if you have multiple functions going to that source of data, EACH request will be timing out. That could create a LOOOOONG wait.
In any case, you can use the logging feature to attempt to see which web requests are causing problems. See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/34208
On Wed, Jan 10, 2018 at 10:03 PM, Barry Rosman bnr0sman@... wrote:
I have been using it for month with the Portfolio view. Over the weekend it started tor freeze up calculating 17-22% of the spreadsheet and then froze.
It happens on both of my HP's. One old and one new.
Any suggestions?
On Thursday, January 11, 2018, 8:19:23 AM GMT+1, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Do you have just one smfGetYahooPortfolioView() function, or many? Are you using any other functions with it? That is, could they be the problem? Usually, when I see a "freeze", it's because a web page request is timing out (usually takes about 60 seconds).. And if you have multiple functions going to that source of data, EACH request will be timing out. That could create a LOOOOONG wait.
In any case, you can use the logging feature to attempt to see which web requests are causing problems. See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/34208
On Wed, Jan 10, 2018 at 10:03 PM, Barry Rosman bnr0sman@... wrote:
I have been using it for month with the Portfolio view. Over the weekend it started tor freeze up calculating 17-22% of the spreadsheet and then froze.
It happens on both of my HP's. One old and one new.
Any suggestions?
Thu Jan 11, 2018 7:24 am (PST) . Posted by:
"Randy Harmelink" rharmelink
I think you can use this function in a worksheet to turn on logging:
=smfLogInternetCalls("Y")
....and then, after doing several functions that need to do Internet
request, run this macro to open the log file:
smfOpenLogFile
....or just open the CSV file that gets created in the folder that the SMF
add-in is located in. The macro just opens it, adds some column headings,
and formats the date.
On Thu, Jan 11, 2018 at 7:43 AM, Higrm higrm@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> as I have several add-ins that provide context sensitive menu options, I
> do not see the SMF context sensitive menu option. Is there an alternative
> way to activate logging of a session on demand? Not having any issues, but
> would like to be able to trouble shoot any potential future problems myself
> if possible, via the logs.
>
>
=smfLogInternetCalls("Y")
....and then, after doing several functions that need to do Internet
request, run this macro to open the log file:
smfOpenLogFile
....or just open the CSV file that gets created in the folder that the SMF
add-in is located in. The macro just opens it, adds some column headings,
and formats the date.
On Thu, Jan 11, 2018 at 7:43 AM, Higrm higrm@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> as I have several add-ins that provide context sensitive menu options, I
> do not see the SMF context sensitive menu option. Is there an alternative
> way to activate logging of a session on demand? Not having any issues, but
> would like to be able to trouble shoot any potential future problems myself
> if possible, via the logs.
>
>
Thu Jan 11, 2018 8:14 am (PST) . Posted by:
"Higrm" higrm
I'll give it a try.Thanks!Higrm
On Thursday, January 11, 2018, 4:25:25 PM GMT+1, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
I think you can use this function in a worksheet to turn on logging:
=smfLogInternetCalls("Y")
....and then, after doing several functions that need to do Internet request, run this macro to open the log file:
smfOpenLogFile
....or just open the CSV file that gets created in the folder that the SMF add-in is located in. The macro just opens it, adds some column headings, and formats the date.
On Thu, Jan 11, 2018 at 7:43 AM, Higrm higrm@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
as I have several add-ins that provide context sensitive menu options, I do not see the SMF context sensitive menu option. Is there an alternative way to activate logging of a session on demand? Not having any issues, but would like to be able to trouble shoot any potential future problems myself if possible, via the logs.
On Thursday, January 11, 2018, 4:25:25 PM GMT+1, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
I think you can use this function in a worksheet to turn on logging:
=smfLogInternetCalls("Y")
....and then, after doing several functions that need to do Internet request, run this macro to open the log file:
smfOpenLogFile
....or just open the CSV file that gets created in the folder that the SMF add-in is located in. The macro just opens it, adds some column headings, and formats the date.
On Thu, Jan 11, 2018 at 7:43 AM, Higrm higrm@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
as I have several add-ins that provide context sensitive menu options, I do not see the SMF context sensitive menu option. Is there an alternative way to activate logging of a session on demand? Not having any issues, but would like to be able to trouble shoot any potential future problems myself if possible, via the logs.
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar