7 Messages
Digest #3364
2b
Re: Rchgetelementnumber, ADVFN, retrieving right symbol, wrong compa by "Randy Harmelink" rharmelink
Messages
Sat Mar 21, 2015 5:41 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
As Sal noted, these steps usually help when pointers to the add-in get all
messed up (for whatever reason):
1. Go to the add-in manager and uncheck the add-in (i.e. existing pointed
to location)
2. Exit EXCEL (to purge any connection to the old location)
3. Restart EXCEL
4. Go to the add-in manager and put the add-in back into the list, using
its correct location
5. Exit EXCEL (to save the new settings)
6. Restart EXCEL
Since you want to use AdvFN, I'd add a step 2.5 which is to update the
files in your add-in folder to the ZIP archive in the "Works in Progress"
folder. After step 6, try opening your workbook again. If not working, let
me know what this returns:
=RCHGetElementNumber("Version")
The EXCEL workbook you attached worked fine for me.
On Fri, Mar 20, 2015 at 9:48 PM, Joe jtassielli2003@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I attached a spreadsheet. The tab "hard copy" is values copied when I
> open spreadsheet. The other, is with formulas.
>
> There are no unresolved links. I run the "fix links macro" if this should
> occur. I downloaded the beta version, deleted the 01.30.15 version.
>
> Also, I get this (print screen below) message when I open my workbooks.
> Not sure why?
>
> *"Can you localize it to a single formula, save it in a workbook, and open
> it, to repeat the error. If so, does the formula look any differently after
> you open the file?"*
>
> NO. running the "fix links" macro, should take care of this.
>
>
>
messed up (for whatever reason):
1. Go to the add-in manager and uncheck the add-in (i.e. existing pointed
to location)
2. Exit EXCEL (to purge any connection to the old location)
3. Restart EXCEL
4. Go to the add-in manager and put the add-in back into the list, using
its correct location
5. Exit EXCEL (to save the new settings)
6. Restart EXCEL
Since you want to use AdvFN, I'd add a step 2.5 which is to update the
files in your add-in folder to the ZIP archive in the "Works in Progress"
folder. After step 6, try opening your workbook again. If not working, let
me know what this returns:
=RCHGetElementNumber("Version")
The EXCEL workbook you attached worked fine for me.
On Fri, Mar 20, 2015 at 9:48 PM, Joe jtassielli2003@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I attached a spreadsheet. The tab "hard copy" is values copied when I
> open spreadsheet. The other, is with formulas.
>
> There are no unresolved links. I run the "fix links macro" if this should
> occur. I downloaded the beta version, deleted the 01.30.15 version.
>
> Also, I get this (print screen below) message when I open my workbooks.
> Not sure why?
>
> *"Can you localize it to a single formula, save it in a workbook, and open
> it, to repeat the error. If so, does the formula look any differently after
> you open the file?"*
>
> NO. running the "fix links" macro, should take care of this.
>
>
>
Sat Mar 21, 2015 1:52 pm (PDT) . Posted by:
"Joe" jtassielli2003
Randy, Sal.
=RCHGetElementNumber("Version"), I get,"
|
Stock Market Functions add-in, Version 2.1.2015.03.05 (C:\SMF Add-In\RCH_Stock_Market_Functions-2.1.2015.03.15; ; ; 2) | |
Still haven't got all cells to work. Attached spreadsheet, hard copy tab is values I'm getting. Formula tab, is with formulas.
"Since you want to use AdvFN, I'd add a step 2.5 which is to update the files in your add-in folder to the ZIP archive in the "Works in Progress" folder"
Randy, not sure how to do this. Can you give me more detail, how to do this?
Thanks
Joe From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Saturday, March 21, 2015 8:41 AM
Subject: Re: [smf_addin] I get "error" from my smf addin
As Sal noted, these steps usually help when pointers to the add-in get all messed up (for whatever reason):
1. Go to the add-in manager and uncheck the add-in (i.e. existing pointed to location)
2. Exit EXCEL (to purge any connection to the old location)
3. Restart EXCEL
4. Go to the add-in manager and put the add-in back into the list, using its correct location
5. Exit EXCEL (to save the new settings)
6. Restart EXCEL
Since you want to use AdvFN, I'd add a step 2.5 which is to update the files in your add-in folder to the ZIP archive in the "Works in Progress" folder. After step 6, try opening your workbook again. If not working, let me know what this returns:
=RCHGetElementNumber("Version")
The EXCEL workbook you attached worked fine for me.
On Fri, Mar 20, 2015 at 9:48 PM, Joe jtassielli2003@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
I attached a spreadsheet. The tab "hard copy" is valuescopied when I open spreadsheet. The other, is with formulas. There are no unresolved links. I run the "fix links macro"if this should occur. I downloaded the beta version, deleted the 01.30.15version. Also, I get this (print screen below) message when I open myworkbooks. Not sure why?
"Canyou localize it to a single formula, save it in a workbook, and open it, torepeat the error. If so, does the formula look any differently after you openthe file?" NO. running the "fix links" macro, should take care ofthis.
#yiv9427189550 #yiv9427189550 -- #yiv9427189550ygrp-
Sat Mar 21, 2015 2:10 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Hmmm. That's an awful big worksheet. You *WILL* be getting errors with
something that big. The add-in is designed for ad hoc data usage. It can
only access 1000 web page per session. After that, all web pages you
attempt to access with return "Error" results. Your AdvFN access is very
inefficient, because you're getting a new web page for each period, while
there are 5 periods on the web page. That's why you should be using
RCHGetElementNumber() or smfGetAdvFNElement().
On Sat, Mar 21, 2015 at 1:49 PM, Joe jtassielli2003@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Randy, Sal.
>
> =RCHGetElementNumber("Version"), I get,"
>
>
> Stock Market Functions add-in, Version 2.1.2015.03.05 (C:\SMF
> Add-In\RCH_Stock_Market_Functions-2.1.2015.03.15; ; ; 2)
>
>
I don't like that. You should have the ZIP archive name in the folder name
there. It should JUST be "C:\SMF Add-In".
> Still haven't got all cells to work. Attached spreadsheet, hard copy tab
> is values I'm getting. Formula tab, is with formulas.
>
> *"Since you want to use AdvFN, I'd add a step 2.5 which is to update the
> files in your add-in folder to the ZIP archive in the "Works in Progress"
> folder"*
>
> Randy, not sure how to do this. Can you give me more detail, how to do
> this?
>
You should have created a "C:/SMF Add-In" folder, and just extracted the
files into that folder. If there are any existing files there, just tell it
to replace them, since the 2015.03.15 version is the most recent.
It looks like that's what you have, but just not in a good folder name. It
will still work with that folder name, but it makes sharing and updating
difficult.
But your errors may just be that you're trying to access too much data. The
add-in isn't designed for building databases.
Based on the structure I see, I'd also suggest looking at the
smfUpdateDownloadTable process (see "Tips and FAQs" web page). But you
would have to transpose your table.
something that big. The add-in is designed for ad hoc data usage. It can
only access 1000 web page per session. After that, all web pages you
attempt to access with return "Error" results. Your AdvFN access is very
inefficient, because you're getting a new web page for each period, while
there are 5 periods on the web page. That's why you should be using
RCHGetElementNumber() or smfGetAdvFNElement().
On Sat, Mar 21, 2015 at 1:49 PM, Joe jtassielli2003@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Randy, Sal.
>
> =RCHGetElementNumbe
>
>
> Stock Market Functions add-in, Version 2.1.2015.03.
> Add-In\RCH_
>
>
I don't like that. You should have the ZIP archive name in the folder name
there. It should JUST be "C:\
> Still haven't got all cells to work. Attached spreadsheet, hard copy tab
> is values I'm getting. Formula tab, is with formulas.
>
> *"Since you want to use AdvFN, I'd add a step 2.5 which is to update the
> files in your add-in folder to the ZIP archive in the "Works in Progress"
> folder"
>
> Randy, not sure how to do this. Can you give me more detail, how to do
> this?
>
You should have created a "C:/SMF Add-In" folder, and just extracted the
files into that folder. If there are any existing files there, just tell it
to replace them, since the 2015.03.15 version is the most recent.
It looks like that's what you have, but just not in a good folder name. It
will still work with that folder name, but it makes sharing and updating
difficult.
But your errors may just be that you're trying to access too much data. The
add-in isn't designed for building databases.
Based on the structure I see, I'd also suggest looking at the
smfUpdateDownloadTa
would have to transpose your table.
Sat Mar 21, 2015 2:41 pm (PDT) . Posted by:
"Joe" jtassielli2003
Randy,
Will do, I'll redo the Rchgettablecell with RCHgetelementnumber.
Also, can you give some detail on what you suggested below. Not sure how to do this.
"Since you want to use AdvFN, I'd add a step 2.5 which is to update the files in your add-in folder to the ZIP archive in the "Works in Progress" folder"
I use the spreadsheet to screen for good quality stocks, and be able at a quickly look at their earnings history.
Thanks. BTW nice professional work creating the website.
Joe From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Saturday, March 21, 2015 5:10 PM
Subject: Re: [smf_addin] I get "error" from my smf addin
Hmmm. That's an awful big worksheet. You *WILL* be getting errors with something that big. The add-in is designed for ad hoc data usage. It can only access 1000 web page per session. After that, all web pages you attempt to access with return "Error" results. Your AdvFN access is very inefficient, because you're getting a new web page for each period, while there are 5 periods on the web page. That's why you should be using RCHGetElementNumber() or smfGetAdvFNElement().
On Sat, Mar 21, 2015 at 1:49 PM, Joe jtassielli2003@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Randy, Sal.
=RCHGetElementNumbe
|
Stock Market Functions add-in, Version 2.1.2015.03.
I don't like that. You should have the ZIP archive name in the folder name there. It should JUST be "C:\
Still haven't got all cells to work. Attached spreadsheet, hard copy tab is values I'm getting. Formula tab, is with formulas.
"Since you want to use AdvFN, I'd add a step 2.5 which is to update the files in your add-in folder to the ZIP archive in the "Works in Progress" folder"
Randy, not sure how to do this. Can you give me more detail, how to do this?
You should have created a "C:/SMF Add-In" folder, and just extracted the files into that folder. If there are any existing files there, just tell it to replace them, since the 2015.03.15 version is the most recent.
It looks like that's what you have, but just not in a good folder name. It will still work with that folder name, but it makes sharing and updating difficult.
But your errors may just be that you're trying to access too much data. The add-in isn't designed for building databases.
Based on the structure I see, I'd also suggest looking at the smfUpdateDownloadTa
#yiv1599865520 #yiv1599865520 -- #yiv1599865520ygrp-
Sat Mar 21, 2015 3:25 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
On Sat, Mar 21, 2015 at 2:41 PM, Joe jtassielli2003@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Also, can you give some detail on what you suggested below. Not sure how
> to do this.
>
> *"Since you want to use AdvFN, I'd add a step 2.5 which is to update the
> files in your add-in folder to the ZIP archive in the "Works in Progress"
> folder"*
>
It's just a matter of downloading the ZIP archive and extracting the new
files. Looks like you did it...?
> I use the spreadsheet to screen for good quality stocks, and be able at a
> quickly look at their earnings history.
>
You should do as much screening ahead of time, so that you only need to
grab more detailed data on the remaining contenders.
Have you looked at Portfolio123.com? Very comprehensive screening (and
"point-in-time" backtesting) tool.
Also, I'd avoid using a volatile function like TODAY() with add-in
functions, like you're doing with smfPricesByDates(). It makes that formula
volatile, causing it to recalculate with ANY change in the workbook. I
usually replace TODAY() with a reference to a cell containing:
=DATEVALUE(RCHGetYahooQuotes("SPY","d1"))
...which would be the last date that SPY traded. That way, all of the
formulas are non-volatile.
smf_addin@yahoogroups.com> wrote:
>
> Also, can you give some detail on what you suggested below. Not sure how
> to do this.
>
> *"Since you want to use AdvFN, I'd add a step 2.5 which is to update the
> files in your add-in folder to the ZIP archive in the "Works in Progress"
> folder"
>
It's just a matter of downloading the ZIP archive and extracting the new
files. Looks like you did it...?
> I use the spreadsheet to screen for good quality stocks, and be able at a
> quickly look at their earnings history.
>
You should do as much screening ahead of time, so that you only need to
grab more detailed data on the remaining contenders.
Have you looked at Portfolio123.
"point-
Also, I'd avoid using a volatile function like TODAY() with add-in
functions, like you're doing with smfPricesByDates(
volatile, causing it to recalculate with ANY change in the workbook. I
usually replace TODAY() with a reference to a cell containing:
=DATEVALUE(RCHGetYa
...which would be the last date that SPY traded. That way, all of the
formulas are non-volatile.
Sat Mar 21, 2015 6:22 pm (PDT) . Posted by:
jtassielli2003
Cell A2="GIS"
Rchgetelementnumber(a2,5885) I get eps for TSVX:GIS (grey Island system), I want NYSE:GIS (general Mills)
I also tried smfgetadvFNElement function, same result.
How do I have these functions, select the NYSE or NASDAQ company that shares the same symbol with another company on some other exchange.
another example clx, there's TSVX:CLX and NYSE:CLX.
Thanks
Rchgetelementnumber
I also tried smfgetadvFNElement function, same result.
How do I have these functions, select the NYSE or NASDAQ company that shares the same symbol with another company on some other exchange.
another example clx, there's TSVX:CLX and NYSE:CLX.
Thanks
Sat Mar 21, 2015 10:16 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Ahhh. You must be in Canada? If so, it defaults to the Canadian exchanges.
I don't have anything in there, yet, to allow exchange prefixes to be used
on ticker symbols.
On Sat, Mar 21, 2015 at 6:22 PM, jtassielli2003@... wrote:
> Cell A2="GIS"
>
> Rchgetelementnumber(a2,5885) I get eps for TSVX:GIS (grey Island system),
> I want NYSE:GIS (general Mills)
>
> I also tried smfgetadvFNElement function, same result.
>
> How do I have these functions, select the NYSE or NASDAQ company that
> shares the same symbol with another company on some other exchange.
>
> another example clx, there's TSVX:CLX and NYSE:CLX.
>
>
>
I don't have anything in there, yet, to allow exchange prefixes to be used
on ticker symbols.
On Sat, Mar 21, 2015 at 6:22 PM, jtassielli2003@
> Cell A2="GIS"
>
> Rchgetelementnumber
> I want NYSE:GIS (general Mills)
>
> I also tried smfgetadvFNElement function, same result.
>
> How do I have these functions, select the NYSE or NASDAQ company that
> shares the same symbol with another company on some other exchange.
>
> another example clx, there's TSVX:CLX and NYSE:CLX.
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar