I would like transfer / interlink the ephemeris to excel can you recommend how this would be done. Would like to also run a neural network with astrological and forex data

GreatYves,they should be located at experts/files.

Blackprinze,I have checked astrolog,which are the ephemeris I use,and no idea how to download all that info on excel,I think we could go to rentacoder and auction the job

Regards
S

__________________
Equo ne credite,Teucri.

Hi Simba,

I think I have to do that if we can get ephemeris imported to to excel I can easily run an NN how much do you think it would cost?

Peter

Sorry, i must be doing something wrong, so i rename both .txt files to .bin, located them in the expert/files dir, astro.ex4 to indicators, load it, all i see is an empty indicator box with Venus written in top left corner. Tried it on a naked chart, same thing. Running Win7, maybe if i try on my xp box it will work????? Nobody seems to comment this indi.

GreatYves,try these files..bin to to expert/files and indicator to experts/indicators,you should see the same image I atach here,red is Mercury and Blue is Venus..I have windows vista and if this works in vista it should work anywhere
If you still have problems,please say so.

EDIT:I get a mention about Invalid file for the .bin attachments..sorry I can`t upload them here,send me your email in a pm and I will send you the files and charts...

Regards
S

__________________
Equo ne credite,Teucri.

Hi Peter,

I don`t know, but not expensive,rentacoder is full of very good programmers and they are not expensive,specially when related to excel issues...in any case ,give me a couple of days to check with some astro friends if they know any ephemeris that is easily downloadable into excel...If I find no solution then we can talk about rentacoder.

Regards
S

__________________
Equo ne credite,Teucri.

Hi Simba,

I'm about to commission a coder to extract the information and presented in Excel, In order to create accurate forecast please summarise the important that is required from the ephemeris. This can then be imported and presented correctly to the NN

Thanks in advance

The most important thing is to clearly express what you want to achieve,let`s say,for the sake of discussion that you want to predict a good buying point...ok,so what is a good buying point?The effectiveness of the NN will depend on your definition,a point where you can make 100 pips,200 pips,in one day,in 2 days,in one week??..There are many ways to define it and you should choose one of them.

Then,in regards to astro...I would include all longitudinal and latitudinal data of Moon to Pluto,I would include the declinations too...and I would also take into account both a geocentric view and an heliocentric view...Then you will have to calculate aspects(distances in degrees among planets)...I would start by doing so on just a daily base,you can take 00:00 GMT or UTC as the defining point of the day,which is usually what most ephemeris use

You have to think that the more data you include,the better,then if your NN is good enough,it can eliminate the unnecessary inputs,before modelling the ones that may really matter.

OH,and I would use 2 NNs,classification ones..first one for good buying points,with 2 classes 1=good buying point,0=not a good buying point...second NN for good selling points,same kind of classification strategy.

Regards
S

__________________
Equo ne credite,Teucri.

One of the interesting things in astrology is to use it to try to find the sequence of turns in a Forex pair.
If you look at the chart,I have marked with vertical lines the points were we had a Moon-Venus aspect with 90 degrees sequence,they define,for the moment exceptionally well the sequence of turns in AUDJPY.

Since I presume you may be interested ...I have marked the next point too ...it will be next 16th of September,this Wednesday.

Now,some comments...

1-To do it you have to start from either a major top or bottom or an important intermediate one.

2-Do not expect the relationship of the sequence to last forever,but enjoy it for as long as it lasts.

3-Do not pay much importance to the exact hour of the sequence,just check the day and use your system to validate it

4-here you will find the aspects with 2 degrees orbs

8/10/2009::15:40: Moon square Venus :+02°01):
8/17/2009::19:43: Moon conjunct Venus :+02°01):
8/24/2009::12:58: Moon square Venus :-02°01):
9/2/2009::00:00: Moon opposition Venus :-01°33)
9/9/2009::14:52: Moon square Venus :+02°01):
9/16/2009::14:38: Moon conjunct Venus :+02°01):

Hope this has been interesting for you...

Regards
S

Attached Images

moonvenus.gif (79.8 KB, 118 views)

__________________
Equo ne credite,Teucri.

Check this link

Program Complex VegaSviri

1-They have a demo of neuro hit for download,I am testing it at the moment and it works(restricted), it will give you an idea of what you need to do in your NN.

2-It is possible that you can still buy the fully featured program,mail them and check it...but I feel like it is not so....this program and astroelite have practically dissappeared from the web.

Regards
S

__________________
Equo ne credite,Teucri.