11 New Messages
Digest #2928
Messages
Tue Jan 14, 2014 1:12 am (PST) . Posted by:
jsawyermib
Hi Randy
Works perfectly now. Again, thank you very much indeed. All your work and support is very much appreciated.
Kind regards
John
Works perfectly now. Again, thank you very much indeed. All your work and support is very much appreciated.
Kind regards
John
Tue Jan 14, 2014 6:17 am (PST) . Posted by:
mikemcq802
I found Yahoo's explanation of adjusted prices. Here is the link to it:
As tiny: http://tinyurl.com/kmtujyr
Full Link: http://help.yahoo.com/kb/index?locale=en_US&page=content&y=PROD_FIN&id=SLN2311&actp=lorax&pir=dlpn2rFibUmgTbRc0Kjp4XNrqef.Qqf9gfo4FlvCDWTxwVqSueoAahXhWOmMtBX5CyVDQT9r5KdwzHHb
Here is the link to the CRSP calculations Yahoo references:
http://www.crsp.com/products/documentation/crsp-calculations
As tiny: http://tinyurl.
Full Link: http://help.
Here is the link to the CRSP calculations Yahoo references:
http://www.crsp.
Tue Jan 14, 2014 12:10 pm (PST) . Posted by:
bkipersztok
Thank you guys for your input. I was unaware that the adjusted prices accounted for dividends. So now the next step would be to use the smfPricesByDates() function to import the data by date. Thanks again!
Tue Jan 14, 2014 7:19 am (PST) . Posted by:
john.kalkanis
Hi Randy. Starting today wmf is extremely slow and get easily stuck in simple calculations. attached is a screenshot of excel debugger. it highlights in yellow a probable error. can you please tell me what I should do to fix it? thanks
john
john
Attachments with this message:
1 of 1 Photo(s)
Tue Jan 14, 2014 9:34 am (PST) . Posted by:
"Randy Harmelink" rharmelink
What you have highlighted is just a call to another subroutine, so I don't
know why it would get highlighted as a probable error.
In all likelihood, any slowness is probably due to a slow website. There
have been a number of example recently of slow response times from Yahoo.
I one had a workbook grind to a halt, only to find out it was because the
Zacks website was down. But each request for a web page from their site had
to "time out" before the add-in could continue on to get the next web page
for data extraction.
On Tue, Jan 14, 2014 at 8:19 AM, <john.kalkanis@yahoo.com> wrote:
>
> Hi Randy. Starting today wmf is extremely slow and get easily stuck in
> simple calculations. attached is a screenshot of excel debugger. it
> highlights in yellow a probable error. can you please tell me what I should
> do to fix it? thanks
>
know why it would get highlighted as a probable error.
In all likelihood, any slowness is probably due to a slow website. There
have been a number of example recently of slow response times from Yahoo.
I one had a workbook grind to a halt, only to find out it was because the
Zacks website was down. But each request for a web page from their site had
to "time out" before the add-in could continue on to get the next web page
for data extraction.
On Tue, Jan 14, 2014 at 8:19 AM, <john.kalkanis@
>
> Hi Randy. Starting today wmf is extremely slow and get easily stuck in
> simple calculations. attached is a screenshot of excel debugger. it
> highlights in yellow a probable error. can you please tell me what I should
> do to fix it? thanks
>
Tue Jan 14, 2014 10:06 am (PST) . Posted by:
john.kalkanis
I am using OX/OX2. the problem is that any new formula I insert, the sheet gets blocked again for 3-4 min (even if the previous block was only few minutes before). too strange. it shouldn't retrieve data so often
Tue Jan 14, 2014 10:17 am (PST) . Posted by:
"Randy Harmelink" rharmelink
I know OptionsXPress was very slow last night when I was looking up a few
things. But they seem to be back to their normal speed when I tried them
today. However, they are slower than most sites.
If it seems like everything is being recalculated every time, you may have
somehow made your formulas volatile. That can happen if you do something
like used NOW() or TODAY() as a source for creating dates.
On Tue, Jan 14, 2014 at 11:06 AM, <john.kalkanis@yahoo.com> wrote:
> I am using OX/OX2. the problem is that any new formula I insert, the
> sheet gets blocked again for 3-4 min (even if the previous block was only
> few minutes before). too strange. it shouldn't retrieve data so often
>
things. But they seem to be back to their normal speed when I tried them
today. However, they are slower than most sites.
If it seems like everything is being recalculated every time, you may have
somehow made your formulas volatile. That can happen if you do something
like used NOW() or TODAY() as a source for creating dates.
On Tue, Jan 14, 2014 at 11:06 AM, <john.kalkanis@
> I am using OX/OX2. the problem is that any new formula I insert, the
> sheet gets blocked again for 3-4 min (even if the previous block was only
> few minutes before). too strange. it shouldn'
>
Tue Jan 14, 2014 7:04 pm (PST) . Posted by:
"ridgebacksexcel" ridgebacksexcel
I have updated my computer to Windows 8.1 and have all my spreadsheets located in my Skydrive folder.
Every time I open an Excel spreadsheet that wants to use the SMF add in, I get a location error for the add in as it cannot locate it on Skydrive.
I go to edit links and change the source to Program files/SMF Add in folder on my C: drive where I keep the add in. I save the Excel file, it uploads to Skydrive.
I then open it again from my skydrive folder and get the same error even though I edited the link location.
Has anyone else figured out how to get this to work without editing the link every time you open an Excel file with the Add In?
Every time I open an Excel spreadsheet that wants to use the SMF add in, I get a location error for the add in as it cannot locate it on Skydrive.
I go to edit links and change the source to Program files/SMF Add in folder on my C: drive where I keep the add in. I save the Excel file, it uploads to Skydrive.
I then open it again from my skydrive folder and get the same error even though I edited the link location.
Has anyone else figured out how to get this to work without editing the link every time you open an Excel file with the Add In?
Tue Jan 14, 2014 7:48 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I think the problem is that EXCEL can't resolve links to a network drive.
Can you just use the smfFixLinks macro?
On Tue, Jan 14, 2014 at 8:04 PM, ridgebacksexcel <tmallen2@bellsouth.net>wrote:
> I have updated my computer to Windows 8.1 and have all my spreadsheets
> located in my Skydrive folder.
>
> Every time I open an Excel spreadsheet that wants to use the SMF add in, I
> get a location error for the add in as it cannot locate it on Skydrive.
>
> I go to edit links and change the source to Program files/SMF Add in
> folder on my C: drive where I keep the add in. I save the Excel file, it
> uploads to Skydrive.
>
> I then open it again from my skydrive folder and get the same error even
> though I edited the link location.
>
> Has anyone else figured out how to get this to work without editing the
> link every time you open an Excel file with the Add In?
>
Can you just use the smfFixLinks macro?
On Tue, Jan 14, 2014 at 8:04 PM, ridgebacksexcel <tmallen2@bellsouth.
> I have updated my computer to Windows 8.1 and have all my spreadsheets
> located in my Skydrive folder.
>
> Every time I open an Excel spreadsheet that wants to use the SMF add in, I
> get a location error for the add in as it cannot locate it on Skydrive.
>
> I go to edit links and change the source to Program files/SMF Add in
> folder on my C: drive where I keep the add in. I save the Excel file, it
> uploads to Skydrive.
>
> I then open it again from my skydrive folder and get the same error even
> though I edited the link location.
>
> Has anyone else figured out how to get this to work without editing the
> link every time you open an Excel file with the Add In?
>
Tue Jan 14, 2014 9:20 pm (PST) . Posted by:
bizmark_ee
1) I am seeing the same issue with intermittent, extreme slowness and some cells coming back with "Error". I am using array formulas which use RCHGetYahooQuotes(). Anyone know if Yahoo is purposefully throttling or not?
2) For the issue of blank cells, why not just use a formula like, =IF($D29<>"",RCHGetYahooQuotes($D29, "c1p2a2",,,0),"") , where column D has the tickers? Or are we not talking about the same thing?
2) For the issue of blank cells, why not just use a formula like, =IF($D29<
Tue Jan 14, 2014 9:27 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
We're not talking about the same thing.
The issue is when you do a multi-row range with RCHGetYahooQuotes(), and
have blank cells in the ticker range. What gets returned from Yahoo is
shifted a line up.
I think I'll go ahead and use the "XXXXXX" in place of any blanks. At least
it takes care of the most common situation.
On Tue, Jan 14, 2014 at 10:20 PM, <dustinsmoak@live.com> wrote:
>
> 1) I am seeing the same issue with intermittent, extreme slowness and some
> cells coming back with "Error". I am using array formulas which use
> RCHGetYahooQuotes(). Anyone know if Yahoo is purposefully throttling or
> not?
> 2) For the issue of blank cells, why not just use a formula like,
> =IF($D29<>"",RCHGetYahooQuotes($D29, "c1p2a2",,,0),"") , where column D has
> the tickers? Or are we not talking about the same thing?
>
The issue is when you do a multi-row range with RCHGetYahooQuotes(
have blank cells in the ticker range. What gets returned from Yahoo is
shifted a line up.
I think I'll go ahead and use the "XXXXXX" in place of any blanks. At least
it takes care of the most common situation.
On Tue, Jan 14, 2014 at 10:20 PM, <dustinsmoak@
>
> 1) I am seeing the same issue with intermittent, extreme slowness and some
> cells coming back with "Error"
> RCHGetYahooQuotes(
> not?
> 2) For the issue of blank cells, why not just use a formula like,
> =IF($D29<
> the tickers? Or are we not talking about the same thing?
>
Tidak ada komentar:
Posting Komentar