Astrobasic script to generate excel with planetary days and hours?

[oneirich]

Someone skilled with Planetdance's scripting language?

Would like to have something that can make an Excel with: date, time, planet of the day and planet time. If that's possible with the scripting language, at least, but I'm guessing so?

[Jean]

If you have programming knowledge take a look at c:\planetdance\ab\Excel.ab, it im/exports to/from .csv files.
Maybe you can start with Application - Edit, give your script a name, now you have an empty window, do in the editor application - templates and use 'horoscope', that will give you something to start with.

[oneirich]

Programming knowledge have, but it's time that is scarce, well it was worth the shot! Thx for your reply !

[ABer]

HI - I have developed Jean's script with additional features, can you describe what you want. All I ask is that if you use this and modify it you let me have your code so that we can continue to improve the features of PD. I don't release this generally as it is a very specialist script for research purposes. Ed

[oneirich]

The two options Planetary Day & Planetary Hour if I like at your screenshot. If the moon sign of that day can be added too that would be perfect...

[ABer]

Hi - you can get sign positions for each of the planets using checkbox Planet Signs (column two, list item two). This will output all the basic planetary listings by Sign (Sun-Pluto, Fortune, Lilith, Asc, MC, Node, Chiron etc). You would then be able to work with the spreadsheet to identify the Moon sign column in particular. The script is a beta really, and needs a bit of understanding to work, so this is why I don't publish it, but release it for researchers if they express an interest. It's not complicated, but needs some knowledge of research/data manipulation.

You can see the output below. The data you want is outputted as integers.

Aries = 1
Taurus = 2
Gemini = 3 etc

The hour and day rulers are:

Sun = 0
Moon =  1
Mercury = 2
Venus = 3
Mars = 4
Jupiter = 5
Saturn = 6

Ed

Ed

[oneirich]

Apologies for the late reply...

If you can share the script that would be more then welcome... If I make any changes I'll submit the endresult.

Thank you for your time

[ABer]

Hi there - could you PM me with your email address and I will send you this file. Thanks. Ed

[VivianV]

Hello 

Hoping that someone could help me with what code to use. I modified planetaryhour.ab to show additional data that I need but I can't get the house to show up. I used :

1. calculate(0, jd, lon, lat, -1)
2. getplanets(0, planet)" and "sign=planet[6]/30 - to get the sign of a particular planet
3. total = getaspects(0, P1, P2, As) - to get aspect

I tried gethousepos but I can't get it to work. I need to get the house of a particular planet.

Thank you

[ABer]

Hi there - you might need to use:

getlonlat

Syntax: getlonlat(char Index, real *Lon, real *Lat)

Action: gets the longitude and latitude of the place from horoscope 'Index'.

Please note: PlanetDance follows the convention of the Swiss Ephemeris calculation routines. Western longitudes are negative, Eastern are positive.

You don't mention if you have filled lon and lat. I think this would be needed to calculate the houses. You could then use gethousepos().

It might be easier if you post the code lines you are using.

To create an array with the longitudes of house cusps use gethouses().

From the help:

gethouses

Syntax gethouses(char Index, real houses[12]);

Action: Gets the houses from internal horoscope 'Index' and puts them into the array 'houses'

Note, the constant 'HOUSES' equals 12.

Example

real houses[HOUSES];
gethouses(0, houses);

If this doesn't work, let me know. Ed

[Jean]

Hi Vivian

Here's a gethousepos() example, i added it to the help.

Code: [Select]

window(333, 333);
gettransit(0, -1);
char pos[PLANETS], s[99];
gethousepos(0, pos);
int i = 0; for (i < ASCENDANT)
  {
  strset(s, "%s is in house %d", planetname[i], pos[i] + 1);
  putstring(0, i * 20, s);
  }
run;


[ABer]

Thanks Jean - that'll be a good addition to the help.

Ed

[VivianV]

Thank you ABer and Jean  for the guidance.

I copied the codes and I will try them over the weekend.

Thank you for creating Planetdance 

[ABer]

Hi - no problem - happy to help. If you have added functionality to the script, it would be really helpful to share the code. It might be something that can be added back into the script for others to benefit from.

Glad that you are enjoying Planetdance.

Ed

[Jean]

@Ed, Vivian already sent me some code.
@Vivian, I'll be happy to help too if you're stuck.