What 4 factors do you think the price depends on? - page 6

 
Evgeny Belyaev:
It can be done in a simpler way. Purely through excel. Data tab-text by columns-further- further-detail-change fractional part delimiter with a comma to a dot-ok-done
Yes, you can do it that way. It's simpler.
 
Evgeny Belyaev:

-No normal leverage, therefore ridiculous yields, hence a large deposit is needed.

- Spreads, if you do not take a couple of liquid instruments, are also not very good.

-The same negative mathematical expectation as at Forex, and it seems that one has to pay taxes as well.

Apart from transparent information in the market and in the feed there are no more pluses.

I'm working there and I feel pretty good. ) But the forex market is a bummer so far. ) I don't understand something here.
 
Yuriy Asaulenko:
Yes, you can do that. It's easier.
I tried unloading and got a shortcut.
 
Yousufkhodja Sultonov:
Tried to upload - got a shortcut.

I will check it now.

I will try to download the quotes from there and I can't change them. I downloaded the quotes from there the other day. I have downloaded the quotes from there and I have no problems with them.

Oh, by the way - forex CSV upload - http://www.finam.ru/profile/forex/eur-usd/export/ It's there as well, didn't find it right away.

Right now. Eurobucks for the year instantly. The interval for downloading a file is not more than one year. If more than that, I have to make several requests.

 
Yuriy Asaulenko:

I will check it now.

I want to change the dates, set the beginnings and the parameters you need. I downloaded the quotes from there the other day. I have no problems.

Oh, by the way - forex CSV upload - http://www.finam.ru/profile/forex/eur-usd/export/ It's in there as well, didn't find it right away.

For eurobox for a year instantly. The interval for downloading a file is not more than one year. If it is longer, I will have to make several requests.

I got a file like this, what did I do wrong?

<TICKER>,<PER>,<DATE>,<TIME>,<OPEN>,<HIGH>,<LOW>,<CLOSE>,<VOL>
EURUSD,D,20160502,000000,1.1456700,1.1536200,1.1446000,1.1531100,1296884
EURUSD,D,20160503,000000,1.1534100,1.1616300,1.1493000,1.1495600,1587701
EURUSD,D,20160504,000000,1.1495900,1.1529500,1.1465600,1.1484800,1635331
EURUSD,D,20160505,000000,1.1485700,1.1494000,1.1384000,1.1403700,1367183
EURUSD,D,20160506,000000,1.1404600,1.1480700,1.1384500,1.1403700,1426020
EURUSD,D,20160507,000000,1.1403800,1.1404000,1.1399100,1.1399100,60
EURUSD,D,20160508,000000,1.1398000,1.1403000,1.1388600,1.1393000,3120
EURUSD,D,20160509,000000,1.1400800,1.1420200,1.1373400,1.1382000,1219445
EURUSD,D,20160510,000000,1.1381400,1.1409900,1.1357000,1.1371000,1311132
EURUSD,D,20160511,000000,1.1370000,1.1446700,1.1366900,1.1425800,1248660
EURUSD,D,20160512,000000,1.1425200,1.1430000,1.1368000,1.1374000,1277139
EURUSD,D,20160513,000000,1.1374600,1.1379800,1.1281000,1.1309700,1425563
EURUSD,D,20160514,000000,1.1308000,1.1308800,1.1305000,1.1305000,54
EURUSD,D,20160515,000000,1.1306000,1.1312000,1.1299000,1.1309000,3517
EURUSD,D,20160516,000000,1.1310400,1.1342400,1.1299800,1.1319100,1068815
EURUSD,D,20160517,000000,1.1319000,1.1348700,1.1301000,1.1311800,1245348
EURUSD,D,20160518,000000,1.1311000,1.1321000,1.1212000,1.1214900,1423633
EURUSD,D,20160519,000000,1.1214700,1.1230000,1.1177000,1.1202300,1407593
EURUSD,D,20160520,000000,1.1201800,1.1240000,1.1194300,1.1221900,1123187
EURUSD,D,20160521,000000,1.1222000,1.1222000,1.1219100,1.1219100,31
EURUSD,D,20160522,000000,1.1218000,1.1218900,1.1203400,1.1205700,2561
EURUSD,D,20160523,000000,1.1205600,1.1242900,1.1185000,1.1218500,1041530
EURUSD,D,20160524,000000,1.1219300,1.1227100,1.1131000,1.1140100,1209705
EURUSD,D,20160525,000000,1.1139000,1.1142900,1.1134000,1.1140100,10554

 
Yousufkhodja Sultonov:

Got the following file:

<TICKER>,<PER>,<DATE>,<TIME>,<OPEN>,<HIGH>,<LOW>,<CLOSE>,<VOL>
EURUSD,D,20160502,000000,1.1456700,1.1536200,1.1446000,1.1531100,1296884
EURUSD,D,20160503,000000,1.1534100,1.1616300,1.1493000,1.1495600,1587701

Normal file. The date-time format is wrong, if critical. You are on the day - letter D. And put the period - you can have 1 min or more there. Everything else is fine.
 
Yuriy Asaulenko:
The file is fine. The date-time format is wrong, if critical. You're on the day - letter D. And set a period - you can go from 1 min or more there. Everything else is fine.
Why not use the same data from mt? Just two clicks of the same data?
 

Here, as an example, is the processing of the weekly data from 02 to 06 May 2016:


The equation turns out Euro = 1.79847 + 0.000413*$ - 0.00039*gold - 0.83114*franc +0.422074*pound. We see a complete coincidence of the actual and calculated euro/dollar prices, as there are only 5 initial data points. It could not be otherwise, as this procedure is a kind of test for impeccability of formulas and algorithm. When the amount of data is larger, each tool will show its true face. If you try to recalculate on a calculator, you will not get a match, because not all significant figures are given, which are in the bowels of the computer. I guess it is understandable. I show those who doubt that the calculation formulas and the algorithm itself are impeccable. Now, the algorithm can handle any amount of data and any tool or factor.

 

Hello all!

Good topic. And about - "what does the price depend on?", came up with my vision anddeveloped a new system called "The Picky Husband and the Cunning Wife".

Just these hai lo open types aski mask klose all things considered.

I.e. Price is not one. Divided into Husband and Wife. One pulls up, the other pulls down, but can both agree and amicably 'go'. ъ