4 Messages
Digest #3020
Messages
Tue Mar 25, 2014 2:05 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You would just create it with something like NotePad, and put your regional
domain in it.
The add-in defaults to using a "www" domain for AdvFN. In some regions,
people get redirected from "www" to something like "uk" or "au" or "in".
Creating the smf-AdvFN-Prefix.txt file in your SMF add-in folder, and
placing that regional domain in it, tells the add-in to use that domain for
any AdvFN requests. If the file doesn't exist, the add-in just uses "www".
That process was added so people didn't need to go in and edit the URL's in
the VBA code. Otherwise, updates would overwrite the VBA changes, which
would need to be changed again.
So, if one machine had an smf-AdvFN-Prefix.txt file with something like
"uk" in it, I would expect the other machine to need it as well.
On Tue, Mar 25, 2014 at 1:34 PM, Nikola Ganev <ganevniko@yahoo.com> wrote:
>
> Sorry Randy, I don't understand, how do I create it?
> And just wondering why would it work on the other machine that does not
> have that smf-AdvFN-Prefix.txt file...
>
>
domain in it.
The add-in defaults to using a "www" domain for AdvFN. In some regions,
people get redirected from "www" to something like "uk" or "au" or "in".
Creating the smf-AdvFN-Prefix.txt file in your SMF add-in folder, and
placing that regional domain in it, tells the add-in to use that domain for
any AdvFN requests. If the file doesn't exist, the add-in just uses "www".
That process was added so people didn't need to go in and edit the URL's in
the VBA code. Otherwise, updates would overwrite the VBA changes, which
would need to be changed again.
So, if one machine had an smf-AdvFN-Prefix.txt file with something like
"uk" in it, I would expect the other machine to need it as well.
On Tue, Mar 25, 2014 at 1:34 PM, Nikola Ganev <ganevniko@yahoo.com> wrote:
>
> Sorry Randy, I don't understand, how do I create it?
> And just wondering why would it work on the other machine that does not
> have that smf-AdvFN-Prefix.
>
>
Tue Mar 25, 2014 2:35 pm (PDT) . Posted by:
dmatu2000
Okay. Let me try a different method. Rather than firm age, does anyone know how to retrieve a stocks IPO date?
Tue Mar 25, 2014 2:50 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Can you substitute the earliest date of Yahoo historical quotes? See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/14544
Won't help if the company is more than 44 years old.
On Tue, Mar 25, 2014 at 2:35 PM, <david_matuszak@yahoo.com> wrote:
>
> Okay. Let me try a different method. Rather than firm age, does anyone
> know how to retrieve a stocks IPO date?
>
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/14544
Won't help if the company is more than 44 years old.
On Tue, Mar 25, 2014 at 2:35 PM, <david_matuszak@yahoo.com> wrote:
>
> Okay. Let me try a different method. Rather than firm age, does anyone
> know how to retrieve a stocks IPO date?
>
Tue Mar 25, 2014 6:50 pm (PDT) . Posted by:
advertise78
hamishthedenizen,
This works perfectly. Thank you! May have been a blessing in disguise as I'm finding some other endemic problems in my spreadsheet. Garbage in, garbage out!
Again, thank you.
Advertise78
This works perfectly. Thank you! May have been a blessing in disguise as I'm finding some other endemic problems in my spreadsheet. Garbage in, garbage out!
Again, thank you.
Advertise78
Tidak ada komentar:
Posting Komentar