Integration of a new Finance::Quote source in gnucash

[Lt. Goose]

Hi Hajo,

Sorry for the delay in the answer, but I wanted to elaborate it so that it
is clear and thorough. If you need more information, feel free to ask.

In order to write the new module, I got a lot of information from the Quote
Hackers Guide (
http://cpansearch.perl.org/src/PJF/Finance-Quote-1.11/Documentation/Hackers-Guide
).

I used an existing quote module as a starting point (I can't remember now
which one I used, but I think it could be Deka.pm). Change the module name
to the one you want and replace all occurrences of that name so that the
module is correctly formatted. You'll find more information about this in
the guide.

First thing you need to locate is a source (URL) where you can get the
quote data. In the end you will retrieve a HTML page with that information.
The quote symbol with be the one used to check the URL that you will be
querying. Data in the HTML page is usually arranged in a table (ideally
with a class name or id or some kind of identifier). I used this guide
http://www.nu42.com/2012/04/htmltableextract-is-beautiful.html to extract
just the table I'm interested in using its table id, which I found using a
DOM inspector in that URL.

If you want an example of this, I used this URL (
http://www.bolsamadrid.es/esp/aspx/Empresas/FichaValor.aspx?Ticker=SAN) to
extract the quotes for Banco de Santander (SAN). If you inspect the html
code, you can see that the prices are located in a table with this id
'ctl00_Contenido_tblPrecios', so you just have to extract all the fields
you need. Tweak the perl file and fill in the fields you need for your
quotes.

You can test your module (you'll have to configure first F::Q to use it, as
stated below) with this command:
  perl gnc-fq-dump -v MODULE_NAME_HERE YOUR_SYMBOL_HERE


* Configuring Finance::Quote and GNUCash with the new module
  ==============================================

I used the information in this guide (
http://stephan.paukner.cc/syslog/archives/401-How-to-add-new-quote-sources-to-GnuCash.html)
to add the new module I wrote. You can check it for more details.

The new module that will retrieve the quotes (let's call it newQuote.pm)
should be placed in the Finance::Quote subfolder (in my version of Windows,
this is located in C:\Perl64\site\lib\Finance\Quote). Afterwards, you have
to modify the file Quote.pm in order to include the new module you've just
created. You have to edit the file and include the quote name in the
@module variable. As an example, change the line:
      @modules = qw/AEX AIAHK ASEGR ASX BMONesbittBurns BSERO Bourso
with this one:
      @modules = qw/AEX AIAHK ASEGR ASX BMONesbittBurns BSERO Bourso
newQuote

If you save the changes, you can check if F::Q recognizes your new module
with gnc-fq-check (the new module should be listed in the output of that
command). If this works, open a new instance of gnucash and assign the fund
the new quote source (it should be listed under the 'unknown' selector).


Hope this helps.

Gus.

2015-07-31 18:00 GMT+02:00 <gnucash-user-request at gnucash.org>:

>    6. Re: Quote date in gnucash different from retrieved by
>       gnc-fq-dump (Hajo Hindriks)
>


> ---------- Mensaje reenviado ----------
> From: Hajo Hindriks <hhn10 at gmx.net>
> To: gnucash-user at gnucash.org
> Cc:
> Date: Fri, 31 Jul 2015 13:21:46 +0200
> Subject: Re: Quote date in gnucash different from retrieved by gnc-fq-dump
> Hi Gus
>
> Would you mind sharing how you accomplished your own source? How did you
> integrate it in F::Q and how was it recognized in Gnucash? I am a new user
> and just got F::Q to work, unfortunately I have a fund that it not
> supported by any of the sources, and the supplier has a page with the price
> information, so I would like to try to write my own quote source as well.
>
> Kind regards, Hajo
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>