Automatically import market data such as VAT and currency rates

[Thomasso]

Hello,



my company does international operations and we use currency rates on a daily basis. I would like to automatically feed the database the actual rates for today from a http source. I would like to keep VAT percentage rate as well, maybe even other values.

I would then like to work with the numbers. For example, I have a price list from my suppliers in USD, but I want to display the today's product value in my currency, using the rate from the http. And I want to be able to manually edit the VAT, if it changes.


What would be the best solution for this? I thought of a table, something like tbl_MarketData. But I ran into some problems. I set the VAT format to percentage, but no matter what number I insert, it stays at 0 %. With the currency rate fields, I am unable to display decimal points, even though I have set it to 2 figures. Also, what is the best way to import current data? Or is my approach totally wrong? Is there a better way to deal with this?

Thank you for every insight.

Cheers.
Tomas

[isladogs]

Sounds like you have an integer number datatype. Change it to Single.

[Thomasso]

I tried that but unfortunately it did not help.

[dniezby]

Ooo. I did something like this a while back.

If memory serves, you don’t need a table to hold that meeker data at all. You need a blank field with a name, a script to qwerry the web for the result and a button.

I don’t remember the exact code so hopefully this train of thought will guide you.

So, saying the boxes name is “mrkt-current” then on the action of the button set on_press mrkt_current = qwerry the web

See where I’m going? That way you have the freshest result and it’s a live result.

Hope this helps.


Sent from my iPhone using Tapatalk

[isladogs]

For part of this you may be able to use my Currency Exchange Rate Tracker app http://www.mendipdatasystems.co.uk/cert/4594365453.

Sorry but I can't tell from your description what the issue is with decimal points

[Thomasso]

For part of this you may be able to use my Currency Exchange Rate Tracker app http://www.mendipdatasystems.co.uk/cert/4594365453.

Sorry but I can't tell from your description what the issue is with decimal points

Thank you for the tip, I will check that app out.

It is quite hard for me to describe the issue because I don't use English version of MS Access and everything is named differently. Please see the attached screenshots.


This is the table design tab. The first field is the PK auto counter, then I have Date for the market data, "DPH" is "VAT" in my language, data type "Number", then I have the currency exchange rates.


This is the properties of one of the currency exchange rate. The first value is "decimal number" with 2 numbers after the decimal dot.

Sorry, not sure how else to describe, it's always an issue to operate in a different language. :-)

[Thomasso]

Ooo. I did something like this a while back.

If memory serves, you don’t need a table to hold that meeker data at all. You need a blank field with a name, a script to qwerry the web for the result and a button.

I don’t remember the exact code so hopefully this train of thought will guide you.

So, saying the boxes name is “mrkt-current” then on the action of the button set on_press mrkt_current = qwerry the web

See where I’m going? That way you have the freshest result and it’s a live result.

Hope this helps.


Sent from my iPhone using Tapatalk

Thank very much for the advice, however I don't exactly understand it. What do you mean by "blank field"? Is it a field in a table? What kind of a script do you mean?

Unfortunately you seem to be too advanced for me . Could you please try to explain it "stupidly"? Thanks!

[davegri]

In the exchange property meritko (scale) is the number of decimal places allowed. Set that to 2.

[isladogs]

Davegri is correct if you are using decimal numbers
I'd go further and repeat my previous advice. Change the decimal datatype to Single.