Author Topic: Astrobasic script to generate excel with planetary days and hours?  (Read 1714 times)

0 Members and 1 Guest are viewing this topic.

oneirich

  • Newbie
  • *
  • Posts: 5
    • View Profile
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

  • Administrator
  • Sr. Member
  • *****
  • Posts: 294
    • View Profile
Re: Astrobasic script to generate excel with planetary days and hours?
« Reply #1 on: August 20, 2020, 07:47:44 AM »
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.
Greetings from Groningen Netherlands <)))><.`.><(((>

oneirich

  • Newbie
  • *
  • Posts: 5
    • View Profile
Re: Astrobasic script to generate excel with planetary days and hours?
« Reply #2 on: August 20, 2020, 10:25:32 AM »
Programming knowledge have, but it's time that is scarce, well it was worth the shot! Thx for your reply !

ABer

  • Administrator
  • Full Member
  • *****
  • Posts: 235
    • View Profile
Re: Astrobasic script to generate excel with planetary days and hours?
« Reply #3 on: August 20, 2020, 06:15:34 PM »
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

  • Newbie
  • *
  • Posts: 5
    • View Profile
Re: Astrobasic script to generate excel with planetary days and hours?
« Reply #4 on: August 21, 2020, 06:03:11 AM »
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

  • Administrator
  • Full Member
  • *****
  • Posts: 235
    • View Profile
Re: Astrobasic script to generate excel with planetary days and hours?
« Reply #5 on: August 21, 2020, 06:26:44 AM »
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

  • Newbie
  • *
  • Posts: 5
    • View Profile
Re: Astrobasic script to generate excel with planetary days and hours?
« Reply #6 on: August 24, 2020, 04:14:34 PM »
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

  • Administrator
  • Full Member
  • *****
  • Posts: 235
    • View Profile
Re: Astrobasic script to generate excel with planetary days and hours?
« Reply #7 on: September 23, 2020, 07:30:13 AM »
Hi there - could you PM me with your email address and I will send you this file. Thanks. Ed

VivianV

  • Newbie
  • *
  • Posts: 4
    • View Profile
Re: Astrobasic script to generate excel with planetary days and hours?
« Reply #8 on: December 06, 2020, 07:35:39 AM »
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

  • Administrator
  • Full Member
  • *****
  • Posts: 235
    • View Profile
Re: Astrobasic script to generate excel with planetary days and hours?
« Reply #9 on: December 06, 2020, 08:57:58 AM »
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

  • Administrator
  • Sr. Member
  • *****
  • Posts: 294
    • View Profile
Re: Astrobasic script to generate excel with planetary days and hours?
« Reply #10 on: December 06, 2020, 09:52:24 AM »
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;
Greetings from Groningen Netherlands <)))><.`.><(((>

ABer

  • Administrator
  • Full Member
  • *****
  • Posts: 235
    • View Profile
Re: Astrobasic script to generate excel with planetary days and hours?
« Reply #11 on: December 06, 2020, 09:58:17 AM »
Thanks Jean - that'll be a good addition to the help.

Ed

VivianV

  • Newbie
  • *
  • Posts: 4
    • View Profile
Re: Astrobasic script to generate excel with planetary days and hours?
« Reply #12 on: December 08, 2020, 02:23:58 AM »
Thank you ABer and Jean  ;D for the guidance.

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

Thank you for creating Planetdance  :) :) :)

ABer

  • Administrator
  • Full Member
  • *****
  • Posts: 235
    • View Profile
Re: Astrobasic script to generate excel with planetary days and hours?
« Reply #13 on: December 08, 2020, 07:11:19 AM »
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

  • Administrator
  • Sr. Member
  • *****
  • Posts: 294
    • View Profile
Re: Astrobasic script to generate excel with planetary days and hours?
« Reply #14 on: December 08, 2020, 07:58:23 AM »
@Ed, Vivian already sent me some code.
@Vivian, I'll be happy to help too if you're stuck.
Greetings from Groningen Netherlands <)))><.`.><(((>