Rabu, 04 September 2013

[smf_addin] Digest Number 2757

7 New Messages

Digest #2757
1a
system seperators by boonem2809
1b
Re: system seperators by "Randy Harmelink" rharmelink
1c
Re: system seperators by eric.dagnelies
2a

Messages

Tue Sep 3, 2013 5:37 am (PDT) . Posted by:

boonem2809


Hi, in Belgium system seperators (comma end point in numbers) are
the inverse as in most of the other countries (thousand we will
write as 1.000 and one and a half as 1,5) This is a parameter you
need to set on the country and language level of Microsoft OS. In
excel you have the option to reverse that again but this does not
seem to work with these functions.

Example: on the Yahoo site i see:
GDF SUEZ S.A. (GSZ.PA) -Paris
16.52 [Down]

which normally i would see in Excel as 16,52 but with the
function RCHGetYahooQuotes i'm getting 16525 without the decimal
sign.

Any idea how to solve this ?


Tue Sep 3, 2013 6:20 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

VBA uses your computer system's regional settings. I only deal with U.S.
stocks and U.S. regional settings, so have no experience outside of that
for my programming.

There are a few items in the LINKS area of the Yahoo group, that others
have tried or suggested.

On Tue, Sep 3, 2013 at 5:05 AM, <boonem2809@yahoo.fr> wrote:

> Hi, in Belgium system seperators (comma end point in numbers) are the
> inverse as in most of the other countries (thousand we will write as 1.000
> and one and a half as 1,5) This is a parameter you need to set on the
> country and language level of Microsoft OS. In excel you have the option to
> reverse that again but this does not seem to work with these functions.
>
> Example: on the Yahoo site i see:
> GDF SUEZ S.A. (GSZ.PA) -Paris
>
> 16.52 [image: Down]
>
> which normally i would see in Excel as 16,52 but with the function
> RCHGetYahooQuotes i'm getting 16525 without the decimal sign.
>
> Any idea how to solve this ?
>

Tue Sep 3, 2013 6:30 am (PDT) . Posted by:

eric.dagnelies


My personnal solution: in all the addIn, CDec(..) replaced with
CDec(Val(...)).



--- In smf_addin@yahoogroups.com, <smf_addin@yahoogroups.com>
wrote:


Hi, in Belgium system seperators (comma end point in numbers) are
the inverse as in most of the other countries (thousand we will
write as 1.000 and one and a half as 1,5) This is a parameter you
need to set on the country and language level of Microsoft OS. In
excel you have the option to reverse that again but this does not
seem to work with these functions.

Example: on the Yahoo site i see:
GDF SUEZ S.A. (GSZ.PA) -Paris
16.52 [Down]

which normally i would see in Excel as 16,52 but with the
function RCHGetYahooQuotes i'm getting 16525 without the decimal
sign.

Any idea how to solve this ?


Tue Sep 3, 2013 8:04 am (PDT) . Posted by:

"raiders8112" raiders8112

Dan,

Thanks for your excellent work. Just curious how do get the financials for different tickers. I had entered a new ticker in cell A1, but the numbers do not change.

Thanks for your help,

Mike

Tue Sep 3, 2013 8:59 am (PDT) . Posted by:

hamishthedenizen


Enter the new ticker in cell A1. Then press F9 to recalculate the
sheet, or Formulas tab > Calculation Options > Calculate Now


I have it set to manual calculation since it's slow, and a pain
if you are making a few edits to have to wait for each one to
run.

You can set it to calculate automatically if you prefer:

Go to the Formulas tab > Calculation Options > Automatic




I was going to reduce the amount of data it pulls from GuruFocus
by calculating some data (why pull earnings, sharecount and EPS
since EPS = earnings/sharecount?) but at some point I had to get
back to my real job :-)



--- In smf_addin@yahoogroups.com, <mike.russo@...> wrote:

Dan,

Thanks for your excellent work. Just curious how do get the
financials for different tickers. I had entered a new ticker in
cell A1, but the numbers do not change.

Thanks for your help,

Mike

Tue Sep 3, 2013 8:55 pm (PDT) . Posted by:

zzzip989


Randy,

Thanks for your reply. I figured I would fill everyone in on my
solution.

After a loooong internet search, someone was nice enough to
provide this fantastic solution for me from Yahoo! Answers:







I've created a node.js script for this.

1). Download 'node.js&#39; from http://nodejs.org/download/
<http://nodejs.org/download/> and install it.

2). Save the script pasted in
http://pastebin.com/raw.php?i=WDT05ebB
<http://pastebin.com/raw.php?i=WDT05ebB> in the location where
you need csv files to be saved.file name can be something like
'finviz.com_exporter.js'

3). Create a schedule task to run the following command.
"node x:\path_to_your_location\filename.js"
Note that the file name should be same as the one you gave
earlier.

That's it!
CSV file will be named as 'finviz.com_DATE&#39;
(finviz.com_2013-7-30)

--- In smf_addin@yahoogroups.com, <smf_addin@yahoogroups.com>
wrote:

I'd suggest a Google search for "Download scheduler"...

On Mon, Sep 2, 2013 at 7:50 PM, <ryan.e.morse@...> wrote:
I need to use something to automatically access a website and
take the data at the end of each weekday - lets say 6pm. Â
Slightly confusing (or maybe easier?) - the website has a link to
export a csv.

From this website: http://www.finviz.com/
screener.ashx?v=151&ft=4
<http://www.finviz.com/screener.ashx?v=151&ft=4>

It runs a stock screen and there is a link on the bottom of the
screen to export a csv (this is the link to download the csv of
the website screen): http://www.finviz.com/export.
ashx?v=151&ft=4 <http://www.finviz.com/export.ashx?v=151&ft=4>

My main goal is for this data to be downloaded somewhere
(preferably to Excel) on my desktop each day - even if I can't
get to my computer. Â The reason behind all this craziness
is that the website does not save historical data so I need to
pull it everyday and archive it myself.Â
My first try was with google docs but I don't know if that's the
best option.
I greatly appreciate the help for whoever is feeling generous :)

Diposting oleh EXCEL FEED LEARNING di 00.45

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)